MS SQL Server 2000 Administration - MCDBA Exam 70-228 Taining Course Midlands | Birmingham | Telford | Stafford | Wolverhampton

A three day intensive course equipping participants with the skills necessary to install and administer Microsoft SQL Server 20000. This course prepares candidates to take the MCDBA 70-228 exam.

Topics covered include

Getting started with SQL Server 2000
SQL Server introduction
SQL Server features
SQL Server installation
Special installation concerns
Database administration

Databases and capacity planning
SQL Server organization and data storage
Database management
Capacity planning and management

Database and object management
Managing databases
Database object fundamentals

Data management
Data conversions
Bulk copy program (bcp) and BULK INSERT
INSERT, UPDATE, DELETE, and SELECT INTO
Data Transformation Services (DTS)
Data migration planning

Backup, restore, and fault tolerance
Data security
Database backup
Database restore
Managing data security

Client configuration and management
Network communications
XML support

Security management
Server login and database user management
Security management
Security planning

Distributed data environment
Nonlinked servers
Linked servers

Replication management
Replication concepts
Publishing and distribution
Managing subscriptions
Replication planning and management

Ongoing management
SQL Mail
Automating management
SQL Server management

Monitoring and optimization
Monitoring overview
Windows monitoring tools
SQL Server monitoring tools
Database optimization