MCTS
- SQL Server 2005
Microsoft Certified
Technology Specialist - SQL Server 2005
Tuition: $1200.00
Exam Fee: $125.00
Books and Material: $90.00
Duration: 50 Hours
Definition
& Purpose
The
Technology Specialist certifications enable professionals to target specific
technologies and distinguish themselves by demonstrating in-depth knowledge and
expertise in their specialized technologies.
Microsoft Certified
Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005)
implement and maintain databases using specific instructions and
specifications. They have thorough knowledge of the product, understand how to
use the tools and Transact-SQL language, and know how to explore the user
interface. Technology Specialists typically pursue careers as database
administrators, database developers, or business intelligence developers. They
may also be developers and systems administrators who do not work with SQL
Server daily but who want to show their breadth of technology experience.
MCTS
candidates must pass one exam that focuses on the implementation and
maintenance of SQL Server 2005.
- 70–431: TS: Microsoft SQL
Server 2005 - Implementation and Maintenance
Implementing a Microsoft SQL Server 2005 Database
Course 2779
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, triggers, and XML schemas.
|
|
•
|
Implement views.
|
|
•
|
Implement stored procedures and functions.
|
|
•
|
Implement managed code in the database.
|
|
•
|
Use Service Broker to build a messaging-based solution.
|
Maintaining a Microsoft SQL Server 2005 Database
Course 2780
At Course Completion
After completing this course, students will be able to:
|
•
|
Install and configure SQL Server 2005.
|
|
•
|
Manage database files.
|
|
•
|
Manage security.
|
|
•
|
Perform administrative tasks.
|
|
•
|
Back up databases.
|
|
•
|
Restore databases.
|
|
•
|
Monitor SQL Server.
|
|
•
|
Troubleshoot SQL Server.
|
|
•
|
Transfer data.
|
|
•
|
Maintain high availability.
|
