Microsoft Transact SQL

Course Intro

Welcome/Intro
What Is Transact SQL?
A Few Words About TSQL
History of Databases
History of SQL
What Flavor Would You Like?
SQL Terminology/Acronyms

Course Overview

Course Overview & Description

General Database Information

What Is A Database?
Two Main Types of Databases
Normalization
Denormalization
Database Relationships
Database Design Concerns

Language Basics

SQL Statement Types
Transact SQL Elements
Data Types Overview
SQL 2000 Data Types
Wildcards & Escape Characters
Logic Flow
Scripts
Batches
Transactions
Functions
Stored Procedures
Views
Triggers
Debugging

Transact SQL Tools

Query Analyzer Pt. 1
Query Analyzer Pt. 2
Enterprise Manager
QA vs. EM
ISQL / OSQL
ISQL / OSQL Examples
Notepad
Third Party Apps

More Than A Query Language

Creating Databases
A Word About NULLS
Creating Tables
Creating Constraints
Creating Defaults
Creating Relationships

SELECT

Basic SELECT
Column Aliasing
SELECT INTO Clause
SELECT FROM Clause
Using JOINS
JOIN Examples
Table Aliasing
SELECT WHERE Clause
Looking For NULLS
SELECT GROUP BY Clause
SELECT HAVING Clause
SELECT ORDER BY Clause
SELECT COMPUTE Clause
UNION

INSERT

Basic INSERT Syntax
Using INSERT
Advanced INSERT

UPDATE

Basic UPDATE Syntax
Using UPDATE
Advanced UPDATE

DELETE

Basic DELETE Syntax
Using DELETE
DELETE or TRUNCATE TABLE?

Indexes

What Is An Index?
Types Of Indexes
Determining Indexes(Guidelines)
Creating Indexes

Views

What Is A View?
Creating Views
Advantages of Views

System Tables

Overview of System Tables
Querying System Tables

Variables

Overview Of Variables
Declaring Variables
Using Variables
Variables As Object Names
System Variables

Stored Procedures

What Is A Stored Procedure?
Creating A Stored Procedure
Using Input Variables
Using Output Variables
Extended Stored Procedures

Cursors

What Are Cursors?

Functions

What Are Functions?
Partial List Of Functions
User Defined Functions
Scalar UDF
Multi-Statement UDF
InLine UDF

Triggers

What Are Triggers?
Creating A Trigger
How Triggers Work
Nesting & Recursive Triggers

XML

What Is XML?
FOR XML
Misc XML Info

Optimizing Your TSQL

Limiting Results
Utilizing Indexes
Graphical Exec Plan/Profiler