MCDBA

 Windows 2000 Server

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

 Windows 2000 Network Infrastructure Administration

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

 Personal Study/Makeup Test Days

MS SQL 2000 Database Design

  • 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

 MS SQL 2000 System Administration

  • 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

 MS SQL 2000 System Administration

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