Quanta Training Ltd The interactivity between the course tutor and delegates was excellent - Adrian Cox, Centresoft
 Sign in | Site map | Contact us
  
  

Updating SQL Server 2000 Development Skills to SQL Server 2005    SQ5K2DEV  
Price £680.00
Offer Code
Zip code
email this course to someone
Please call us for the latest dates for this course or to discuss your requirements in more depth

If you would like to join our wait list please click here
Prices shown are excluding VAT. If you are booking any course with an exam and you are using a prepaid account (training days) or passports, you will be invoiced for the exams separately to ensure that you pay only the required amount.

 

  Updating SQL Server 2000 Development Skills to SQL Server 2005
   
 

SQ5K2DEV
2 Days

  COURSE TOPICS
OVERVIEW OF SQL SERVER 2005
SQL Server 2005 Overview
New Features for Administrators
Using SQL Server Management Studio

ENHANCED TSQL COMMANDS
SQL Server 2005 T-SQL Enhancement
CTE Example
Using SQL Server 2005 TSQL Features

PROGRAMMING WITH XML IN SQL SERVER 2005
SQL Server 2005 XML Enhancements
Using the XML Data Type
Using X Query

MESSAGING WITH SERVICE BROKER
SQL Server Broker
A Service Broker Example
Creating a Service Broker Application

CONNECTING VIA NATIVE HTTP
SQL Server 2005 Native Web Service Support
Databases and Web Services
HTTP/SOAP Features
Platform Requirements
Architecture
Web Services and HTTP Endpoints
 		 PROGRAMMING WITH NOTIFICATION SERVICES
SQL Server 2005 Notification Services
Creating a Notification Services Application

CODING THE .NET CLR
SQL Server 2005 and the .NET CLR
Creating Managed Stored Procedures
Creating Managed User Defined Functions
Creating Managed Triggers
Coding with the .NET CLR

CLIENT APPLICATION DEVELOPMENT
ADO.NET 20 Enhancements
Asynchronous Data Access
MARS
Bulk Copy Operations
Batch Updates
Notifications
Using SQLDependency
Snapshot IsolationMode
Data Source Controls

MANAGEMENT WITH SQL MANAGEMENT OBJECTS
SQL Management Objects Overview
Building SMO Applications
Using SMO to Enumerate Servers and Databases
Using SMO to Backup and Restore Databases
Replication Management Objects

Course Outline v2.2

THE COURSE
This skills upgrade course will enable existing SQL Server 2000 developers and administrators to design, query, develop and exploit the wide range of new SQL Server 2005 tools

WHO SHOULD ATTEND
Database developers and support personnel who need to fully understand the new development features of SQL Server 2005

PRE-REQUISITES
Delegates must have a good working knowledge of relational databases and be competent in SQL. This can be obtained by attending our Microsoft SQL Server 2000 development course or equivalent. Alternatively, delegates could be proficient in a previous version of SQL Server such as version 7. Delegates should have a good working knowledge of Windows NT 4 or Windows 2000/2003 Server administration.
Delegates should have a basic understanding of .NET programming either in VB or C# which can  be obtained from attending our VB.NET Introduction  or C # Introduction courses. Some familiarity with XML would be advantageous
 
 

Home | About us | Services | Certification | Special offers | News | Contact us
Privacy statement | Terms and conditions | Site Map

©2004 Quanta. All rights reserved. All trademarks acknowledged.