Microsoft - SQL Server 2008

Course : Implementing a Microsoft SQL Server 2008 Database (6232)

Description

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

Audience

This course is intended for IT Professionals who administer and maintain SQL Server databases.

At course completion

After completing this course, students will be able to:

- Create databases and database files
- Create data types and tables
- Use XML-related features in Microsoft SQL Server 2008
- Plan, create, and optimize indexes
- Implement data integrity in Microsoft SQL Server 2008 databases by using constraints
- Implement data integrity in Microsoft SQL Server 2008 by using triggers
- Implement views
- Implement stored procedures
- Implement functions
- Implement managed code in the database
- Manage transactions and locks
- Use Service Broker to build a messaging-based solution

Prerequisites

Before attending this course, students must have:

- 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

Course outline

Module 1: Creating Databases and Database Files
Module 2: Creating Data Types and Tables
Module 3: Creating and Tuning Indexes
Module 4: Implementing Data Integrity by Using Constraints and Triggers
Module 5: Using XML
Module 6: Implementing Views
Module 7: Implementing Stored Procedures
Module 8: Implementing Functions
Module 9: Implementing Managed Code in the Database
Module 10: Managing Transactions and Locks
Module 11: Using Service Broker

Both courses, software, documentation and exams are given in french or english.