Microsoft Certified Database Administrator (MCDBA)
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.
The Microsoft Certified Database Administrator (MCDBA) 2003 on Microsoft SQL 2000
credential is the premier certification for professionals who implement and administer
Microsoft SQL Server™ databases. This program will train and prepare students to sit for the
official Microsoft MCDBA certification. The certification is appropriate for individuals who
derive physical database designs, develop logical data models, create physical databases, create
data services by using Transact-SQL, manage and maintain databases, configure and manage
security, monitor and optimize databases, and install and configure SQL Server. The MCDBA
2003 on SQL 2000 Certification is appropriate for database administrators, database analysts or
database developers. By earning the premier MCDBA 2003 on SQL 2000 credential,
individuals are demonstrating that they have the skills necessary to lead organizations in the
successful design, implementation, and administration of SQL Server databases.
Upon registering, you are given an initial 12 months to complete the program. Should you need
more time, you may request a 6-month extension.
Upon successful completion of this course, the student should:
o Demonstrate professional conduct and interpersonal communication skills.
o Install, upgrade, configure, and administer computer networking systems hardware and
o Demonstrate an understanding of problem-solving methods essential to troubleshooting
a network infrastructure.
o Demonstrate knowledge of the key services used in a typical network environment.
o Demonstrate the basic skills in PC troubleshooting by using software diagnostic tools,
test cards, and test equipment.
o Network PCs in both local and remote areas and optimize for performance.
o Demonstrate a functional understanding of operating systems principles and
o Describe SQL Server architecture.
o Plan for a SQL Server installation, and then install an instance of SQL Server.
o Manage files and databases, including determining resource requirements.
o Choose a login security method, configure login security, plan and implement database
permissions, and describe how to help protect SQL Server in an enterprise network.
o Perform and automate administrative tasks and create custom administrative tools.
o Back up databases and implement a backup strategy.
o Restore databases.
o Monitor and optimize SQL Server performance.
o Transfer and migrate data into databases.
o Maintain the high availability of SQL Server.
o Describe how to replicate data from one SQL Server to another.
o Be prepared to take Microsoft exams 70-290 – Maintaining a Microsoft Windows
Server 2003 Environment, 70-291 – Implementing, Managing, and Maintaining a
Microsoft Windows Server 2003 Network Infrastructure, 70-293 – Planning and
Maintaining a Microsoft Windows Server 2003 Network Infrastructure, 70-228 –
System Administration for Microsoft SQL Server 2000, and 70-229 – Designing and
Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
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
o 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
An MCDBA candidate should have six to 12 months of experience working with a desktop operating
system, a network operating system, and an existing network infrastructure and should have at least
one year of experience working with SQL Server.
PC Requirements/Materials Included
This course is compatible with Windows Vista Operating System.
It is Highly Recommended that students have a high speed internet connection (DSL or Cable) -
Programs are only compatible with Microsoft Operating System and Internet Explorer.
Following is the list of software that must be downloaded:
o Adobe Acrobat Reader version 5
o Excel Viewer
o Internet Explorer 6
o WindowsMedia Player 7.1 for WIN 98. WIN 2000 and WIN Me
o RealOne Player
o PowerPoint Viewer
o Word Viewer
o WinZip 8
Minimum Monitor: 15" Super VGA Monitor (minimum) 17" is best
Minimum Processor: Pentium 300 or better
Network Adapter: 10 base T
Minimum RAM: At least 128MB
Minimum Hard Drive: At least 4 GB
Minimum CD Drive: CD-ROM drive (24x or greater)
Minimum Sound Card: 16 Bit
Minimum Video Adaptor: At least 8MB
Sound: Headsets (Microphone optional)
Minimum Screen Resolution: 800 x 600 true color (1024 x 768 is best)
Minimum Operating System: Windows 98 or Windows 2000 Professional
Internet Connection: Cable modem or ADSL
The materials included with this course are:
o Microsoft Official textbooks
o Access to an online IT Library
Clara Margaret Czégény is the Senior Trainer and Online Support Specialist/Mentor for Academy
ONLINE. She has also enjoyed a successful career as an IT Trainer at DeVry Institute of Technology
in Mississauga and Shaw IT Business College in Hamilton, Ontario where she taught the MCSE
curriculum as well as popular Desktop Applications and Internet/Intranet Web courses. Well-qualified
for the position of MCT, Clara also completed several years in the Public Teaching sector where she
proved her teaching skills with young students from Grades JK to OAC's. Her continued interest in
training led her to earn an Honours Gerontology Degree from McMaster University where she polished
her presentation skills and demonstrated a solid understanding of principles of adult education. Clara
has achieved her Microsoft MCT, MCSE (NT4, W2K, W3K), MCSA (W3K), MCP+Internet
certifications, CompTia A+ and Network+ certifications. She holds an Ontario Teacher's Certificate,
and a B.A., Hons. B.A. and B.Ed, B.Sc.(Hons).