SQL Server 2005 Training Course:

Fast-track Introduction to SQL Server 2005 Programming

This course provides a comprehensive introduction to developing applications using Microsoft SQL Server 2005. Delegates will take full advantage of the powerful new development features with TSQL and the common language runtime.

In addition the course explores native XML support, SQL Server as a Web Services platform, ADO/ADO.NET enhancements and the new suite of built-in application server capabilities.

What You Will Learn
1. Utilisation of the new Management Studio and associated tools.

2. Confidence to program database objects in TSQL.

3. Use extensive new TSQL features.

4. Exploit native XML data support, including the new XQuery feature

5. Work with Visual Studio tools and the Common Language Runtime to create managed procedures and types.

6. Deliver functional Web Services with HTTP Endpoints

7. Use ADO.NET 2.0 for new data access
capabilities, including asynchronous commands.

Hands On Exercises
Exercises during the course demonstrate and illustrate each of the development features, including:

1. Exploring the new Management Studio IDE.

2. The programming basics of TSQL, Stored Procedures, Views, User Defined Functions and Triggers.

3. TSQL Enhancements.

4 Using and Querying native XML data.

5. Implement asynchronous messaging with the Service Broker.

6. Build an HTTP Endpoint application

7. Using ADO.NET features.

8. Building and calling .NET managed procedures and types.

Course Content
Course content has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus, or if you have a technical query email .

Duration
3 Days

Who Should Attend
IT Professionals who need to learn to build database
applications which can take advantage of powerful development features of Microsoft SQL Server 2005

Pre Requisite Skills

Knowledge of generic SQL language and relational databases. We have a very useful 2-day Introduction to SQL Database Design and Information Retrieval training course which is an ideal primer.

SQL Server 2005 Development Tools

Development Tools

Coding with TSQL- the Basics

Using Variables
Control of Flow Statements
Error Handling
Using Cursors

Writing Views and Stored Procedures

Creating Views
Updating Through Views
Indexed Views
Creating Procedures
Passing

Writing User Defined Functions

Scalar, Inline Table and Multi-Statement
Data Manipulation in UDFs
Profiling UDFs

Writing Triggers

Trigger Syntax
Trigger Events
Enabling/Disabling Triggers
Nested Triggers

TSQL Enhancements

Ranking Functions
Recursive Queries
Relational Operators

Monitoring your SQL Server

Data Definition Language
Triggers
DDL Event Notifications
Metadata Views

Messaging with the SQL Server 2005 Service Broker

Architecture Overview
Service Broker Examples
Conversation Architecture
Conversation Process
Security

Using SQL Server 2005 Integration Services (SSIS)

Work Flow and Data Flow
Package Design
Deployment
Import and Export examples

XML-Based Solutions

Using the XML Data Type
FOR XML Enhancements
OPENXML Enhancements
Using XML Schemas
Using XML Indexes
Importing and Exporting XML

Querying XML with XQuery

XQuery Expressions
XQuery and the XML Data Type

Web Services and HTTP Endpoints

Web Services Architecture
Native HTTP Support
HTTP Endpoint Declaration
XML Input/Output Types

Coding SQL Server with .NET

Enabling the .NET CLR
Creating Managed Stored
Procedures
Creating Managed UDFs
Creating Managed Triggers

Building Applications for SQL Server 2005

ADO.NET Enhancements
Asynchronous Support
Snapshot Isolation
Bulk data Import

Call 0800 028 6400 for further details

Associated Course(s)
SQL Server 2005 Applications Development training
SQL Server 2000 Applications Development training
SQL Server 2000 Database Administration
SQL Server Performance Tuning
SQL Server OLAP, DTS & Cubes Training
SQL Design and Information Retrieval
SQL Server 2000 Database Administration
SQL Server Performance Tuning
SQL Server OLAP, DTS & Cubes Training
SQL Design and Information Retrieval

UK training course Listing

SQL Server 2005 Programming Training Course UK

SQL Server 2005 Training Course: Fast-track Introduction to SQL Server 2005 Programming