Cours MS E2779 - 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.
Langue du cours
FR
Support de cours
Official Microsoft MOC 2779 coursebook
300.- CHF
Durée
5 jour(s)
Prix
3500.- CHF
Nos cours collectifs
Aucune session programmée
