Oracle 11g


Version 11g of the Oracle Database, which included built-in testing for changes, the capability of viewing tables back in time, superior compression of all types of data and enhanced disaster recovery functions. The "g" stood for "grid computing," which supports clusters of servers that are treated as a single unit.
Introduction to DBMS,RDBMS
Normalisation,Codd,s Rules,ER Diagrams
SQL Environment
SQL-DDL(Data Defination Language)
SQL-DDL(Data Control Language)
Data Constraints (Not Nuii, Unique)
Data Constraints (primary Key, Foreign key)
Transaction processing (save point,Commit)
Transaction processing (Rollback)
Where Clause, Logical Operators
Order by, Group by
Inbuilt Function (Like,%, Length,inicap)
Inbuilt Function (Load,Rpad)
Inbuilt Function (Abs,Cos, Round)
Inbuilt Function (Power, Average,Count)
Date function (Sysdate,Add_Months)
Date function (Months_between,Next_Day)
Conversion Functions (To_Char,To_Date)
Conversion Functions (To_Number)
Set Operations (Union,Union All)
Set Operations (Interst,Minus)
Join View (Introduction, Create)
Join View (Selecting Dataset from View)
Join View (Destroy View)
PL/SQL Language,PL/SQL Modules
Cursors, Procedures,Functions
Database Triggers, Functions
Oracle Architecture