l   SQL Server Overview

•       What Is SQL Server?

•       SQL Server Integration

•       SQL Server Databases

•       SQL Server Security

•       Working with SQL Server

l   Overview of Programming SQL Server

•       Designing Enterprise Application Architecture

•       SQL Server Programming Tools

•       The Transact-SQL Programming Language

•       Elements of Transact-SQL

•       Additional Language Elements

•       Ways to Execute Transact-SQL Statement

l   Creating and Managing Databases

• Creating Databases

• Creating Filegroups

• Managing Databases

• Introduction to Data Structures

l   Creating Data Types and Tables

•       Creating Data Types

•       Creating Tables

•       Generating Column Values

•       Generating Scripts

l   Implementing Data Integrity

•       Types of Data Integrity

•       Enforcing Data Integrity

•       Defining Constraints

•       Types of Constraints

•       Disabling Constraints

•       Using Defaults and Rules

•       Deciding Which Enforcement Method to Use

l   Planning Indexes

•       Introduction to Indexes

•       Index Architecture

•       How SQL Server Retrieves Stored Data

•       How SQL Server Maintains Index and Heap Structures

•       Deciding Which Columns to Index

l   Creating and Maintaining Indexes

•       Creating Indexes

•       Creating Index Options

•       Maintaining Indexes

•       Introduction to Statistics

•       Querying the sysindexes Table

•       Setting Up Indexes Using the Index Tuning Wizard

•       Performance Considerations

l   Implementing Views

•       Introduction to Views

•       Advantages of Views

•       Defining Views

•       Modifying Data Through Views

•       Optimizing Performance by Using Views

•       Performance Considerations

l   Implementing Stored Procedures

•       Introduction to Stored Procedures

•       Creating, Executing, Modifying, and Dropping Stored Procedures

•       Using Parameters in Stored Procedures

•       Executing Extended Stored Procedures

•       Handling Error Messages

•       Performance Considerations

l   Implementing User-defined Functions

•       What Is a User-defined Function?

•       Defining User-defined Functions

•       Examples of User-defined Functions

l   Implementing Triggers

•       Introduction to Triggers

•       Defining Triggers

•       How Triggers Work

•       Examples of Triggers

•       Performance Considerations

l   Programming Across Multiple Servers

•       Introduction to Distributed Queries

•       Executing an Ad Hoc Query on a Remote Data Source

•       Setting Up a Linked Server Environment

•       Executing a Query on a Linked Server

•       Managing Distributed Transactions

•       Modifying Data on a Linked Server

•       Using Partitioned Views

l   Optimizing Query Performance

•       Introduction to the Query Optimizer

•       Obtaining Execution Plan Information

•       Using an Index to Cover a Query

•       Indexing Strategies

•       Overriding the Query Optimizer

l   Analyzing Queries

•       Queries That Use the AND Operator

•       Queries That Use the OR Operator

•       Queries That Use Join Operations

l   Managing Transactions and Locks

•       Introduction to Transactions and Locks

•       Managing Transactions

•       SQL Server Locking

•       Managing Locks