Website Design & Website Development Service, Bathinda

ORACLE 10g Syllabus

SQL

 Introduction to DBMS & RDBMS
 Introduction to SQL
 SQL Functions
 Joins
 Output with SQL* Plus
 Sub-queries
 Database Objects(Tables, Views, Sequences)
 Data Integrity Constraints
 Locks
 Set Operators
 Privileges Control

PL/SQL Programming

 Introduction
 Variable Scope Control Structures
 Nested Blocks
 Exception Handling
 Cursors
 Advance Cursors
 Procedure & Functions
 Packages
 Database Triggers