SQL Server 2008 Development Training

Introduction

Welcome

Course Overview

SQL Server Basics

Getting Hands On

Microsoft SQL Certifications

SQL Server Editions

SQL Server Developer

Getting Set Up

Hardware Requirements

SQL Server Instances

SQL Server Components

Service Accounts

Installing SQL Server 2008 

SQL Authentication Modes

Installing Sample Databases

Database Design

Database Types

Normalization

Normalization Benefits

Database Diagrams

Systematic Database Design

Designing Database Objects

Tables & Views

Table Basics

Creating a Table

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   

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