Microsoft Certified Technology Specialist: SQL Server 2005 (MCTS) Certification Preparation Program »  GES 816 » 480 hours

Overview Description Objectives Outline Prerequisites PC Requirements / Materials Instructor Bio FAQs See a Demo More Programs

  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

More Programs in IT and Software Development