Chapter 1: Introduction to Microsoft Windows 2000

• Overview of Windows 2000
• Operating System Architecture
• Windows 2000 Directory Services

Chapter 2: Installing and Configuring Microsoft Windows 2000 Server

• Preparing to Install Windows 2000 Server
• Installing Windows 2000 Server
• Upgrading to Windows 2000 Server
• Troubleshooting a Windows 2000 Server Installation

Chapter 3: Unattended Installations of Microsoft Windows 2000 Server

• Preparing for an Unattended Installation of Windows 2000 Server
• Automating the Installation of Windows 2000 Server
• Automating the Installation of Server Applications

Chapter 4: Microsoft Windows 2000 File Systems

• Disk Management Basics
• File Allocation Table (FAT)
• NT File System (NTFS)
• File System Security

Chapter 5: Advanced File System

• Distributed File System
• File Replication Service

Chapter 6: Active Directory Services

• Overview of Active Directory Services
• Planning Active Directory Implementation
• Implementing Active Directory Services
• Administering Active Directory Services

Chapter 7: Administering Microsoft Windows 2000 Server

• Using the Microsoft Management Console
• Administering User Accounts
• Administering Group Accounts
• Administering Group Policies

Chapter 8: Administering Print Services

• Introduction to Windows 2000 Printing
• Setting Up Network Printers
• Administering Network Printers
• Printing and Active Directory Services
• Connecting to Network Printers

Chapter 9: Network Protocols and Services

• Network Protocols
• Transmission Control Protocol/Internet Protocol
• Dynamic Host Configuration Protocol Service
• Windows Internet Naming Service
• Domain Name System

Chapter 10: Routing and Remote Access Service

• Introduction to the Routing and Remote Access Service
• Features of the Routing and Remote Access Service
• Remote Access
• Virtual Private Networks
• RRAS Tools

Chapter 11: Microsoft Windows 2000 Security

• Public Key Infrastructure
• Public Key Technologies
• The Kerberos Protocol in Windows 2000
• Security Configuration Tools
• Microsoft Windows 2000 Auditing

Chapter 12: Reliability and Availability

• Managing Hardware Devices and Drivers
• Backing Up Data
• Implementing Disaster Protection
• Recovering from a Disaster

Chapter 13: Monitoring and Optimization

• Disk Monitoring and Optimization
• Simple Network Management Protocol Service
• Performance Console
• Network Monitor
• Task Manager

Chapter 14: Microsoft Windows 2000 Application Servers

• Exploring Microsoft Internet
• Administering a Web Environment
• Configuring and Running Telnet Services
• Installing and Configuring Terminal Services

Chapter 1: Designing a Windows 2000 Network

• Network Services Overview
• Developing a Network Implementation Plan
• Common Protocols Supported by Windows 2000

Chapter 2: Implementing TCP/IP

• TCP/IP Overview
• Internet Protocol Addressing
• Microsoft TCP/IP Installation and Configuration
• Basic Concepts of IP Routing

Chapter 3: Implementing NWLink

• Introducing NWLink
• Using Gateway Service for NetWare
• Using Client Service for NetWare
• Installing and Configuring NWLink

Chapter 4: Monitoring Network Activity

• Introducing Network Monitor
• Using Network Monitor
• Windows 2000 Administration Tools

Chapter 5: Implementing IPSec

• Introducing and Enabling IPSec
• Configuring IPSec
• Customizing IPSec Policies and Rules
• Monitoring IPSec

Chapter 6: Resolving Network Host Names

• TCP/IP Naming Schemes
• Host Names
• The HOST File

Chapter 7: Implementing Domain Name System (DNS)

• Introducing DNS
• Name Resolution and DNS Files
• Planning a DNS Implementation
• Installing DNS
• Configuring DNS

Chapter 8: Using Windows 2000 Domain Name Service

• Working with Zones
• Working with Servers

Chapter 9: Implementing Windows Internet Name Service (WINS)

• Introduction to WINS
• The WINS Resolution Process
• Implementing WINS
• Configuring WINS Replication

Chapter 10: Implementing Dynamic Host Configuration Protocol (DHCP)

• Introducing and Installing DHCP
• Configuring DHCP
• Integrating DHCP with Naming Services
• Using DHCP with Active Directory
• Troubleshooting DHCP

Chapter 11: Providing Your Clients Remote Access Service (RAS)

• Introducing Remote Access Service
• Configuring a Routing and Remote Access Service
• Implementing IP Routing on a Remote Access Service
• Supporting Virtual Private Networks
• Supporting Multilink Connections
• Using Routing and Remote Access with DHCP
• Managing and Monitoring Remote Access

