Implementing a Microsoft SQL Server 2008 Database (MOC 6232)

Seminarziel

This 5-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.

Zielgruppe

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

Seminarinhalte

Module 1: Creating Databases and Database FilesModule 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

Voraussetzungen

- 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