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


Add to:
Add to Del.icio.usDel.icio.us Add to DiggDigg Add to GoogleGoogle Add to SpurlSpurl Add to YahooYahoo Add to BlinkBlink Add to FurlFurl Add to StumbleStumble


    • Course Overview/Description Course Objectives Course Outline Prerequisites/Audience PC Requirements/Materials Included Instructor Bio FAQs See a Demo
  •  
  • 3ds max
  • Administrative Professional with Microsoft Certified Application Specialist Training
  • Administrative Professional with Microsoft Office Specialist
  • ASP.NET Training
  • AutoCAD 2007
  • AutoCAD 2009
  • Cisco® CCENT™ Authorized Certification Training
  • Cisco® CCNA® Authorized Certification Training
  • CompTIA™ A+ Certification Training
  • CompTIA™  Linux+/LPI Level One Certification Training
  • CompTIA™ Network+/Server+ Certification Training
  • CompTIA™ Security+ Certification Training
  • eBusiness Certificate
  • English as a Second Language - Global English
  • Forensic Computer Examiner
  • Help Desk Analyst: Tier 1 Support Specialist
  • Microsoft Access 2007
  • Microsoft Certified Application Specialist Training (MCAS)
  • Microsoft Certified Database Administrator (MCDBA)
  • Microsoft Certified Desktop Support Technician (MCDST)
  • Microsoft Certified System Administrator 2003 (MCSA)
  • Microsoft Certified System Administrator Plus 2003 (MCSA+)
  • Microsoft Certified System Engineer 2003 (MCSE)
  • Microsoft Excel 2007
  • Microsoft Office Specialist 2003 (MOS)
  • Microsoft Outlook 2007
  • Microsoft PowerPoint 2007
  • Microsoft Vista Business
  • Microsoft Word 2007
  • Pay Per Click Marketing
  • RFID (Radio Frequency Identification) on the Web™
  • Search Engine Marketing
  • Search Engine Optimization
  • Web Database Developer
  • Webmaster

Microsoft Certified Technology Specialist: SQL Server 2005 (MCTS)

GES 816 -- 480 hours

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


    Add to:
    Add to Del.icio.usDel.icio.us Add to DiggDigg Add to GoogleGoogle Add to SpurlSpurl Add to YahooYahoo Add to BlinkBlink Add to FurlFurl Add to StumbleStumble


Find a School