Module 1: Creating Databases and Database Files
This module explains how to create databases, filegroups, schemas, and database snapshots.
Lessons
- Creating Databases.
- Creating Filegroups.
- Creating Schemas.
- Creating Database Snapshots.
Lab 1: Creating a Database
- Creating a Database.
- Creating Schemas.
- Creating a Database Snapshot
Module 2: Creating Data Types and Tables
This module explains how to create data types and tables. It also describes how to create partitioned tables.
Lessons
- Creating Data Types.
- Creating Tables.
- Creating Partitioned Tables.
Lab 2: Creating Data Types and Tables
- Creating Data Types.
- Creating Tables.
- Creating Partitioned Tables.
Module 3: Using XML
This module explains how to use the FOR XML clause and the OPENXML function. It also describes how to use the xml data type and its methods.
Lessons
- Retrieving XML by Using FOR XML.
- Shredding XML by Using OPENXML.
- Introducing XQuery
- Using the xml Data Type.
Lab 3: Working with XML
- Mapping Relational Data and XML.
- Storing XML Natively in the Database.
- Using XQuery with xml Methods
Module 4: Creating and Tuning Indexes
This module explains how to plan, create, and optimize indexes. It also describes how to create XML indexes.
Lessons
- Planning Indexes.
- Creating Indexes.
- Optimizing Indexes.
- Creating XML Indexes.
Lab 4: Creating Indexes
- Creating Indexes.
- Tuning Indexes.
- Creating XML Indexes.
Module 5: Implementing Data Integrity by Using Constraints
This module explains how to implement constraints and provides an overview of data integrity.
Lessons
- Data Integrity Overview.
- Implementing Constraints.
Lab 5: Implementing Data Integrity by Using Constraints
- Creating Constraints.
- Disabling Constraints
Module 6: Implementing Data Integrity by Using Triggers and XML Schemas
This module explains how to implement triggers and XML schemas.
Lessons
- Implementing Triggers
- Implementing XML Schemas
Lab 6: Implementing Data Integrity by Using Triggers and XML Schemas
- Creating Triggers
- Implementing XML Schemas
Module 7: Implementing Views
This module explains how to create views.
Lessons
- Introduction to Views
- Creating and Managing Views
- Optimizing Performance by Using Views
Lab 7: Implementing Views
- Creating Views
- Creating Indexed Views
- Creating Partitioned Views
Module 8: Implementing Stored Procedures
This module explains how to create stored procedures and functions. It also describes execution plans, plan caching, and query compilation.
Lessons
- IImplementing Stored Procedures
- Creating Parameterized Stored Procedures
- Working With Execution Plans
- Handling Errors
Lab 8: Implementing Stored Procedures
- Creating Stored Procedures
- Working With Execution Plans
Module 9: Implementing Functions
This module explains how to create functions. It also describes how to control the execution context.
Lessons
- Creating and Using Functions
- Working with Functions
- Controlling Execution Context
Lab 9: Implementing Functions
- Creating Functions
- Controlling Execution Context
Module 10: Implementing Managed Code in the Database
This module explains how to implement managed database objects.
Lessons
- Introduction to the SQL Server Common Language Runtime
- Importing and Configuring Assemblies
- Creating Managed Database Objects
Lab 10: Implementing Managed Code in the Database
- Importing an Assembly
- Creating Managed Database Objects
Module 11: Managing Transactions and Locks
This module explains how to use transactions and the SQL Server locking mechanisms to meet the performance and data integrity requirements of your applications.
Lessons
- Overview of Transactions and Locks
- Managing Transactions
- Understanding SQL Server Locking Architecture
- Managing Locks
Lab 11: Managing Transactions and Locks
- Using Transactions
- Managing Locks
Module 12: Using Service Broker
This module explains how to build a messaging-based solution with Service Broker.
Lessons
- Service Broker Overview
- Creating Service Broker Objects
- Sending and Receiving Messages
Lab 12: Using Service Broker (Optional)
- Creating Service Broker Objects
- Implementing the Initiating Service
- Implementing the Target Service
Module 13: Using Notification Services (Optional)
This module explains how to develop applications that generate and send timely messages to subscribers.
Lessons
- Introduction to Notification Services
- Developing Notification Services Solutions
