Networking Series Course:

 

Target Audience

This 24-hour 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.

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

 

 

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 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.  

 

Examinations

This course will help to prepare for the following Microsoft Certified Professional exam:

·         Exam 70-431: Implementation and Maintenance of Microsoft SQL Server 2005.

Text Box:  

Topics

Module 1: Creating Databases and Database Files

This module explains how to create databases, filegroups, schemas, and database snapshots.

·         Creating Databases.

·         Creating Filegroups.

·         Creating Schemas.

·         Creating 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.

·         Creating Data Types.

·         Creating Tables.

·         Creating 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.

·         Retrieving XML by Using FOR XML.

·         Shredding XML by Using OPENXML.

·         Using the xml Data Type.

 

Module 4: Creating and Tuning Indexes

This module explains how to plan, create, and optimize indexes. It also describes how to create

XML indexes.

·         Planning Indexes.

·         Creating Indexes.

·         Optimizing Indexes.

·         Creating XML Indexes.

 

Module 5: Implementing Data Integrity

This module explains how to implement constraints, triggers, and XML schemas.

·         Data Integrity Overview.

·         Implementing Constraints.

·         Implementing Triggers.

·         Implementing XML Schemas.

 

Module 6: Implementing Views

This module explains how to create views.

·         Introduction to Views.

·         Creating and Managing Views.

·         Optimizing Performance by Using Views.

Module 7: Implementing Stored Procedures and Functions

This module explains how to create stored procedures and functions.

·         Implementing Stored Procedures.

·         Creating Parameterized Stored Procedures.

·         Creating Functions.

·         Handling Errors.

·         Controlling Execution Context.

 

Module 8: Implementing Managed Code in the Database

This module explains how to implement managed database objects.

·         Introduction to the SQL Server Common Language Runtime.

·         Importing and Configuring Assemblies.

·         Creating Managed Database Objects.

 

Module 9: Using Service Broker

This module explains how to build a messaging-based solution with Service Broker.

·         Service Broker Overview.

·         Creating Service Broker Objects.

·         Sending and Receiving Messages.