learn something new
FIND A CLASS
Virtual Training Schedule
Map : Bloomington, IL
Map : Springfield, IL
Find a Class
> Class Summary
MS2779 - Implementing a Microsoft SQL Server 2005 Database
If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at
This five-day instructor-led course provides students with product knowledge and skills needed 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.
Click here for a printer-friendly version of this page.
This course has not been scheduled yet. Please contact us by clicking the link below to learn about availability.
Contact us for additional availability.
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 2780: Maintaining a Microsoft SQL Server 2005 Database.
Detailed Class Syllabus
Module 1: Creating Databases and Database Files
Creating Database Snapshots.
Lab 1: Creating Databases and Database Files
Module 2: Creating Data Types and Tables
Creating Data Types.
Creating Partitioned Tables.
Lab 2: Creating Data Types and Tables
Module 3: Using XML
Retrieving XML by Using FOR XML.
Shredding XML by Using OPENXML.
Using the xml Data Type.
Lab 3: Using XML
Module 4: Creating and Tuning Indexes
Creating XML Indexes.
Lab 4: Creating and Tuning Indexes
Module 5: Implementing Data Integrity
Data Integrity Overview.
Implementing XML Schemas.
Lab 5: Implementing Data Integrity by Using Constraints
Module 6: Implementing Views
Introduction to Views.
Creating and Managing Views.
Optimizing Performance by Using Views.
Lab 6: Implementing Data Integrity by Using Triggers and XML Schemas
Module 7: Implementing Stored Procedures and Functions
Implementing Stored Procedures.
Creating Parameterized Stored Procedures.
Lab 7: Implementing Views
Module 8: Implementing Managed Code in the Database
Introduction to the SQL Server Common Language Runtime.
Importing and Configuring Assemblies.
Creating Managed Database Objects.
Lab 8: Implementing Stored Procedures
Module 9: Using Service Broker
Service Broker Overview.
Creating Service Broker Objects.
Sending and Receiving Messages.
Lab 9: Implementing Functions
Module 10: Implementing Managed Code in the Database
Introduction to the SQL Server Common Language Runtime
Importing and Configuring Assemblies
Creating Managed Database Objects
Lab 10: Implementing Managed Code in the Database
Module 11: Managing Transactions and Locks
Overview of Transactions and Locks
Lab 11: Managing Transactions and Locks
Module 12: Using Service Broker
Service Broker Overview
Creating Service Broker Objects
Sending and Receiving Messages
Lab 12: Using Service Broker (Optional)
Module 13: Using Notification Services (Optional)
Introduction to Notification Services
Developing Notification Services Solutions
Copyright © 1996 - 2013 Levi, Ray & Shoup, Inc. All rights reserved. |
Trademark Information and Legal Disclaimers