#2734 Updating Your Database Development Skills to Microsoft SQL ServerT 2005

Академия -> Курсы -> Базы данных ->#2734 Updating Your Database Development Skills to Microsoft SQL ServerT 2005

Описание курса

Назначение курса

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.

Подготовка

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
 UDF
 Triggers
 Stored Procedures
 Optimization
 SQL XML
 .NET Development (Visual Basic .NET or C# .NET)
 ADO.NET

Цель курса

This three-day 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.
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).

Программа курса

Module 1:

SQL Server 2005 Overview

Module 2:

Transact-SQL Enhancements in SQL Server 2005

Module 3:

Using XML in SQL Server 2005

Module 4:

Using Service Broker

Module 6:

Using Notification Services

Module 7:

Using the .NET CLR in SQL Server 2005

Module 8:

Developing Client Applications

Модуль 8

Module 6: Implementing Data Integrity by Using Triggers and XML Schemas

Модуль 9

Module 6: Implementing Data Integrity by Using Triggers and XML Schemas

Module 9:

Using SQL Management Objects

Академия -> Курсы -> Базы данных ->#2734 Updating Your Database Development Skills to Microsoft SQL ServerT 2005