SQL SERVER OVERVIEW VIEWS
Database Management System (DBMS)
and Data Models
Relational Data Model (RDBMS)
Relational Data Model (RDBMS)
Object Data Model (ODBMS)
Object Relational Data Model
(ORDBMS)
Entity -Relationship Model (E-R
Model)
INTRODUCTION TO SQL SERVER
Advantages of SQL Server Over
Oracle
Installing SQL Server Management
Studio
SQL Server Authentication Modes
Windows
Authentication Mode
SQL Server
Authentication Mode
Object Explorer Window
Query Analyzer Window
STRUCTURED QUERY LANGUAGE
History and Features of SQL
Data Types in SQL Server
Operators in SQL Server
Data Definition Language Commands
(DDL)
Data Manipulation Language
Commands (DML)
Data Query Language Commands (DQL)
Data Control Language Commands
(DCL)
Transaction Control Language
Commands (TCL)
Data Base
System Defined Data Base (Master,
Model, Temp DB, MSDB)
User Defined Data Base
Tables
System Defined Tables
User Defined Tables
Key Constraints
Not Null
Null
Default
Unique
Primary Key
Composite Primary Key
Foreign Key Constraint
Checked Constraint
Candidate Key
JOINS & UNIONS
Inner Joins
Left Outer Joins
Right Outer Joins
Full Outer Joins
Cross Joins
Self-Joins
Complex Joins
Union v/s Union All
NORMALIZATION INDEXES
Clustered Index
Non - Clustered Index
Create, Alter and Drop Indexes
VIEWS
Purpose of Views
Simple View and Complex Views
Encryption and Schema Binding in Views
WORKING WITH SUBQUERIES
Using Sub-queries as Expressions
Sub-queries with Group by clause,
order by clause, having clause
Including Sub-queries as Lists
Adding Sub-queries as Derived
Tables
Working with Row-Number() and
Rank()
Sub-queries with Group by clause,
order by clause, having clause
PRE DEFINED FUNCTIONS
Scalar Function
Arithmetical Functions
Character Functions
String Functions
Date Time Functions
Ranking Functions
Conversion Functions
Aggregate Functions
T-SQL PROGRAMMING
Introduction to T-SQL Programming
Control Statements in T-SQL
Programming
Conditional Control Statements
Looping Control Statements
STORED PROCEDURES
Introduction to Stored Procedure
Types of Stored Procedure
System Defined
Stored Procedure
User Defined
Stored Procedure
Working with Stored Procedure
Exception Handling with Stored Procedures
Real time examples with Stored Procedures
TRIGGERS
DDL Triggers
DML Triggers
Instead of Triggers
CURSORS
Introduction to Cursors
Types of Cursors
USER DEFINED FUNCTIONS
Scalar Valued Function
Table Valued Function
DIFFERENCE BETWEEN STORED PROCEDURES AND FUNCTIONS
CLR INTEGRATION
WORKING WITH XML DATA TYPES
BACKUP AND RESTORE UP DATABASE
