Oracle Database 11g

Structure of the Module

Prerequisite	Knowledge of computers. Programming knowledge is a plus.
Theory Fee	Rs.2000/-
Lab Fee	Rs.500/-
Description	This course explains what is DBMS, SQL and PL/SQL. This is a must-to-do course for any programmer using database as back-end.
Softwares Required	Oracle Database 10g. Download express edition from www.oracle.com Download Oracle Database 11g from http://www.oracle.com/technology/software/products/database/index.html

Syllabus

Introduction to DBMS

What is DBMS
Relational Data Models
Data integrity rules
Normalization
Introduction to data processing methods - Client/Server
Oracle Architecture
What is grid computing?

SQL

Creating Tables
Integrity Constraints
Adding, updating and dropping columns
Transaction and locking
Functions
Grouping data
Using ROLLUP and CUBE
Joing tables
ANSI Join
Sub queries
Working with TOPn analysis
Views
Materialized Views
Using indexes and clusters
Index Skip Scan
Secutiry
Report generation using SQL*Plus commands
Distributed databases
Partitioning
List partitioning
Lobs

PL/SQL Programming

What is PL/SQL
Structure of PL/SQL block
Control statement
CASE expression
Exception handling
Cursor handling
Writing stored procedures and functions
Definer rights vs. Invoker's rights
Autonomous transactions
Database triggers
Native dynamic SQL
Flashback query
MERGE statement
Multitable insert
Using Regular Expressions

Object Features

Object types
Object Inheritance
Varrays
Nested tables
Object views

New Features Of Oracle Database 11g

Audit Vault and Hot patching
Security enhancements - case sensitive passwords
Query result cache and PL/SQL function result cache
Fine grained depedency tracking
Enhancements related to Triggers
PL/SQL sequences
Virtual Columns & readonly tables