INTRODUCTION TO SQL SERVER 2005

1. INTRODUCTION TO SQL SERVER 2005
2. CREATING DATABASES AND DATABASE FILES
3. CREATING DATA TYPES AND TABLES
4. OPERATORS AND FUNCTIONS
5. JOINS
6. CREATING AND TUNING INDEXES
7. IMPLEMENTING DATA INTEGRITY
8. IMPLEMENTING VIEWS
9. T-SQL PROGRAMMING
10. IMPLEMENTING STORED PROCEDURES
11. IMPLEMENTING FUNCTIONS 
12. IMPLEMENTING TRIGGERS
13. IMPLEMENTING MANAGED CODE IN THE DATABASE

 INTRODUCTION TO SQL SERVER 2005

• Introduction to SQL Server 2005
• SQL Server Management Studio
• SQLCMD
• Editions

CREATING DATABASES AND DATABASE FILES

• Creating Databases
• Creating File groups
• Creating Schemas.

CREATING DATA TYPES AND TABLES

1. Creating Data Types
2. Creating Tables
3. Creating Partitioned Tables

OPERATORS AND FUNCTIONS

1. Arithmetic Operators
2. Relational Operators
3. Logical Operators
4. TOP Operator
5. OVER
6. In-Built Functions

JOINS

• Inner Join
• Left Outer Join
• Right Outer Join
• Full Outer Join
• Cross Join

CREATING AND TUNING INDEXES

• Planning Indexes
• Creating Indexes
• Optimizing Indexes
• Creating XML Indexes

IMPLEMENTING DATA INTEGRITY

• Data Integrity Overview
• Implementing Constraints
• Implementing Triggers

IMPLEMENTING VIEWS

• Introduction to Views
• Creating and Managing Views
• Optimizing Performance by Using Views

T-SQL PROGRAMMING

• Variables
• Programming Constructs

IMPLEMENTING STORED PROCEDURES

• Implementing Stored Procedures
• Creating Parameterized Stored Procedures
• Create parameterized stored procedures
• Handle errors in a stored procedure

IMPLEMENTING FUNCTIONS

• Creating Functions.
• Handling Errors
• Controlling Execution Context
• Implement Scalar Functions
• Create Table Valued Functions

IMPLEMENTATING TRIGGERS

• INSERT triggers
• DELETE triggers
• UPDATE triggers
• INSTEAD OF triggers
• Recursive triggers
• DDL triggers