Компьютерная Академия СофтДжойс Компьютерная Академия СофтДжойс Компьютерная Академия СофтДжойс

#2779 Implementing a Microsoft SQL Server 2005 Database

Академия -> Курсы -> Базы данных ->#2779 Implementing a Microsoft SQL Server 2005 Database

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

Записаться на курс
Продолжительность: 5 дн.
Стоимость: 25 000 р.

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

This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database.

Подготовка

• Basic knowledge of the Microsoft Windows operating system and its core functionality. • Working knowledge of Transact-SQL. • Working knowledge of relational databases. • Some experience with database design. In addition, it is recommended, but not required, that students have completed: • Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.

Цель курса

This three-day instructor-led course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.

Материалы по курсу

Слушателям выдаются учебные материалы, авторизованные Microsoft.

По окончании курса слушатели получают сертификат компании Microsoft международного образца.

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

Module 1: Creating Databases and Database Files

Creating Databases.

Creating Filegroups.

Creating Schemas.

Creating Database Snapshots.

Module 2: Creating Data Types and Tables

Creating Data Types.

Creating Tables.

Creating Partitioned Tables.

Module 3: Using XML

Retrieving XML by Using FOR XML.

Shredding XML by Using OPENXML.

Introducing XQuery.

Using the xml Data Type.

Module 4: Creating and Tuning Indexes

Planning Indexes.

Creating Indexes.

Optimizing Indexes.

Creating XML Indexes.

Module 5: Implementing Data Integrity by Using Constraints

Data Integrity Overview.

Implementing Constraints.

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

Implementing Triggers.

Implementing XML Schemas.

Module 7: Implementing Views

Introduction to Views.

Creating and Managing Views.

Optimizing Performance by Using Views.

Module 8: Implementing Stored Procedures

Implementing Stored Procedures.

Creating Parameterized Stored Procedures.

Working With Execution Plans.

Handling Errors.

Module 9: Implementing Functions

Creating and Using Functions.

Working with Functions.

Controlling Execution Context.

Module 10: Implementing Managed Code in the Database

Introduction to the SQL Server Common Language Runtime.

Importing and Configuring Assemblies.

Creating Managed Database Objects.

Module 11: Managing Transactions and Locks

Overview of Transactions and Locks.

Managing Transactions.

Understanding SQL Server Locking Architecture.

Managing Locks.

Module 12: Using Service Broker

Service Broker Overview.

Creating Service Broker Objects.

Sending and Receiving Messages.

Module 13: Using Notification Services (Optional)

Introduction to Notification Services.

Developing Notification Services Solutions.

Академия -> Курсы -> Базы данных ->#2779 Implementing a Microsoft SQL Server 2005 Database

  
Компьютерная Академия СофтДжойс
   Ваш e-mail: 
Компьютерная Академия СофтДжойс
 
группа вКонтакте Яндекс.Метрика