Implementing a Microsoft SQL Server 2008 Database

• Provides the knowledge and skills to implement a Microsoft SQL Server 2008 database.
• How to use SQL Server 2008 product features and tools related to implementing a database.
• 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.

IT Professionals who administer and maintain SQL Server databases.

• 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.

1- Creating Databases and Database Files
   • Creating Database.
   • Creating Filegroups.
   • Creating Schemas.
   • Creating Database Snapshots.

2- Creating Data Types and Tables
   • Creating Data Types.
   • Creating Tables.
   • Creating Partitioned Tables.

3- Creating and Tuning Indexes
   • Planning Indexes.
   • Creating Indexes.
   • Optimizing Indexes.

4- Implementing Data Integrity by Using Constraints and Triggers
   • Data Integrity Overview.
   • Implementing Constraints.
   • Implementing Triggers.

5- Using XML
   • Using the XML Data Type.
   • Retrieving XML by Using FOR XML.
   • Shredding XML by Using OPENXML.
   • Introducing XQuery.
   • Creating XML Indexes.
   • Implementing XML Schemas.

6- Implementing Views
   • Introduction to Views.
   • Creating and Managing Views.
   • Optimizing Performance by Using Views.

7- Implementing Stored Procedures
   • Implementing Stored Procedures.
   • Creating Parameterized Stored Procedures.
   • Working With Execution Plans.
   • Handling Errors.

8- Implementing Functions
   • Creating and Using Functions.
   • Working with Functions.
   • Controlling Execution Context.
   • Introduction to the SQL Server Common Language Runtime.
   • Importing and Configuring Assemblies.
   • Creating Managed Database Objects.

10- Managing Transactions and Locks
   • Overview of Transactions and Locks.
   • Managing Transactions.
   • Understanding SQL Server Locking Architecture.
   • Managing Locks.

11- Using Service Broker
   • Service Broker Overview.
   • Creating Service Broker Objects.
   • Sending and Receiving Messages.