Oracle 11g SQL/PLSQL

Oracle SQL PL SQL Training : Oracle SQL

Oracle SQL PL SQL Training : Database Concepts

File Management System

Data Base Management System

Relational Database Management System

Database Design

Normalization

First Normalization Form

Second Normalization Form

Third Normalization Form

Integrity

Data Integrity

Referential Integrity

Types of Constraints

Data Definition Language (DDL)

Creating Tables

Dropping Tables

Altering the Structure of Table

Truncate

Merging of Tables

Data Manipulation Language (DML)

Inserting Records

Deleting Records

Updating Records

Operators

Data Query Language (DQL)

Retrieving Data

Sub Queries

Nested Sub Queries

Correlated Sub Queries

Hierarchical Retrieval

Exists, Any, All

Group By

Having

Rollup

Cube

Data Control Language (DCL)

Grant

Revoke

Joins

Introduction To Joins

Inner Joins

Outer Joins

Self Join

Cross Joins

Multiple Joins

Oracle Proprietary Outer Join Operator

USING Keyword

Set Operators

Union

Union All

Intersect

Minus

System Functions

Aggregate Functions

Single Row Functions

Multiple Row Functions

Date Functions

Regular Expression Support

Managing Data in Different Time Zones

Handling Constraints

Primary Key Constraint

Unique Constraint

Check Constraint

Foreign Key Constraint

Views

Creation Of Views

Updatable , Un updatable Views

With Check Option

With Read Only Option

Creating Complex Views

Sequences

Creating, Altering, Dropping Sequences

Cycle, No Cycle

Cache, No Cache

Indexes

Introduction To Indexes

Duplicate/Unique Index

Creating Simple/Complex Index

Multiple Indexes On A Table

Clusters

Cluster Key

Cluster Indexes

Hierarchal Retrieval

Basic hierarchal retrieval

Using Level

Pruning branches/children

Oracle 11g Tool

Introduction

Creating Schema Objects

Managing Users

Generating Reports