070-431 TS: Microsoft SQL Server 2005 Implementation and Maintenance
Description
This course provides students with product knowledge and skills needed to implement and 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 implementing/maintaining a database.
Entrance Requirements
- 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.
Who Should Attend
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database.
Course Outline
- 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.
- 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.
Examinations and Assessments
Learners write the CCS IT examination, the pass mark for which is 50%. Learners may elect to write the International Microsoft examinations at CCS IT’s Authorized Prometric Testing Centre at an additional cost.
Learning Materials
All standard learning materials are included in the course fee.