|
|
|
|
Title: |
2734 Updating Your Database Development Skills to Microsoft SQL Server 2005 - ML |
|
Delivery Method: |
Mentored Learning |
|
Duration: |
6 Sessions |
|
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. |
| Pre-requisite(s): |
Before attending this course, students must have:
• MCDBA (Microsoft Certified Database Administrator) certification or equivalent knowledge.
• Development experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
Knowledge of SQL Server 2000/7.0:
• Database and server architecture.
• Database Security
• Transact SQL
• Query Engine
• DDL
• DML
• Optimization
• Schema and Objects
• Programming Objects
• UDDT
• UDF
• Triggers
• Stored Procedures
• Optimization
• SQL XML
• .NET Development (Visual Basic .NET or C# .NET)
• ADO.NET
In addition, it is recommended, but not required, that students have completed:
• Course 2073, Programming a Microsoft SQL Server 2000 Database. |
| CPE
Information: |
CPE Credits:
0
hours
Course Level: Basic
Instructional Method: Group-live
Additional CPE Information |
|
Outline: |
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 |
|
