Basics of Transact SQL with SQL Server 2008 R2

Examine Graphical Execution Plans

Use Object Explorer

Use SQLCMD Utility

Create a Basic SSIS Package Using the Wizard

Run a SQL Profiler Trace

SQL Server Data Types

New Data Types

Hierarchyid Data Type

Spatial Data

Date and Time

FileStream Storage

Grouping Sets

Use Hierarchyid

FILESTREAM Storage

Use Merge Statement

Logical Query Processing

Query Clauses (Listed in Logical Processing Order)

FROM

WHERE

GROUP BY

HAVING

SELECT

ORDER BY

CASE

NULLS

Query Clauses

FROM

WHERE

GROUP BY

HAVING

SELECT

ORDER BY

CASE

NULLS

Normalization

Old Style vs. New Style

Cross Join

Inner Join

Outer Join

Self Join

Joining Multiple Tables

Cross Join

Inner Join

Outer Join

Multiple Tables

Subqueries

Self-Contained Subqueries

Correlated Subqueries

EXISTS

Views

Derived Tables

Common Table Expressions

Analytic Ranking Functions

Subqueries

EXISTS

Views

Derived Tables

Common Table Expressions

Understanding Execution Plans

Table and Index Structures

Syntax

Clustered Index

Non Clustered Index on Heap

Non Clustered Index on Clustered Index

Syntax

sys.dm_db_index_physical_stats

Set Statistics IO

WHERE Clause

Narrow Indexes

Column Uniqueness

Column Ordering

System Performance Analysis

Query Analysis

Database Engine Tuning Advisor

Bookmark Lookup

Statistics Analysis

Query Design

Performance Monitor

Dynamic Management Views

SQL Profiler

Database Engine Tuning Advisor

Query Design

Modifying Data INSERT

Modifying Data UPDATE

Modifying Data DELETE

Transactions

Error Processing

Debugging in SQL Server 2008

Inserting Values

Use Bulk Copy

Modify Data

DELETE Data

Transactions

Try-Catch

Stored Procedures

Triggers

Basic Stored Procedure

Stored Procedure with Parameters (In)

Stored Procedure with Parameters (In and Out)

Triggers

INSTEAD OF Trigger

XML Introduction

XML in SQL Server

XML Data Type

XML Indexes