Chapter 1: Introduction
Introduction to RDBMS
Introduction to SQL Server
SQL Server Installation
Getting Started with SQL Server
System Databases in SQL Server
Chapter 2: SQL Server Concepts
Database Creation
Data types in SQL Server
Table Creation using SQL Commands
Table Creation using UI
Important points about Tables in SQL Server
Storing and Retrieving data in SQL Server
Chapter 3: Introduction to SQL Server Commands
Introduction to SQL Server Commands
DDL Commands in SQL Server
1. CREATE
2. ALTER
3. DROP
4. TRUNCATE
DML Commands in SQL Server
1. INSERT ( Part 1 , Part 2)
2. UPDATE
3. SELECT
4. DELETE
DCL Commands in SQL Server
TCL Commands in SQL Server
Difference Between DELETE and TRUNCATE
Chapter 4: Simple Commands in SQL SERVER
SELECT
DISTINCT
TOP
WHERE
GROUP BY
HAVING
ORDER BY
IN
BETWEEN
Difference Between Having and Where
Group By Errors
Chapter 5: Aggregate Functions in SQL SERVER
COUNT
SUM
MAX
MIN
AVG
Chapter 6: Joins in SQL SERVER
INNER JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN
FULL OUTER JOIN
CROSS JOIN (or) CARTESIAN PRODUCT
SELF JOIN
Chapter 7: Stored Procedures in SQL SERVER
Introduction to stored procedures
Advantages and Disadvantages of Stored Procedures
Why stored procedures are faster than independent queries?
SP uses in Cross applications
SP without input and output parameters
SP with input parameters and without output parameters
Stored procedures with input and output parameters
Checks performed while compiling stored procedures
System Stored Procedures
Miscellaneous :
Templates for Creating Objects
Temporary Tables
@@FUNCTIONS
System Stored Procedures
Examples
White Papers on SQL SERVER
Introduction to RDBMS
Introduction to SQL Server
SQL Server Installation
Getting Started with SQL Server
System Databases in SQL Server
Chapter 2: SQL Server Concepts
Database Creation
Data types in SQL Server
Table Creation using SQL Commands
Table Creation using UI
Important points about Tables in SQL Server
Storing and Retrieving data in SQL Server
Chapter 3: Introduction to SQL Server Commands
Introduction to SQL Server Commands
DDL Commands in SQL Server
1. CREATE
2. ALTER
3. DROP
4. TRUNCATE
DML Commands in SQL Server
1. INSERT ( Part 1 , Part 2)
2. UPDATE
3. SELECT
4. DELETE
DCL Commands in SQL Server
TCL Commands in SQL Server
Difference Between DELETE and TRUNCATE
Chapter 4: Simple Commands in SQL SERVER
SELECT
DISTINCT
TOP
WHERE
GROUP BY
HAVING
ORDER BY
IN
BETWEEN
Difference Between Having and Where
Group By Errors
Chapter 5: Aggregate Functions in SQL SERVER
COUNT
SUM
MAX
MIN
AVG
Chapter 6: Joins in SQL SERVER
INNER JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN
FULL OUTER JOIN
CROSS JOIN (or) CARTESIAN PRODUCT
SELF JOIN
Chapter 7: Stored Procedures in SQL SERVER
Introduction to stored procedures
Advantages and Disadvantages of Stored Procedures
Why stored procedures are faster than independent queries?
SP uses in Cross applications
SP without input and output parameters
SP with input parameters and without output parameters
Stored procedures with input and output parameters
Checks performed while compiling stored procedures
System Stored Procedures
Miscellaneous :
Templates for Creating Objects
Temporary Tables
@@FUNCTIONS
System Stored Procedures
Examples
White Papers on SQL SERVER