Programming Microsoft® SQL Server™ 2005

Description:
This course will enable database developers experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into three modules:

Working with SQL Server 2005
Exploring Transact-SQL Enhancements in SQL Server 2005
Exploring the Use of XML in SQL Server 2005
 
Objectives:
At the end of the course, students will be able to:
Use the new features and enhancements in SQL Server 2005 and describe the new development tools.
Use Transact-SQL enhancements to perform database development tasks.
Develop XML-based Solutions using SQL Server 2005.

Modules & Lessons
Course Overview
Module Introduction
How to Use This Course
Course Information

Working with SQL Server 2005
Module Introduction

Exploring Components and Features
Lesson Introduction
SQL Server 2005 Components
New Features for Database Administrators
New Features for Database Developers
Self Test

Using the SQL Server 2005 Developer Tools
Lesson Introduction
SQL Server 2005 Developer Tools
What Is SQL Server Management Studio?
How to Execute a Query
How to Use Object Explorer
How to Create a SQL Server Solution
Self Test

Implementing the Security Features in SQL Server 2005
Lesson Introduction
SQL Server 2005 Security Architecture
Using Schemas to Manage Security
Self Test

Lab: Exploring SQL Server 2005
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary

Exploring Transact-SQL Enhancements in SQL Server 2005
Module Introduction

Using Data Definition Language Enhancements
Lesson Introduction

Enhanced Data Definition Language Statements
New and Enhanced Data Types
What Is a Partitioned Table?
Steps for Partitioning a Table
How to Create a Partitioned Table
Enhanced Indexing Features
Self Test

Using Data Manipulation Language Enhancements
Lesson Introduction
How to Use the OUTPUT Keyword
How to Use Common Table Expressions
How to Create Recursive Common Table Expressions
Using the PIVOT and UNPIVOT Operators
How to Use the APPLY Operator
How to Use Ranking Functions
Self Test

Using Structured Exception Handling
Lesson Introduction
What Is Structured Exception Handling?
Using TRY...CATCH Constructs
How to Use Structured Exception Handling
Self Test

Lab: Programming with Transact-SQL
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary

Exploring the Use of XML in SQL Server 2005
Module Introduction

Using XML Enhancements in SQL Server 2005
Lesson Introduction
Enhancements to the FOR XML Clause
How to Use the FOR XML Clause
Enhancements to the OPENXML Function
How to Use the OPENXML Function
Self Test

Using the xml Data Type
Lesson Introduction
Storing XML in the Database
How to Use Untyped XML
Managing XML Schemas
How to Use Typed XML
Managing XML Indexes
Self Test

Using XQuery
Lesson Introduction
What Is XQuery?
How to Use XQuery Expressions
Querying XML with xml Data Type Methods
Modifying XML with the modify Method
Shredding XML with the nodes Method
How to Use xml Data Type Methods
Self Test

Lab: Working with XML
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary