Corporate HomeCorporate ProfileWorldwide OfficesSolutions At WorkEmployment  
LRS Education Services
LEARN  >  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 getsmart@LRS.com
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.


Prerequisites

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 Databases.

  • Creating Filegroups.

  • Creating Schemas.

  • Creating Database Snapshots.

  • Lab 1: Creating Databases and Database Files


  • Module 2: Creating Data Types and Tables
  • Creating Data Types.

  • Creating Tables.

  • 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
  • Planning Indexes.

  • Creating Indexes.

  • Optimizing Indexes.

  • Creating XML Indexes.

  • Lab 4: Creating and Tuning Indexes


  • Module 5: Implementing Data Integrity
  • Data Integrity Overview.

  • Implementing Constraints.

  • Implementing Triggers.

  • 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.

  • Creating Functions.

  • 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

  • Managing Transactions

  • Managing 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
  •  
    Microsoft Partner Gold LearningPrometricEC-Council