The MCDBA program and credential is designed for individuals who want to demonstrate that they have the necessary skills to design, implement, and administer Microsoft SQL Server 2000 databases. Database professionals who use or want to learn to use Microsoft SQL Server 2005 should consider the Microsoft Certified Technology Specialist (MCTS) program. Click here to go to the MCTS course description. Microsoft will retire the two SQL Server 2000 exams (exam 70-228 and 70-229) on March 31, 2009.
I. Microsoft Windows Server 2003 Environment Management and Maintenance
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
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 Server 2003 Network Services Planning and Maintenance
A. Network Infrastructure Planning, Tools, and Documentation
B. TCP/IP Physical and Logical Network Planning and Optimization
C. Routing and Switching: Planning and Troubleshooting
D. DHCP: Planning, Optimization and Troubleshooting
E. Developing a DNS Strategy
F. DNS Optimization and Troubleshooting
G. WINS Planning and Optimization
H. Effective IPSec Planning and Troubleshooting
I. Network Access Planning
J. Network Access Troubleshooting
K. Network Infrastructure Planning
IV. Administering a Microsoft SQL Server 2000 Database
A. SQL Server Overview
B. Planning to Install SQL Server
C. Managing Database Files
D. Managing Security
E. Performing Administrative Tasks
F. Backing Up Databases
G. Restoring Databases
H. Monitoring SQL Server for Performance
I. Transferring Data
J. Maintaining High Availability
K. Introducing Replication
V. Programming a Microsoft SQL Server 2000 Database
A. SQL Server Overview
B. Overview of Programming SQL Server
C. Creating and Managing Databases
D. Creating Data Types and Tables
E. Implementing Data Integrity
F. Planning Indexes
G. Creating and Maintaining Indexes
H. Implementing Views
I. Implementing Stored Procedures
J. Implementing User-defined Functions
K. Implementing Triggers
L. Programming Across Multiple Servers
M. Optimizing Query Performance
N. Analyzing Queries
O. Managing Transactions and Locks
Microsoft Certified Database Administrator (MCDBA)
GES 805 -- 460 hours
Course Outline
The MCDBA program and credential is designed for individuals who want to demonstrate that they have the necessary skills to design, implement, and administer Microsoft SQL Server 2000 databases. Database professionals who use or want to learn to use Microsoft SQL Server 2005 should consider the Microsoft Certified Technology Specialist (MCTS) program. Click here to go to the MCTS course description. Microsoft will retire the two SQL Server 2000 exams (exam 70-228 and 70-229) on March 31, 2009.
I. Microsoft Windows Server 2003 Environment Management and Maintenance
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
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 Server 2003 Network Services Planning and Maintenance
A. Network Infrastructure Planning, Tools, and Documentation
B. TCP/IP Physical and Logical Network Planning and Optimization
C. Routing and Switching: Planning and Troubleshooting
D. DHCP: Planning, Optimization and Troubleshooting
E. Developing a DNS Strategy
F. DNS Optimization and Troubleshooting
G. WINS Planning and Optimization
H. Effective IPSec Planning and Troubleshooting
I. Network Access Planning
J. Network Access Troubleshooting
K. Network Infrastructure Planning
IV. Administering a Microsoft SQL Server 2000 Database
A. SQL Server Overview
B. Planning to Install SQL Server
C. Managing Database Files
D. Managing Security
E. Performing Administrative Tasks
F. Backing Up Databases
G. Restoring Databases
H. Monitoring SQL Server for Performance
I. Transferring Data
J. Maintaining High Availability
K. Introducing Replication
V. Programming a Microsoft SQL Server 2000 Database
A. SQL Server Overview
B. Overview of Programming SQL Server
C. Creating and Managing Databases
D. Creating Data Types and Tables
E. Implementing Data Integrity
F. Planning Indexes
G. Creating and Maintaining Indexes
H. Implementing Views
I. Implementing Stored Procedures
J. Implementing User-defined Functions
K. Implementing Triggers
L. Programming Across Multiple Servers
M. Optimizing Query Performance
N. Analyzing Queries
O. Managing Transactions and Locks
