COURSE NAME: 2779-Implementing a MS SQL Server 2005 Database (4050)

Course length: 5 days

Overview:

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.

Prerequesite Courses:

• No Prerequisites listed for this course

Performance-based Objectives:

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.

Course content:

Module 1: Creating Databases and Database Files - This module explains how to create databases, filegroups, schemas, and database snapshots.

Module 2: Creating Data Types and Tables - This module explains how to create data types and tables. It also describes how to create partitioned tables.

Module 3: Using XML - This module explains how to use the FOR XML clause and the OPENXML function. It also describes how to use the xml data type and its methods.

Module 4: Creating and Tuning Indexes - This module explains how to plan, create, and optimize indexes. It also describes how to create XML indexes.

Module 5: Implementing Data Integrity by Using Constraints - This module explains how to implement constraints and provides an overview of data integrity.

Module 6: Implementing Data Integrity by Using Triggers and XML Schemas - This module explains how to implement triggers and XML schemas.

Module 7: Implementing Views - This module explains how to create views.

Module 8: Implementing Stored Procedures - This module explains how to create stored procedures and functions. It also describes execution plans, plan caching, and query compilation.

Module 9: Implementing Functions - This module explains how to create functions. It also describes how to control the execution context.

Module 10: Implementing Managed Code in the Database - This module explains how to implement managed database objects.

Module 11: Managing Transactions and Locks - This module explains how to use transactions and the SQL Server locking mechanisms to meet the performance and data integrity requirements of your applications.

Module 12: Using Service Broker - This module explains how to build a messaging-based solution with Service Broker.

Module 13: Using Notification Services (Optional) - This module explains how to develop applications that generate and send timely messages to subscribers.