Checklist for Installation – System Requirements
Step by Step Installation Process
Testing and troubleshooting
Opening the application for the first time

What is Database?
What is Normalization?
Second Normal Form and Third Normal Form
What is Boyce-Codd Normal Form (BCNF)?
Creating Database Using SQL Server Management Studio
Creating a Database in Query Editor

Types of SQL Statements
Data Types in SQL Server 2005
Creating Tables
Inserting Values into a Table
How to view the Table Data
Changing the structure of the table
How to change the existing data in a table
The DELETE and DROP Command

SELECT statement with Different Clauses
ORDER BY and TOP Clause
Displaying Data from a table
Filtering Rows from a Table
Operators in WHERE Clause

Aggregate Functions
Scalar Functions
Numeric Functions
Date\Time Functions
Set Operators

Indexes
Creating and Using Views

An Overview of Transact-SQL
Control Statements
Looping Statements
Operators in T- SQL

Understanding Cursors
Opening and Fetching a Cursor

Creating and Using Stored Procedure
System and Extended Stored Procedure
Overview of Triggers
Instead of Trigger

Transaction Process
Controlling Transactions
Security in SQL Server 2005
Working with REVOKE

Error Handling in Transact-SQL
Using the @@ERROR Function
Using RAISERROR and TRY-CATCH
Handling Errors with TRY-CATCH

Introduction to Locking in SQL Server
Shared and update Locks
Exclusive Locks
Dealing with Deadlocks

Understanding Logins
Creating, Editing, and Deleting Logins
Understanding Users and Schemas
Using Schemas
Adding Users
Roles
Creating a New Role

Introduction to Full text search
Introduction to APPPLY clause in SQL Server 2005
Recursive Queries using Common Table Expressions (CTE) in SQL Server
Creating Pivot Queries
Ranking Functions I
Ranking Functions II