-
DDL (Data Definition Language)
-
DML (Data manipulation
language)
-
DCL and TCL
-
Displaying
Rows Using Logical & List Operators
-
Displaying Rows Using Comparison
& Range Operators
-
Displaying Rows Using
String Operator
-
IS NULL and IS NOT
NULL keywords & ORDER BY Clause
-
Limits the rows by using
TOP keyword & DISTINCT
keyword
-
Using Aggregate
Functions
-
Using GROUP BY
Clause
-
Using
COMPUTE BY Clause
-
Using String
Functions
-
DATE Functions
-
Mathematical Functions
-
Some System Functions
-
Joins
-
Inner
Join
-
Outer Join
-
Cross Join
-
Equi Join
-
Natural Join
-
Self Join
-
Sub queries with EXITS
Clause
-
Queries with modified Comparison
Operators
-
Extracting Data Into
Another Table
-
Using UNION Operator
-
How to create
a Data Base in SQL server
-
.mdf, .ndf and
.ldf extension files
-
Viewing,
Renaming and Deleting a Database
-
Data Integrity
-
Creating
Constraints
-
PRIMARY KEY
Constraint
-
The UNIQUE
Constraint
-
The FOREIGN KEY
Constraint
-
The CHECK Constraint
-
The DEFAULT
Constraint
-
INDEXES
-
CLUSTERED Index
-
NONCLUSTERED Index
-
How to
Create an Index
-
Programming in SQL Server
-
The IF...ELSE Statement and BEGIN...END
Statement
-
The CASE statement and
WHILE statement
-
Stored Procedures
-
How To Create Stored
Procedure
