• Overview
• Outline
• Schedule

About This Course

Course 2785AL: Five weeks; Microsoft Official Distance Learning (MODL)

Elements of this syllabus are subject to change.

This Distance Learning version of the course consists of 10 online live instructor-led sessions over 5 weeks (2 hours for each session). These sessions would be accompanied by additional self-paced e-learning content, scenario-based labs, and assessments to provide students with the knowledge and skills to manage and maintain Microsoft SQL Server 2005.

Audience Profile

This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

Prerequites

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.
• Working knowledge of XML

At Course Completion

After completing this course, students will be able to:

• Install and configure SQL Server 2005.
• Create databases and database files.
• Create data types and tables.
• Generate basic SQL Server 2005 queries and XML reports.
• Manage SQL security.

This course syllabus should be used to determine whether the course is appropriate for the students, based on their current skills and technical training needs.

Course content, prices, and availability are subject to change without notice.

• Backup and restore user databases.
• Recover system database in the event of a disaster.
• Implement data integrity for a database by using the constraints, triggers, and XML schema.
• Implement basic stored procedures and functions.
• Mirror SQL databases.