The eLearning Center for Gatlin Education Services

Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) implement and maintain databases using specific instructions and specifications. They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface. Technology Specialists typically pursue careers as database administrators, database developers, or business intelligence developers. They may also be developers and systems administrators who do not work with SQL Server daily but who want to show their breadth of technology experience.

Students receive instruction that provides preparation foundation for the Microsoft MCTS: SQL Server 2005 exam: 70-431 - Microsoft SQL Server 2005 - Implementation and Maintenance as well as for the Microsoft MCSA series of exams: 70-270 - Installing, Configuring, and Administering Microsoft Windows XP Professional; 70-290 - Managing and Maintaining a Windows Server 2003 Environment; 70-291 - Implementing, Managing, and Maintaining a Windows Server 2003 Network Infrastructure.

Course Objectives

• Identify the tasks involved in supporting Windows 2003 networks.
• Understand how networking concepts are implemented in Windows 2003
• Configure Microsoft Windows 2003 Professional on stand-alone computers and on client computers that are part of a workgroup or domain.
• Install and configure Windows 2003 Server.
• Install, configure, manage and support a network infrastructure that uses Microsoft Windows 2003 server.
• Gain skills needed to create a networking services infrastructure design that supports the required network applications.
• 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.
• Create, backup and restore databases.
• Manage security, transactions and locks.
• Transfer data into and out of SQL Server.
• Replicate data between SQL Server instances.
• Use XML-related features in Microsoft SQL Server 2005.
• Plan, create, and optimize indexes.
• Implement data integrity in Microsoft SQL Server 2005 databases by using constraints and triggers.
• Implement views, stored procedures, and functions.
• Implement managed code in the database.
• Use Service Broker to build a messaging-based solution.
• Use Notification Services to generate and send notifications.
• Be prepared to take 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.

I. Microsoft Windows Server 2003 Environment Management and Maintenance (NGMS2273)
A. An Overview of Account and Resource Administration
B. User and Computer Account Management
C. Group Management
D. Resource Access Management
E. Printer Implementation
F. Printer Management
G. Object Access Management
H. Group Policy Implementation
I. Group Policy Management
J. Administrative Templates and Audit Policy Implementation
K. Server Administration Preparation
L. Server Performance Monitoring Preparation
M. Server Performance
N. Device Driver
O. Disk Management
P. Data Storage Management
Q. Disaster Recovery
R. Software Maintenance Using the Software Update Service

II. Microsoft Windows Server 2003 Network Services Management (NGMS2276-7)
A. Introducing the TCP/IP Protocol
B. Assigning IP Addresses in a Multiple Subnet
C. Configuring a Client IP Address
D. Configuring a Client for Name Resolution
E. Isolating Common Connectivity Issues
F. Using Routing and Remote Access to Configure Routing
G. Using Dynamic Host configuration Protocol to Allocate IP Addresses
H. Managing and Monitoring Dynamic Host Configuration Protocol (DHCP)
I. Name Resolution
J. Host Name Resolution Using Domain Name System (DNS)
K. Domain Name System (DNS) Management and Monitoring
L. NetBIOS Name Resolution Using Windows Internet Name Service (WINS)
M. Using IPSec and Certificates to Secure Network Traffic
N. Network Access Configuration
O. Network Access Management and Monitoring

III. Microsoft Windows XP Professional Administration and Maintenance (NGMS2272)
A. Windows XP Installation
B. Windows XP Installation Automated
C. Hardware Configuration
D. Disk Management
E. File System Configuration and Management
F. Troubleshooting and Disaster Recovery
G. Desktop Configuration
H. TCP/IP Addressing Configuration and Name Resolution
I. Windows XP Configuration in Microsoft Network
J. Remote User Management
K. Mobile Computer Management
L. System Resource and Performance Monitoring

IV. Microsoft SQL Server 2005 Implementation and Maintenance (NGMS2779-80)
A. Installation and Management
B. Server Set-Up and Database Management
C. Database Design, Data Types and Data Tables
D. Understanding and Managing Indexes, Queries, Functions and Clauses
E. Fundamentals of Queries, Statements, Programming, and Views
F. Programmable Objects and Data Management
G. Errors, Transaction Locks, Triggers and XML Data
H. Working with XML Methods, Indexes, Data, SSIS, and Transferring
I. Security, Securables, SQL Auditing, Encryption and Decryption, and Common Language Runtime
J. Working with SQL Server Agent and Distributed Queries, Exploring Replication
K. Monitoring and Optimization Tools, Database and Query Optimization
L. Exploring Database Reliability and Availability
M. Working with and Managing Service Broker, HTTP Endpoints, and Blocks and Deadlocks, Handling SQL Server Errors and Exploring Recovery