Courses Offered :

Introduction

• History of Databases
• About SQL Server

Creating and Managing Databases

• System Databases
• Creating User defined Databases
• Modifying a Database

SQL- The Structured Query Language Tables

• Creating a Table
• Identity Columns
• Inserting data
• Modifying Data
• Altering a Table
• Using Enterprise Manger
• Retrieving Data
• FROM and WHERE Clauses
• Using GROUP BY Clause
• Using HAVING Clause
• Sorting the Rows

Constraints

• What is a Constraint?
• Types of Constraints
• Key Constraints
• Rules and Defaults

Joins

• What is a join?
• Types of Joins
• Queries using Joins

Predefined Functions

• Numeric Functions
• Date and Time Functions
• String Functions
• Miscellaneous Functions

Sub-Queries

• What is a sub query?
• Types of Sub Queries
• Nested sub Queries
• Set Operators

Views & Indexes

• What is a View?
• Creating a View
• Indexed Views
• What is an Index?
• Types of Indexes
• Creating an Index

Normalization
T-SQL Programming Introduction

• Structure of SQL Program
• Control Structures

Cursors

• What is Cursor?
• Types of Cursors

Stored Procedures

• Definition
• Types of Stored Procedures
• Creating stored Procedures

Triggers

• What is a Trigger
• Syntax of Trigger
• Creating a Trigger in different modes
• Types of Triggers

Data Control

• Grant
• Revoke
• With Grant Option

Transactions Control

• Transactions
  • COMMIT
  • ROLL BACK
  • SAVEPOINT

User-Defined Functions Introduction to DTS

• The DTS Packaging Editor
• Using Import/Export Wizard

SQL Server 2005 Features

• What New in SQL Server 2005
• SQL Server Database Engine
• XML Data Type
• Microsoft .Net Framework Integration