Implementing a Microsoft SQL Server 2005 Database (MS2779)

Revision: TE4602_20070118

(5.95 KB) View, Download, or Print Catalog as a PDF.

Course Length:

4 Days

Course Description:

This three-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.

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.

Benefits of Attendance:

Upon completion of 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, triggers, and XML schemas
• Implement views
• Implement stored procedures and functions
• Implement managed code in the databas
• Use Service Broker to build a messaging-based solution

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 and relational databases, and some experience with database design. In addition, it is recommended, but not required, that students have completed a course in Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.

Course Outline:

• Creating Databases and Database Files
  1. Creating Databases
  2. Creating Filegroups
  3. Creating Schemas
  4. Creating Database Snapshots
  5. Lab 1: Creating a Database
  6. Creating a Database
  7. Creating Schemas
• Creating Data Types and Tables
  1. Creating Data Types
  2. Creating Tables
  3. Creating Partitioned Tables
  4. Lab 2: Creating Data Types and Tables
  5. Creating Data Types
  6. Creating Tables
  7. Creating Partitioned Tables
• Using XML
  1. Retrieving XML by Using FOR XML
  2. Shredding XML by Using OPENXML
  3. Using the xml Data Type
  4. Lab 3: Working with XML
  5. Mapping Relational Data and XML
  6. Storing XML Natively in the Database
• Creating and Tuning Indexes
  1. Planning Indexes
  2. Creating Indexes
  3. Optimizing Indexes
  4. Creating XML Indexes
  5. Lab 4: Creating Indexes
  6. Creating Indexes
  7. Tuning Indexes
  8. Creating XML Indexes
• Implementing Data Integrity
  1. Data Integrity Overview
  2. Implementing Constraints
  3. Implementing Triggers
  4. Implementing XML Schemas
  5. Lab 5: Implementing Data Integrity
  6. Creating Constraints
  7. Creating Triggers
  8. Implementing XML Schemas
• Implementing Views
  1. Introduction to Views
  2. Creating and Managing Views
  3. Optimizing Performance by Using Views
  4. Lab 6: Creating Views
  5. Creating Views
  6. Creating Indexed Views
  7. Creating Partitioned Views
• Implementing Stored Procedures and Functions
  1. Implementing Stored Procedures
  2. Creating Parameterized Stored Procedures
  3. Creating Functions
  4. Handling Errors
  5. Controlling Execution Context
  6. Lab 7: Creating Stored Procedures and Functions
  7. Creating Stored Procedures
  8. Creating Functions
• Implementing Managed Code in the Database
  1. Introduction to the SQL Server Common Language Runtime
  2. Importing and Configuring Assemblies
  3. Creating Managed Database Objects
  4. Lab 8: Implementing Managed Code in the Database
  5. Importing an Assembly
  6. Creating Managed Database Objects
• Using Service Broker
  1. Service Broker Overview.
  2. Creating Service Broker Objects
  3. Sending and Receiving Messages
  4. Lab 9: Using Service Broker
  5. Creating Service Broker Objects
  6. Implementing the Initiating Service
  7. Implementing the Target Service