You must pass one exam that focuses on the implementation and maintenance
of SQL Server 2005.
the following courses helps you to prepare to this exam.
1) Workshop 2779: Implementing a Microsoft SQL Server 2005 Database
This five-day instructor-led course provides students with the knowledge and skills
to implement a Microsoft SQL Server 2005 database. The course focuses on teaching
individuals how to use SQL Server 2005 product features and tools related to implementing
a database.
Audience
This course is intended for IT Professionals who want to become skilled on SQL Server
2005 product features and technologies for implementing a database.
At Course Completion
After completing this course, students will be able to:
|
|
Create databases and database files.
|
|
|
Create data types and tables.
|
|
|
Use XML-related features in Microsoft SQL Server 2005.
|
|
|
Plan, create, and optimize indexes.
|
|
|
Implement data integrity in Microsoft SQL Server 2005 databases by using constraints.
|
|
|
Implement data integrity in Microsoft SQL Server 2005 by using triggers.
|
|
|
Implement views.
|
|
|
Implement stored procedures.
|
|
|
Implement functions.
|
|
|
Implement managed code in the database.
|
|
|
Manage transactions and locks.
|
|
|
Use Service Broker to build a messaging-based solution.
|
|
|
Use Notification Services to generate and send notifications.
|
Prerequisites
Before attending this course, students must have:
|
|
Basic knowledge of the Microsoft Windows operating system and its core functionality.
|
|
|
Working knowledge of Transact-SQL.
|
|
|
Working knowledge of relational databases.
|
|
|
Some experience with database design.
|
In addition, it is recommended, but not required, that students have completed:
|
|
Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
|
|
|
Course 2780: Maintaining a Microsoft SQL Server 2005 Database.
|
2)
Workshop 2780: Maintaining a Microsoft SQL Server 2005 Database
This five-day instructor-led course provides students with the knowledge and skills
to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching
individuals how to use SQL Server 2005 product features and tools related to maintaining
a database.
Audience
This course is intended for IT Professionals who want to become skilled on SQL Server
2005 product features and technologies for maintaining a database.
At Course Completion
After completing this course, students will be able to:
|
|
Install and configure SQL Server 2005.
|
|
|
Manage database files.
|
|
|
Backup and restore databases.
|
|
|
Manage security.
|
|
|
Monitor SQL Server.
|
|
|
Transfer data into and out of SQL Server.
|
|
|
Automate administrative tasks.
|
|
|
Replicate data between SQL Server instances.
|
|
|
Maintain high availability.
|
Prerequisites
Before attending this course, students must:
|
|
Basic knowledge of the Microsoft Windows operating system and its core functionality.
|
|
|
Working knowledge of Transact-SQL.
|
|
|
Working knowledge of relational databases.
|
|
|
Some experience with database design.
|
In addition, it is recommended, but not required, that students have completed:
|
|
Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
|
|
|
Course 2779: Implementing a Microsoft SQL Server 2005 Database.
|