Get started with databases and Transact-SQL;

Perform basic queries;

Group and summarize data;

Join data from multiple tables;

Work with subqueries;

Modify data;

Query metadata, XML, and full-text indexes;

Use programming objects for data retrieval;

Use advanced querying techniques.

Installing and Configuring SQL Server

• Lesson 1: Preparing to Install SQL Server
• Lesson 2: Installing SQL Server
• Lesson 3: Configuring a SQL Server Installation

Managing Databases and Files

• Lesson 1: Planning Databases
• Lesson 2: Creating Databases
• Lesson 3: Using Policy-Based Management

Disaster Recovery

• Lesson 1: Planning a Backup Strategy
• Lesson 2: Backing Up User Databases
• Lesson 3: Restoring User Databases
• Lesson 4: Performing Online Restore Operations
• Lesson 5: Recovering Data from Database Snapshots
• Lesson 6: System Databases and Disaster Recovery

Managing Security

• Lesson 1: Overview of SQL Server Security
• Lesson 2: Protecting the Server Scope
• Lesson 3: Protecting the Database Scope
• Lesson 4: Protecting the Server Scope
• Lesson 5: Auditing Security

Transferring Data

• Lesson 1: Overview of Data Transfer
• Lesson 2: Introduction to SQL Server Integration Services

Automating Administrative Tasks

• Lesson 1: Automating Administrative Tasks in SQL Server
• Lesson 2: Using SQL Server Agent
• Lesson 3: Creating Maintenance Plans
• Lesson 4: Implementing Alerts
• Lesson 5: Managing Multiple Servers
• Lesson 6: Managing SQL Server Agent security

Implementing Replication 

• Lesson 1: Overview of Replication
• Lesson 2: Managing Publications and Subscriptions
• Lesson 3: Configuring Replication in Some Common Scenarios

Maintaining High Availability

• Lesson 1: Introduction to High Availability
• Lesson 2: Implementing Log Shipping
• Lesson 3: Implementing Database Mirroring
• Lesson 4: Implementing Server Clustering
• Lesson 5: Using Distributed High Availability Solutions

Monitoring SQL Server

• Lesson 1: Viewing Current Activity
• Lesson 2: Using SQL Server Profiler
• Lesson 3: Monitoring with DDL Triggers
• Lesson 4: Using Event Notifications

Troubleshooting and Performance Tuning

• Lesson 1: Troubleshooting SQL Server
• Lesson 2: Performance Tuning in SQL Server
• Lesson 3: Using Resource Governor
• Lesson 4: Using Data Collector

Creating Databases and Database Files
Creating Databases; Creating Filegroups; Creating Schemas; Creating Database Snapshots.

Creating Data Types and Tables
Creating Data Types; Creating Tables; Creating Partitioned Tables.

Creating and Tuning Indexes
Planning Indexes; Creating Indexes; Optimizing Indexes.

Implementing Data Integrity by Using Constraints and Triggers
Data Integrity Overview; Implementing Constraints; Implementing Triggers.

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.

Implementing Views
Introduction to Views; Creating and Managing Views; Optimizing Performance by Using Views.

Implementing Stored Procedures
Implementing Stored Procedures; Creating Parameterized Stored Procedures; Working With Execution Plans; Handling Errors.

Implementing Functions
Creating and Using Functions; Working with Functions; Controlling Execution Context.

Implementing Managed Code in the Database
Introduction to the SQL Server Common Language Runtime; Importing and Configuring Assemblies; Creating Managed Database Objects.

Managing Transactions and Locks
Overview of Transactions and Locks; Managing Transactions; Understanding SQL Server Locking Architecture; Managing Locks.

Using Service Broker
Service Broker Overview; Creating Service Broker Objects; Sending and Receiving Messages.