SQL Server Course Content

Basics

ü Database

ü DBMS

ü RDBMS

ü Oracle and SQL Server

SQL Server Environment

ü SQL Server 2005 and 2008

ü New Features in SQL Server 2005 and 2008

ü SQL Server Management Studio Enhancements in SSMS – 2008

ü SQL Server Business Intelligence Development Studio ( BIDS)

SQL Language

ü DDL

(Data Definition Language)

ü DML (INSERT, UPDATE, DELETE, MERGE)

ü TCL

ü DCL

Data Integrity

ü Entity Integrity

ü Domain Integrity

ü Referential Integrity

Database Design

ü Normalization

ü De-Normalization

ü Database Diagrams (E-R)

Joins and Sub Queries

ü SQL Operators

ü Simple Queries

ü Built in Functions

ü Joins

ü SubQueries

ü Advanced Queries

Views

ü Create View

ü Advantage of View

ü Updatable View

ü NonUpdatable View

ü Index View

Introduction to T-SQL

ü Anonymous Block

ü Stored Block

Anonymous block(including 2008 features)

Structed Exception Handling

Cursors

ü Declaring Cursors

ü Modifications Thorough Cursors

ü Types of Cursors

ü Advantages of Cursors

Stored Procedures

ü System Stored Procedure

ü User Stored Procedures

ü Passing In/Out Parameters

ü Altering Procedure

ü Advantages of Procedure

ü Extended Stored Procedure

User Defined Functions

ü Scalar UDF

ü Inline UDF

ü Multi Statement Table UDF

ü Table Variables, Temporary Tables

Triggers

ü DML Triggers (After | Instead of )

ü DDL Triggers

ü Magic Tables

ü Advantages of Triggers

Transactions and Locks

ü Implicit Transactions

ü Explicit Transactions

ü TCL Commands

ü Lock Types

ü Isolation Levels

ü Dead Locks

ü MS-DTC

Indexes

ü Clustered Index

Non Clustered Index

ü Creating Index

ü Advantages of Indexes

XML Integration

ü FOR XML

ü OPEN XML

ü XML Data Type

.NET 2.0 (CLR) Integration

ü CLR Objects

ü CLR Stored Procedures

ü CLR User Defined Functions

Security

ü Windows Authentication

ü SQL Server Authentication

ü Creating Login

ü Database Permissions

ü Introduction to Roles, Schema

ü Droping Login

Database Maintenance

ü Backup Database

ü Restore Database

ü Deployment of Database

ü Generating T-SQL Scripts and Batches

ü System Databases and System Tables

SQL Server Agent

ü Jobs

ü Schedules

ü Alerts

ü Operators

Data Transformation Services

ü BCP

ü DTS Packages / SSIS Packages

Datawarehousing Support

ü OLTP

ü OLAP

ü Analysis Services (SSAS)

ü Reporting Services

Introduction to DBA Concepts

ü Replication

ü Performance Monitoring

ü Service Broker