Description

As a Microsoft Certified Technology Specialist, you’ll have the knowledge to implement and maintain databases using specific instructions and specifications. You’ll be able to install and configure the SQL Server 2005 and transfer data into it and out of it.

This program will prepare you for four Microsoft exam. The training and certification will help you pursue a career as a database administrator, database developer, or business intelligence developer.

Upon successful completion of this program, you’ll be able to:

• Configure Microsoft Windows 2003 Professional on stand-alone computers and on client computers that are part of a workgroup or domain
• Install, configure, manage, and support a network infrastructure that uses Microsoft Windows 2003 server
• Learn network solution technologies including DHCP, IP, OSPF, RIP, and IGMP
• Gain the knowledge and skills needed to design a security framework for small, medium, and enterprise networks by using Microsoft Windows 2003 technologies
• Install, configure, and monitor SQL Server 2005
• Create and manage database files and databases
• Manage security, transactions, and locks
• Transfer data into and out of SQL Server and replicate data between instances
• Use XML-related features in Microsoft SQL Server 2005Use Service Broker and Notification Services

You’ll also be prepared to take these Microsoft exams:

• 70-290: Managing and Maintaining a Microsoft Windows Server 2003 Environment
• 70-291: Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
• 70-270: Installing, Configuring, and Administering Microsoft Windows XP Professional
• 70-431: Microsoft SQL Server 2005—Implementation and Maintenance

Outline

1. Microsoft Windows Server 2003 Environment Management and Maintenance
   1. An Overview of Account and Resource Administration
   2. User and Computer Account Management
   3. Group Management
   4. Resource Access Management
   5. Printer Implementation
   6. Printer Management
   7. Object Access Management
   8. Group Policy Implementation
   9. Group Policy Management
   10. Administrative Templates and Audit Policy Implementation
   11. Server Administration Preparation
   12. Server Performance Monitoring Preparation
   13. Server Performance
   14. Device Driver
   15. Disk Management
   16. Data Storage Management
   17. Disaster Recovery
   18. Software Maintenance Using the Software Update Service
2. Microsoft Windows Server 2003 Network Services Management
   1. Introducing the TCP/IP Protocol
   2. Assigning IP Addresses in a Multiple Subnet
   3. Configuring a Client IP Address
   4. Configuring a Client for Name Resolution
   5. Isolating Common Connectivity Issues
   6. Using Routing and Remote Access to Configure Routing
   7. Using Dynamic Host configuration Protocol to Allocate IP Addresses
   8. Managing and Monitoring Dynamic Host Configuration Protocol (DHCP)
   9. Name Resolution
   10. Host Name Resolution Using Domain Name System (DNS)
   11. Domain Name System (DNS) Management and Monitoring
   12. NetBIOS Name Resolution Using Windows Internet Name Service (WINS)
   13. Using IPSec and Certificates to Secure Network Traffic
   14. Network Access Configuration
   15. Network Access Management and Monitoring
3. Microsoft Windows XP Professional Administration and Maintenance
   1. Windows XP Installation
   2. Windows XP Installation Automated
   3. Hardware Configuration
   4. Disk Management
   5. File System Configuration and Management
   6. Troubleshooting and Disaster Recovery
   7. Desktop Configuration
   8. TCP/IP Addressing Configuration and Name Resolution
   9. Windows XP Configuration in Microsoft Network
   10. Remote User Management
   11. Mobile Computer Management
   12. System Resource and Performance Monitoring
4. Microsoft SQL Server 2005 Implementation and Maintenance
   1. Installation and Management
   2. Server Set-Up and Database Management
   3. Database Design, Data Types, and Data Tables
   4. Understanding and Managing Indexes, Queries, Functions, and Clauses
   5. Fundamentals of Queries, Statements, Programming, and Views
   6. Programmable Objects and Data Management
   7. Errors, Transaction Locks, Triggers, and XML Data
   8. Working with XML Methods, Indexes, Data, SSIS, and Transferring
   9. Security, Securables, SQL Auditing, Encryption and Decryption, and Common Language Runtime
   10. Working with SQL Server Agent and Distributed Queries, Exploring Replication
   11. Monitoring and Optimization Tools, Database and Query Optimization
   12. Exploring Database Reliability and Availability
   13. Working With and Managing Service Broker, HTTP Endpoints, and Blocks and Deadlocks, Handling SQL Server Errors and Exploring Recovery

Demo

Additional Info

Languages

English

Course Length

480.00 hours

Duration of Access

When you enroll in the program, you’re given a year to complete it. If you need more time, you’ll receive a six-month extension at no charge. If you require another extension beyond the free six-month extension, you can pay a $200.00 U.S. (licensing fee) to Gatlin International for an additional 12-month extension. These extensions will be consecutive (one after the other), so if you step away from the program and come back ready to resume your education, you may do so after paying the licensing fee. This fee may change from one year to the next. Please don’t request an extension until you’ve almost run out of time (determined by end date). This way, you have the option of stepping away from the program for a while if needed, and upon returning, you may catch up, use the free extension, or pay for an additional license in order to complete the program.

Instructor

Chris Lobban brings his industry experience with an extensive assortment of hardware and software solutions. Before starting at Academy of Learning he had worked both in a Help Desk environment and as a Quality Assurance Analyst, where he had to deal with a wide array of different hardware requirements, operating systems, and computer programs every day. This broad experience base, added to his formal training as a Computer Networking and Technical Support Specialist from Seneca College, gives him the training and experience needed to provide support to his students. Chris has also certified his experience by earning the CompTIA A+ IT Technician, Network+, Server+ and Security+ credentials, as well as the Microsoft MCSE (Windows Server 2003), MCSA (Windows Server 2003) and MCDST (Windows XP) credentials.

Prerequisites/Audience

To enroll in this program, you should have basic knowledge of the Microsoft Windows operating system and its core functionality, working knowledge of Transact-SQL, working knowledge of relational databases, and some experience with database design.

This program is for you if you’re interested in becoming an MCTS, especially if you want to work as a database administrator, database developer, or business intelligence developer.

Requirements/Materials Included

We highly recommend that you have a high-speed Internet connection (DSL or cable).

You’ll need to download the following software:

• Adobe Acrobat Reader
• Internet Explorer 6 or higher
• WindowsMedia Player or RealOne Player
• WinZip

Programs are only compatible with Microsoft operating systems and Internet Explorer.

Minimum Hardware Requirements:

• Monitor: 15" Super VGA Monitor (17" is best)
• Processor: Pentium 300, Pentium IV 500, or better
• Network Adapter: 10 base T
• RAM: At least 128MB
• Hard Drive: At least 4 GB
• CD Drive: CD-ROM drive (24x or greater)
• Sound Card: 16 Bit
• Video Adaptor: At least 8MB
• Sound: Headset (a microphone is optional)
• Screen Resolution: 800 x 600 true color (1024 x 768 is best)
• Operating System: Windows 98 or Windows 2000 Pro or Server, Windows XP and/or Windows Me
• Internet Connection: cable modem or DSL

The materials included with this program are:

• Microsoft approved curriculum textbooks
• Access to an online IT library