Chapter 12: Supporting Network Address Translation (NAT)

• Introducing NAT
• Installing Internet Connection Sharing
• Installing and Configuring NAT

Chapter 13: Implementing Certificate Services

• Introducing Certificates
• Installing and Configuring Certificate Authority
• Managing Certificates

Chapter 14: Implementing Enterprise-Wide Network Security

• Implementing Network Security
• Configuring Routing and Remote Access Security
• Monitoring Security Events

• Lesson 1: Review of SQL Server

• Lesson 2: Exploring Transact - SQL
  • What is Transact-SQL?
  • Transact-SQL Statements
  • Programming in Transact-SQL

  　

• Lesson 3: Designing and Implementing Databases
  • Identifying Database Design Issues
  • Creating Databases
  • Managing Databases

  　

• Lesson 4: Creating and Managing Tables
  • Creating Tables
  • Managing Tables
  • Scripting Tables

  　

• Lesson 5: Designing Data Integrity
  • Understanding Data Integrity
  • Implementing Constraints

  　

• Lesson 6: Implementing Indexes
  • Designing Indexing
  • Implementing Indexes
  • Maintaining Indexes

  　

• Lesson 7: Joining Tables
  • Querying Multiple Tables
  • Implementing Advance Table Joins

  　

• Lesson 8: Designing Advance Queries
  • Designing Subqueries
  • Changing Data through Queries

  　

• Lesson 9: Using Functions
  • Working with Aggregate Functions

  　

• Lesson 10: Designing Views
  • Creating and Managing Views

  　

• Lesson 11: Creating Stored Procedures
  • Designing Stored Procedures
  • Creating Stored Procedures
  • Using Parameters in Stored Procedures
  • Managing Stored Procedures

  　

• Lesson 12: Creating Triggers
  • Designing Triggers
  • Creating Triggers

  　

• Lesson 13: Understanding Transactions and Locks
  • Designing and Implementing Transactions
  • Managing Locks

  　

• Lesson 14: Implementing Distributed Queries
  • Establishing Linked Servers
  • Creating and Managing Distributed Queries

  　

• Lesson 15: Implementing Advanced Queries
  • Implementing the Microsoft Search Service
  • Using Microsoft English Query

  　

• Lesson 16: Review of SQL 2000 System Administration
  • Answering Questions
  • Practice Test 1 Review
  • Practice Test 2 Review
  • Questions

  　

• Lesson 17: Review of SQL 2000 Database Design
  • Answering Questions
  • Practice Test 3 Review
  • Final Questions
  • MCSE Test SQL 2000 Database Design

• Lesson 1: Introduction to Microsoft SQL Server
  • Exploring the components of SQL Server
  • Identifying SQL Server administration tasks
• Lesson 2: Installing SQL Server
  • Identifying the requirements for installing SQL Server
  • Installing SQL Server
  • Exploring the SQL Server installation
  • Troubleshooting the SQL Server installation
• Lesson 3: Designing and implementing databases
  • Developing a strategy for implementing databases
  • Creating databases
  • Managing databases
• Lesson 4: Creating and managing tables
  • Creating tables
  • Working with tables
  • Using Microsoft Access to connect to a SQL server
• Lesson 5: Designing and configuring SQL Server security
  • Identifying the security features of SQL Server
  • Creating login IDs
  • Assigning login IDs as database users
  • Implementing statement and object permissions
  • Designing a security strategy
• Lesson 6: Importing and exporting data
  • Introduction to data transfer
  • Bulk data transfers
• Lesson 7: Monitoring SQL Server
  • Designing a strategy for monitoring SQL Server
  • Using monitoring tools
• Lesson 8: Backing up SQL Server databases
  • Planning backups
  • Performing a backup
  • Designing your backup strategy
• Lesson 9: Restoring SQL Server databases
  • Identifying methods to restore databases
  • Restoring databases and transaction logs
  • Recovering system databases
• Lesson 10: Automating SQL Server administration
  • Configuring SQL Server to send mail
  • Defining SQL operators
  • Managing jobs
  • Managing alerts
• Lesson 11: Designing and implementing replication
  • Introduction to replication
  • Configuring replication
• Lesson 12: Managing replication
  • Monitoring and maintaining replication
  • Troubleshooting replication
• Lesson 13: Publishing SQL Server data on a Web page
  • Creating a Web page

• Lesson 1: Review of SQL 2000 System Administration
  • Final Questions
  • Test SQL 2000 System Administration