Sql and pl/sql

SQL

     Steps to Install Oracle 10g Express edition

     Sql course content
   
     Retrieving data by using the sql SELECT statement 

     Restriction and sorting [ WHERE clause ]

     Escape Sequences in Oracle

     LAG, LEAD, FIRST_VALUE and LAST_VALUE Function in oracle

     DECODE and CASE statement    

     Joins in Oracle

     Sub query

     Inline View in Oracle

     Statements

                           Data Define Language (DDL)

                           Data Manipulation Language (DML)  

                           Constraints

     User Management in Oracle (DCL)

     CONNECT BY PRIOR  - Hierarchical queries

     Using Group by clause along with ROLLUP or CUBE operators

     Listaag in oracle 11g 

PLSQL

     Introduction to pl/sql

     Anonymous Block

     %TYPE and %ROWTYPE

     Condition and Looping Statement 

     Cursor

     Ref-Cursor
 
     Cursor - FOR UPDATE

     Exception

     Stored Procedure

     Function

     Package

     Trigger Example

     Formatting Output in PL/SQL

     Dynamic SQL

     Bulk Collection

     Bulk Exception 

     Inserting Data into Array Type

     DML Error Logging (dbms_errlog.create_error_log package ) 

Things To Know

     Why prefer COALESCE over NVL
 
Some useful links.......

     nimishgarg.blogspot.in