DATABASE & SQL/PLSQL

Introduction (Database)

Keys & Level of Abstraction

Normalization

Other Database Model

Codd's Twelve Rules

Introduction (SQL)

Installation of SQL

Data types in SQL Server

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

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