|
|
 |
Microsoft SQL Server 2005
Updating Your Database Development Skills to Microsoft SQL Server 2005 (2734)
|
|
|
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. |
Prerequisites
| Before attending this course, students must have: 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 . |
Course Objectives
| This course provides students with the necessary knowledge and skills upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers. 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). |
Course Content
| 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
|
| Using SQL Management Objects |
Dates Europe
To book a course, please click on the required city name.
Germany
|
|
|
|
Stuttgart