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
Microsoft Certified Technology Specialist: SQL Server 2005 (MCTS)
GES 816 -- 480 hours -- Certification Preparation Program
Course Outline
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










































