SQL Server^® 2005 is the next-generation data management and analysis solution which delivers increased security, scalability, and availability to enterprise data and analytical applications.

Chapter 1 : Author Mentoring

• Lesson 1.1 : Audience for this course
• Lesson 1.2 : Job Opportunities and Roles
• Lesson 1.3 : Prerequisite Knowledge and skills
• Lesson 1.4 : Inspire with samples

Chapter 2 : Fundamentals of SQL Server 2005

• Lesson 2.1 : History of SQL server 2005
• Lesson 2.2 : What is SQL server?
• Lesson 2.3 : Why We Learn SQL Server 2005
• Lesson 2.4 : Course Objective

Chapter 3 : Setting up Environment

• Lesson 3.1 : Checklist for Installation – System Requirements
• Lesson 3.2 : Step by Step Installation Process
• Lesson 3.3 : Testing and troubleshooting
• Lesson 3.4 : Opening the application for the first time

Chapter 4: Introduction to Database

• Lesson 4.1 : What is Database?
• Lesson 4.2 : What is Normalization?
• Lesson 4.3 : Second Normal Form and Third Normal Form
• Lesson 4.4 : What is Boyce-Codd Normal Form (BCNF)?
• Lesson 4.5 : Creating Database Using SQL Server Management Studio
• Lesson 4.6 : Creating a Database in Query Editor

Chapter 5: Working with Data Types and Tables

• Lesson 5.1 : Types of SQL Statements
• Lesson 5.2 : Data Types in SQL Server 2005
• Lesson 5.3 : Creating Tables
• Lesson 5.4 : Inserting Values into a Table
• Lesson 5.5 : How to view the Table Data
• Lesson 5.6 : Changing the structure of the table
• Lesson 5.7 : How to change the existing data in a table
• Lesson 5.8 : The DELETE and DROP Command

Chapter 6: Data Manipulation Language (DML)

• Lesson 6.1 : SELECT statement with Different Clauses
• Lesson 6.2 : ORDER BY and TOP Clause
• Lesson 6.3 : Displaying Data from a table
• Lesson 6.4 : Filtering Rows from a Table
• Lesson 6.5 : Operators in WHERE Clause

Chapter 7: Constraints and Joins

• Lesson 7.1 : Understanding Constraints
• Lesson 7.2 : CHECK constraint
• Lesson 7.3 : Referential Integrity Constraint
• Lesson 7.4 : Join and its Types
• Lesson 7.5 : OUTER JOIN
• Lesson 7.6 : SELF JOIN

Chapter 8: SQL Built-in Functions and Set Operators

• Lesson 8.1 : Aggregate Functions
• Lesson 8.2 : Scalar Functions
• Lesson 8.3 : Numeric Functions
• Lesson 8.4 : DateTime Functions
• Lesson 8.5 : Set Operators

Chapter 9: Indexes and Database Views

• Lesson 9.1 : Indexes
• Lesson 9.2 : Creating and Using Views

Chapter 10: Introduction to T-SQL

• Lesson 10.1 : An Overview of Transact-SQL
• Lesson 10.2 : Programming Structure of T-SQL
• Lesson 10.3 : Control Statements
• Lesson 10.4 : Looping Statements
• Lesson 10.5 : Operators in T- SQL

Chapter 11: Cursors

• Lesson 11.1 : Understanding Cursors
• Lesson 11.2 : Opening and Fetching a Cursor

Chapter 12: Implementing Stored Procedures and Triggers

• Lesson 12.1 : Creating and Using Stored Procedure
• Lesson 12.2 : System and Extended Stored Procedure
• Lesson 12.3 : Overview of Triggers
• Lesson 12.4 : Instead of Trigger

Chapter 13: Transaction Processing

• Lesson 13.1 : Transaction Process
• Lesson 13.2 : Controlling Transactions
• Lesson 13.3 : Security in SQL Server 2005
• Lesson 13.4 : Working with REVOKE

Chapter 14: Handling Errors

• Lesson 14.1 : Error Handling in Transact-SQL
• Lesson 14.2 : Using the @@ERROR Function
• Lesson 14.3 : Using RAISERROR and TRY-CATCH
• Lesson 14.4 : Handling Errors with TRY-CATCH

Chapter 15: Locking in SQL Server 2005

• Lesson 15.1 : Introduction to Locking in SQL Server
• Lesson 15.2 : Shared and update Locks
• Lesson 15.3 : Exclusive Locks
• Lesson 15.4 : Dealing with Deadlocks

Chapter 16: Logins and Users

• Lesson 16.1 : Understanding Logins
• Lesson 16.2 : Creating, Editing, and Deleting Logins
• Lesson 16.3 : Understanding Users and Schemas
• Lesson 16.4 : Using Schemas
• Lesson 16.5 : Adding Users
• Lesson 16.6 : Roles
• Lesson 16.7 : Creating a New Role

Chapter 17: Advanced Transact - SQL

• Lesson 17.1 : Introduction to Full text search
• Lesson 17.2 : Introduction to APPPLY clause in SQL Server 2005
• Lesson 17.3 : Recursive Queries using Common Table Expressions (CTE) in SQL Server
• Lesson 17.4 : Creating Pivot Queries
• Lesson 17.5 : Ranking Functions I
• Lesson 17.6 : Ranking Functions II