SQL Course

by Vibrant Technologies & Computers

Module

Title

Contents

Module 1:

Introduction to Database:

Introduction to Database
Introduction to Oracle
Features of Oracle
Rules of Database

Module 2:

SQL Select statement Restricting and Sorting Data:

Basic select Statement
Selecting all column, selecting basic column
Where clause
Comparison condition
BETWEEN, LIKE, NULL
Logical Condition AND.OR, NOT

Module 3:

Using Single Row Function To Customize Output :

Single row Function
Case manipulation Function
Character Manipulation Function

Module 4:

Reporting Aggreated Data Using Group Function:

Group by clause, Having Clause
MIN, MAX, COUNT, SUM, DISTINCT.

Module 5:

Displaying Data From Multiple tables:

Joining
Equi Joining
Outer Joining
INNER Joining
Non- Equi Joining

Module 6:

Set Operators :

Union, Union all, Intersect, MINUS

Module 7:

Manipulating Data :

Update, Delete, Truncate, Rollback, Commit

Module 8:

Creating Other Schema Object Managing Tables with Data Dictionary :

View, Sequence, Index, Synonym User Objects, View Information,