| |
|
| |
Updating Your Database Development Skills to Microsoft SQL Server 2005 Training Class
Course ID: 5727
|
|
| |
|
|
| |
|
|
| |
Updating Your Database Development Skills to Microsoft SQL Server 2005 Training Seminar
Overview:
This 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.
Who Should Attend:
This course 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.
At Course Completion:
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).
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: SQL Server 2005 Overview
SQL Server 2005 Components and Architecture
SQL Server Developer Tools
SQL Server 2005 Security Implementation
|
|
Lesson 2: Transact-SQL Enhancements in SQL Server 2005
Data Definition Language Enhancements
Data Manipulation Language Enhancements
Structured Exception Handling
|
Lesson 3: Using XML in SQL Server 2005
XML Enhancements in SQL Server 2005
The xml Data Type
Using XQuery
|
Lesson 4: Using Service Broker
Service Broker Architecture
Using the Service Broker
|
Lesson 5: Using Native HTTP Support
Native HTTP Support in SQL Server 2005
Configuring Native HTTP Support
|
|
Lesson 6: Using Notification Services
Notification Services Architecture
Building Notification Services Solutions
|
Lesson 7: Using the .NET CLR in SQL Server 2005
SQL Server and the .NET CLR
Implementing Managed Code in SQL Server 2005
|
Lesson 8: Developing Client Applications
Developing Client Applications with ADO.NET
Data Binding in the .NET Framework 2.0
|
Lesson 9: Using SQL Management Objects
Introduction to SQL Management Objects
Replication Management Objects
|
|
|
|
| Top |
|
|
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
MCDBA certification or equivalent knowledge
Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0
2073 Programming a Microsoft SQL Server 2000 Database
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Updating Your Database Development Skills to Microsoft SQL Server 2005 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5727
| Course Duration: 3 Days
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
 Gift card when you register today!
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|