Microsoft Certified Database Administrator (MCDBA) 2003

Computer certification programs are setting the standards for the information technology (IT) industry worldwide. Although most careers in the IT and communications fields are lucrative and lead to rapid advancement, you can move ahead even more rapidly if you have been certified. In fact, you often can earn a salary increase of 20% or more once you become certified. Nowadays, having a degree in computer science just isn't enough. Companies are demanding that their IT professionals be certified as a way to measure their skills as well as to guarantee that they can perform their jobs successfully. In short, certification will help a computer professional get a good job and stay competitive in what is now a highly demanding IT environment.

This training would be beneficial for individuals looking for IT job positions such as: Database Administrators or Microsoft Database Developers.

Take your skills to the next level as a Certified Database Administrator. This training will effectively prepare you to implement and administer Microsoft SQL Server 2000 databases.

Candidates need to pass three core exams and one elective exam that provide a valid and reliable measure of technical proficiency and expertise in the implementation and administration of Microsoft SQL Server databases

Core Exams: SQL Server Administration (One Exam Required)

Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

This course provides students with the knowledge to:

  • Install or upgrade to SQL Server 2000
  • Configure database options—capacity, connectivity, and performance
  • Automate data transfer and manipulation with Data Transformation Services (DTS) packages
  • Use SQL Server replication services
  • Manage security features—authentication, logins, permissions, and alerts
  • Monitor and fine-tune system performance with tools such as SQL Server Agent, SQL Profiler, and the Windows® System Monitor
  • Perform backups and restorations

Core Exams: SQL Server Design (One Exam Required)

Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

This course provides students with the knowledge to:

  • Develop a logical data model
  • Create databases—files, objects, space management, and growth strategy
  • Use Transact-SQL and Data Transformation Services (DTS) to manipulate data; extract data in XML format
  • Program business logic using stored procedures, transactions, triggers, user-defined functions, and views
  • Optimize database performance by using SQL Profiler and the Index Tuning Wizard
  • Design a security plan—data access, object-level security, and application roles

Core Exams: Networking Systems (One Exam Required)

Exam 70-290: Managing and Maintaining a Microsoft Windows Server 2003 Environment

This course provides students with the knowledge to:

  • Create and manage user, group, and computer accounts
  • Manage file and share permissions
  • Help control Web server access and manage sites with Microsoft Internet Information Services (IIS)
  • Manage hardware devices, disk storage, software, and print services
  • Implement backup procedures and perform system recovery

Elective Exams: (One Exam Required)

Exam 70-293: Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure

This course provides students with the knowledge to:

  • Plan TCP/IP network infrastructure, topology, and Internet connectivity
  • Configure server roles and baseline security settings
  • Plan name resolution, routing, and remote access strategies
  • Maintain server availability with clusters and network load balancing
  • Deploy IPSec, harden servers, and manage certificates
  • Design and administer a security infrastructure

Site Code: