An Overview of SQL Server
Exploring the Components of SQL Server
SQL Server Database Structure
Understanding the SQL Server Architecture
Identifying SQL Server Management Tasks

Exploring Transact-SQL
Working with Transact-SQL
Transact-SQL Statements
Programming in Transact-SQL

Designing and Implementing Databases
Identifying Database Design Issues
Creating Databases
Managing Databases

Creating and Managing Tables
Design and Create Tables
Maintaining Tables

Designing and Implementing Data Integrity
Understanding Data Integrity
Implementing Constraints

Implementing Indexes
Designing Indexing
Implementing Indexes
Maintaining Indexes

Joining Tables
Querying Multiple Tables
Implementing Advanced Table Joins

Designing Advanced Queries
Designing Subqueries
Changing Data Through Queries

Designing Views
Creating and Managing Views

Creating Stored Procedures
Designing Stored Procedures
Creating Stored Procedures
Using Parameters in Stored Procedures
Managing Stored Procedures

Using Functions
Working with Aggregate Functions
Designing and Creating User-defined Functions

Creating Triggers
Designing and Implementing Triggers

Understanding Transactions and Locks
Designing and Implementing Transactions
Managing Locks

Implementing Distributed Queries
Establishing Linked Servers
Creating and Managing Distributed Queries

Optimizing Queries
Exploring the Query Optimizer
Using Indexes to Optimize Queries

Analyzing Queries
Analyzing the Performance of Queries