Back To Microsoft Training Courses

Microsoft Certified Database Administrator (MCDBA) Certification Training CBT

Price: $499.00

MCDBA CBT Course Overview:

IT professionals planning to become certified as an MCDBA should take this certification training. Candidates are required to pass a total of four exams - three core exams and one elective exam.

Please refer to the official Microsoft MCDBA web page for complete certification details.

Total Training Duration:

120 hours

MCDBA CBT Course Modules:

• Microsoft SQL Server 2000 Database Administration Exam 70-228
• Microsoft SQL Server 2000 Designing and Implementing Databases Exam 70-229
• Microsoft Windows Server 2003 Managing a Server Environment Exam 70-290
• Microsoft Windows 2000: Network Infrastructure Administration Exam 70-216

Training Course Topics:

• Identify the features and functions of SQL Server.
• Identify the components involved in the client-server communication process.
• Identify the steps in the client-server communication process.
• Identify the minimum hardware requirements for SQL Server 2000.
• Identify the typical hardware optimization issues for Microsoft SQL Server 2000.
• Select an appropriate edition of SQL Server 2000.
• Identify the different types of SQL Server 2000 installations.
• Install a default instance of SQL Server 2000.
• Identify the database option categories.
• Identify features of the tools used to view database properties.
• View database information by using SQL Server Enterprise Manager.
• Match the different types of data integrity with their characteristics.
• Identify the different types of constraints.
• Identify guidelines for creating constraints.
• Identify how login accounts are processed.
• Identify the characteristics of the two authentication modes.
• Sequence the steps to implement an authentication mode.
• Identify the guidelines for preventing data loss.
• Match database recovery models with their features.
• Identify the process behind SQL Server 2000 backup.
• Identify guidelines for importing and exporting data.
• Match SQL Server 2000 tools used to import and export data with their functions.
• Identify the features and functions of the Data Transformation Services (DTS) process.
• Identify the features of distributed data.
• Identify the different methods of distributing data.
• Identify guidelines for configuring SQL Server Agent.
• Identify guidelines for using SQLAgentMail and SQL Mail.
• Configure a Microsoft Outlook Exchange profile for your administrative account.
• Identify the goals of SQL Server 2000 monitoring.
• Identify guidelines for performance tuning.
• Identify the factors to consider when detecting database performance problems.
• Identify the features and functions of SQL Server 2000.
• Match the components of the client-server communication process with their features.
• Identify the features and functions of SQL Server 2000 services.
• Match the basic types of statements used in Transact-SQL with their functions.
• Identify the SQL Server 2000 system-supplied data types.
• Add a user defined data type.
• Match the parts of a data row with their features.
• Identify characteristics of entity modeling.
• Identify features of attributes.
• Identify requirements for logical modeling.
• Identify the login authentication modes and methods used by SQL Server 2000.
• Identify the features of views.
• Identify the considerations for creating views.
• Create a view by using Transact-SQL.
• Match the different user-defined functions with their characteristics.
• Create a user-defined function by using Transact-SQL.
• Identify characteristics of schema binding.
• Identify the features of stored procedures.
• Identify the features of clustered indexes.
• Identify the features of nonclustered indexes.
• Retrieve information from the sysindexes table.
• Identify guidelines for creating indexes.
• Identify the considerations for creating unique indexes.
• Identify the considerations for creating composite indexes.
• Identify the features of distributed data.
• Identify the different methods of distributing data.
• Match the replication types with their characteristics.
• Identify the considerations for using transactions and locks.
• Create a Transact-SQL script to define a transaction.
• Create a Transact-SQL script to rollback a transaction.
• To match Windows Server 2003 editions with their features.
• To match logon options with their functions.
• To identify features and functions of administrative tools.
• To identify guidelines for creating a user account.
• To identify options for creating user accounts.
• To identify guidelines for creating a user account template.
• To identify reasons for enabling and disabling accounts.
• To identify reasons why users are locked out of accounts.
• To match group membership types with their tasks.
• To identify features and functions of the Run as command.
• To identify tools to administer a remote server using Computer Management.
• To identify features and functions of disk partitioning.
• To identify features of basic disks and dynamic disks.
• To identify features and functions of a simple volume.
• To identify options in Device Manager.
• To identify options in the Add Hardware Wizard.
• To identify features of Windows Update and Automatic Updates.
• To identify options for configuring Automatic Updates.
• To identify features and functions of SUS.
• To identify guidelines for creating a performance baseline.
• To identify features and functions of Task Manager.
• To identify features and functions of the Performance console.
• To identify features and functions of counter logs.
• To match counter log file formats with their features and functions.
• To identify options to create an alert.
• Much more.

Looking for Microsoft Certification Training?

Get all Microsoft Certification Training for only $1,499.00. For more info. click here.