Microsoft SQL Development course for freshers by SPECK Institute of Learning

Introduction to Microsoft SQL server
o Introductions
o Sql server 2008 editions
o Sql server 2008 requirements
o Downloading sql software
o Selecting installation options
o Installing a named instance
o Sql server installation center overview
o Lunching SQL server management studio
Management Studio
o Introduction
o Working with queries
Keys and Constraints
o Introduction
o Primary Keys
o Foreign Keys and Composite Keys
o Understanding Constraints
Data Definition Language (DDL)
o Creation of table
o Modifying the structure of a table
o Dropping a table
o Working with different options
Data Manipulation Language (DML)
o Inserting, updating & deleting operations
o Operators, Built-in functions, grouping

T-SQL Programming Page 2
Basic Queries
o Introduction
o SELECT...FROM
o WHERE
o GROUP BY
o ORDER BY
Special Condition in Query
o Introduction
o Operators
o Combining Conditions
o IN
o LIKE
o BETWEEN
o UNION
o EXCEPT and INTERSECT
Working with Functions
o Using Operators
o ISNULL and COALESCE
o Using Functions
Joins
o Introduction to Joins
o Inner join
o Outer join
o Cross joins
o Unions
Working with Indexes
o Introduction to indexes
o Clustered & non clustered indexes
o Creating, dropping indexes
o Index Maintenance Concepts
Triggers
o Introduction to Triggers
o DML Triggers
o DDL Triggers
Introduction to T-SQL Programming
o Variables
o IF-ELSE
o WHILE

T-SQL Programming Page 3
o ERROR Handling
Using T-SQL Logic
o Tables
o Views
o User-Defined Functions
o Stored Procedures
o Triggers
o Database Cleanup
Other Types of Data
o XML Data
o MAX Data
o Spatial Data Type
o NEW DATE and TIME
Using Complex Queries
o CTE Queries
o Ranking Functions
o MERGE
o Output Clause
Linked Server
o Introduction
o Creating Login
o Using Query in Linked Server
Database Snapshot
o Snapshot Basics
SQL Server Performance
o System Monitor
o Profiler