Microsoft SQL Server 2008 Development Tutorial

We hope you enjoyed the FREE lessons above. To view the complete contents, including ALL the lessons below and above, please purchase the CD.
CLICK HERE TO BUY THIS CD

Tables & Views
Table Basics
Creating a Table - Lesson 1
Creating a Table - Lesson 2
Creating a Table - Lesson 3
Data Types
Unicode Basics
New Data Types In 2008
Character Types
Exact Numerics
Approximate Numeric Types
Date & Time
Null or Not Null
Primary Key
Foreign Key
Candidate Key

Retrieving Data
The Select Statement
Column Aliases
Joining Tables - Lesson 1
Joining Tables - Lesson 2
Scalar Functions
UDF

Modifying Data
Inserting Data
Updating Data
Deleting Data
Output Clause
Merge Clause

Managing Transactions
Understanding Transactions
Explicit Transactions
Transaction Isolation Levels

Programming Objects
Understanding Views
Indexed Views
Understanding Stored Procs
Creating Stored Procs
Using Parameters
Temporary Tables
Common Table Expressions
Table Variables
Temp Common or Table
Dynamic SQL

Indexes
Understanding Indexes
Indexing Guidelines
Clustered or Non-Clustered
Creating Indexes
Monitoring Indexes

Course Wrap-Up
MS SQL Server 2008 Developer Course Wrap-Up

Credits
About The Tutor