Section -1

SQL SERVER – Introduction

• MS-SQL Features
• MS-SQL application development
• MS-SQL Products and Components

MS-SQL

• RoadMap
• Certification

Section- 2

DATABASE OBJECTS

• Introduction
• Devices
• MASTER, MODEL,  MSDB, TEMPDB
• Storage Allocation
• Defaults, User Datatypes, Rules (Binding)
• Check
• MS SQL DatatypesManaging Tables, Indexes & Views

Section- 3

INTEGRITY CONSTRAINTS

• Using NOT NULL Integrity Constraints 
• Setting Default Column Values
• Choosing a Table's Primary Key 
• Using UNIQUE Key Integrity Constraints 
• Using Referential Integrity Constraints
• Nulls and Foreign Keys
• Naming Integrity Constraints   
• IDENTITY Property

Section- 4

RETRIEVING DATA

• SELECT statement
• DML Statements  ( insert, update, delete )
• System Functions
• Data Conversion Functions
• Outer & Inner Joins
• GROUP BY
• COMPUTE BY
• ROLLUP CUBE

SUBQUERY

• SELECT INTO statement
• UNION statement

SECTION -5

TRANSACTION SQL  ( T-SQL )

Advanced SQL

• How SQL works
• Embedded SQL
• Operators
• SQL Functions
• For Update Queries
• Batches & Scripts

Control Flow  ( IF … ELSE) Local & Global Variables Temporary Tables Return

• Raise Error
• CASE Statement
• BEGIN – END Statement

Section- 6

STORED PROCEDURES

• Introduction 
• Creating Stored Procedures
• Using parameters
• Execution

Database Triggers

• Guidelines for Creating triggers
• Inset, Update and Delete
• Data Integrity & Business Rules

CURSORS

• How ANSI SQL Cursor Work
• Cursor Characteristics
• When to use Cursors

Section- 7

TRANSACTION MANAGEMENT

• Commit
• Rolling Back 
• Savepoints
• Locking Issues

IMPORT & EXPORT

• Transferring Data using BCP
• Integrity Issues

LAB

• Assignments & Exercises
• Project

Each Day includes Theory and Lab practice

• Examples based on theory
• Exercises

What you’ll learn

• Introduction to SQL Server, Data Objects, Query, T-SQL, Stored Procedures, Triggers,
  Cursors, Import & Export