|
 Course
Outline
Module 1: Creating Databases and Database Files
- Creating Databases
- Creating File groups
- Creating Schemas
- Creating Database Snapshots
Module 2: Creating Data Types and Tables
- Creating Data Types
- Creating Tables
- Creating Partitioned Tables
Module 3: Using XML
- Retrieving XML by Using FOR XML
- Shredding XML by Using OPENXM
- Using the XML Data Type
Module 4: Creating and Tuning Indexes
- Planning Indexes
- Creating Indexes
- Optimizing Indexes
- Creating XML Indexes
Module 5: Implementing Data Integrity
- Data Integrity Overview
- Implementing Constraints
- Implementing Triggers
- Implementing XML Schemas
Module 6: Implementing Views
- Introduction to Views
- Creating and Managing Views
- Optimizing Performance by using Views
Module 7: Implementing Stored Procedures and Functions
- Implementing Stored Procedures
- Creating Parameterized Stored Procedures
- Creating Functions
- Handling Errors
- Controlling Execution Context
Module 8: Implementing Managed Code in the Database
- Introduction to the SQL Server Common Language Runtime
- Importing and Configuring Assemblies
- Creating Managed Database Objects
Module 9: Using Service Broker
- Service Broker Overview
- Creating Service Broker Objects
- Sending and Receiving Messages
Back to Course Description
Onsite Training Class Schedule
|
