6232 - Implementing a Microsoft SQL Server 2008 Database
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.
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 databases by using triggers.
Implement stored procedures.
Implement managed code in the database.
Manage transactions and locks.
Use Service Broker to build a messaging-based solution.
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
Guide Price: £1545 + vat
|Category:||Microsoft SQL Server 2008|