A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer
Exclusive
SQL Server 2005

Updating Your Database Development Skills to SQL Server 2005
(Microsoft Training Course: 2734) - 3 days - £1700 exc VAT

We currently do not have any dates scheduled for this course.
Please contact us to arrange a closed course for your company or add your details to courses in waiting.
(Remember F1 has smaller classes)
Ask a Question ?Print 2 Page PDF


> Target Audience
This course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005. It is intended for experienced database developers and database administrators, who are responsible for the design, build, query, and develop enterprise SQL Server 2005 databases and servers.
> Course outline
  1. SQL Server 2005 Overview
  2. Transact-SQL Enhancements in SQL Server 2005
  3. Using XML in SQL Server 2005
  4. Using Service Broker
  5. Using Native HTTP Support
  6. Using Notification Services
  7. Using the .NET CLR in SQL Server 2005
  8. Developing Client Applications
  9. Using SQL Management Objects
Supplementary Information This course was written in SQL Server 2005 Beta, and is therefore no longer available. If your company is considering updating from SQL Server 2000, or you are considering updating your SQL skills, then Course 6317 (Upgrading Your SQL Server 2000 Database Administration Skills to SQL Server 2008) is a good option as this course contains not only the upgrade route to SQL Server 2008, but also SQL Server 2005 features.
Module 1: SQL Server 2005 Overview
  • SQL Server 2005 Components and Architecture
  • SQL Server Developer Tools
  • SQL Server 2005 Security Implementation
  • Lab: Exploring SQL Server 2005
  • Using SQL Server Management Studio
  • Using Schemas
Skills
  • Describe the components and architecture of SQL Server 2005.
  • Use SQL Server Management Studio to create a database solution.
  • Use security features of SQL Server 2005.
top
Module 2: Transact-SQL Enhancements in SQL Server 2005
  • Data Definition Language Enhancements
  • Data Manipulation Language Enhancements
  • Structured Exception Handling
  • Lab: Programming with Transact-SQL
  • Partitioning a Table
  • Using Common Table Expressions
  • Using Relational Operators
Skills
  • Use new Data Definition Language (DDL) features in SQL Server 2005.
  • Use new Data Manipulation Language (DML) features in SQL Server 2005.
  • Implement structured exception handling in Transact-SQL.
top
Module 3: Using XML in SQL Server 2005
  • XML Enhancements in SQL Server 2005
  • The XML Data Type
  • Using XQuery
  • Lab: Working with XML
  • Retrieving XML from Relational Data
  • Storing XML Natively in the Databases
  • Using XQuery with xml Methods
Skills
  • Use enhanced XML features in SQL Server 2005.
  • Use the xml data type for typed and untyped XML.
  • Use XQuery expressions with XML data.
top
Module 4: Using Service Broker
  • Service Broker Architecture
  • Using the Service Broker
  • Lab: Using Service Broker
  • Creating Service Broker Objects
  • Implementing the Customer Service
  • Implementing the E-mail Service
Skills
  • Describe the Service Broker architecture.
  • Use Service Broker for message-based communication.
top
Module 5: Using Native HTTP Support
  • Native HTTP Support in SQL Server 2005
  • Configuring Native HTTP Support
  • Lab: Implementing a Web Service with HTTP Endpoints
  • Create an HTTP Endpoint
  • Test the HTTP Endpoint
  • Secure the HTTP Endpoint
Skills
  • Describe the native HTTP support features in Microsoft SQL Server 2005.
  • Implement a Web service using native HTTP endpoints.
top
Module 6: Using Notification Services
  • Notification Services Architecture
  • Building Notification Services Solutions
  • Lab: Using Notification Services
  • Creating a Notification Services Application
  • Creating a Subscription Management Application
  • Creating an Event Provider
Skills
  • Describe the architecture of a Notification Services solution.
  • Design and implement a simple Notification Services solution.
top
Module 7: Using the .NET CLR in SQL Server 2005
  • SQL Server and the .NET CLR
  • Implementing Managed Code in SQL Server 2005
  • Lab: Implementing Managed Code in the Database
  • Creating a Managed Stored Procedure
  • Creating a Managed Function
  • Creating a Managed User-Defined Type
Skills
  • Identify appropriate scenarios for using managed code in the database.
  • Implement managed database objects.
top
Module 8: Developing Client Applications
  • Developing Client Applications with ADO.NET
  • Data Binding in the .NET Framework 2.0
  • Lab: Developing Client Applications
  • Creating a Data Bound Windows Application
  • Creating a Data bound ASP.NET Application
Skills
  • Use ADO.NET to build a database client application.
  • Use data binding in a client application.
top
Module 9: Using SQL Management Objects
  • Introduction to SQL Management Objects
  • Replication Management Objects
  • Lab: Using SQL Management Objects
  • Using SMO to Retrieve Server Information
  • Using SMO to Create Database Objects
  • Using SMO to Modify Database Objects
Skills
  • Use SMO to manage SQL Server.
  • Use RMO to manage replication.
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • • MCDBA (Microsoft Certified Database Administrator) certification or equivalent knowledge.
  • • Development experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
  • • Knowledge of SQL Server 2000/7.0.
  • In addition, it is recommended, but not required, that students have completed:
  • • Course 2073, Programming a Microsoft SQL Server 2000 Database.
> Purpose
After completing this course, students will be able to use the Development Tools provided with SQL Server 2005; use Transact-SQL enhancements to perform database development tasks; develop XML-based Solutions using SQL Server 2005; build Message-Based Services with the Service Broker; implement Web Services using Native HTTP Endpoints; build Notification Services Applications; implement Database Functionality with Managed (.NET) Code; build Client Applications with the .NET Framework; build Administrative Applications with SQL Management Objects (SMO).
> Supplementary Information
This course was written in SQL Server 2005 Beta, and is therefore no longer available. If your company is considering updating from SQL Server 2000, or you are considering updating your SQL skills, then Course 6317 (Upgrading Your SQL Server 2000 Database Administration Skills to SQL Server 2008) is a good option as this course contains not only the upgrade route to SQL Server 2008, but also SQL Server 2005 features.
> EXAMS
There are no exams directly associated with this course