|
|
|
Updating Your Database Development Skills to SQL 2005 (Prices exclude VAT)
|
|
|
[to previous page]
[other products in "Other IT Courses"]
|
| Product: |
Updating Your Database Development Skills to SQL 2005
Includes 4 CDs
|
|
|
| Details: |
MOC 2734 – Updating Your Database Development Skills to SQL 2005
Course Description:
This instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers. This course is recommended for experienced database developers and database administrators, who are responsible for the design, build, and development of enterprise SQL Server 2005 databases and servers.
Prerequisites:
Before taking this course students should have the following knowledge and/or experience prerequisites:
MCDBA or Equivalent Knowledge
Microsoft SQL Server 2000/7.0 Development Experience
Database Security
Database and Server Architecture
Transact SQL
DDL and DML
Schema, Objects, and Programming Objects
Stored Procedures
Query Engine
Optimization
ADO .NET
SQL XML
.NET Development
Course Duration: 36 Hours
Learning Segments:
Module 1: SQL Server 2005 Overview
SQL Server 2005 Components and Architecture
SQL Server Developer Tools
SQL Server 2005 Security Implementation
Module 2: Transact-SQL Enhancements in SQL Server 2005
Data Definition Language Enhancements
Data Manipulation Language Enhancements
Structured Exception Handling
Module 3: Using XML in SQL Server 2005
XML Enhancements in SQL Server 2005
The xml Data Type
Using XQuery
Module 4: Using Service Broker
Service Broker Architecture
Using the Service Broker
Module 5: Using Native HTTP Support
Native HTTP Support in SQL Server 2005
Configuring Native HTTP Support
Lab 6: Using Notification Services
Creating a Notification Services Application
Creating a Subscription Management Application
Creating an Event Provider
Module 7: Using the .NET CLR in SQL Server 2005
SQL Server and the .NET CLR
Implementing Managed Code in SQL Server 2005
Module 8: Developing Client Applications
Developing Client Applications with ADO.NET
Data Binding in the .NET Framework 2.0
Module 9: Using SQL Management Objects
Introduction to SQL Management Objects
Replication Management Objects
|
