MS 2779 - Implementing a Microsoft SQL Server 2005 Database

Objectif:

This five-day instructor-led course provides students with the knowledge and skills 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.

Pré-requis:

Before attending this course, students must have a basic knowledge of the Microsoft Windows operating system, a woking knowledge of Transact-SQL and some experience with database design.

Contenu:

- Creating Databases and Database Files
- Creating Data Types and Tables
- Using XML
- Creating and Tuning Indexes
- Implementing Data Integrity by Using Constraints
- Implementing Data Integrity by Using Triggers and XML Schemas
- Implementing Views
- Implementing Stored Procedures
- Implementing Functions
- Implementing Managed Code in the Database
- Managing Transactions and Locks
- Using Service Broker
- Using Notification Services (Optional)

Examen(s) préparé(s)

Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance.
Il s'inscrit dans le cadre de la certification MCTS et MCTIP.

Support de cours:

Official Microsoft MOC 2779 coursebook CHF 300

Durée:

5 jour(s)

Prix:

3500.- CHF