Course - Oracle 9i

• Introduction to RDBMS and DB concepts - DBMS, RDBMS, ORDBMS, Data Base Models, Normalization, E-R Modeling, Codd Rules
  
  
• SQL - Introduction to SQL, Data Types, Operators, Types of SQL Statements (DML, DDL, DCL, TCL), Constraints, Built-in SQL Functions, Number Functions, Character Functions, Date Functions, Group Functions, Object Reference Functions
  
  
• Sub-Queries - Nested Queries, Correlated Sub-Queries
  
  
• Joins - Equi-Join, Non Equi-Join, Outer Join, Self Join, Set Operators
  
  
• Database Objects - Views, Synonyms, Sequences, Indexes, Clusters
  
  
• Transaction Control - Rollback, Commit, Savepoint
  
  
• Data Control - Roles, Privileges, Grant, Revoke
  
  
• Locks - Table Level Locking, Row Level Locking
  
  
• SQL * Plus Commands - Set Commands, Report Commands
  
  
• PL/SQL - Introduction to PL/SQL, PL/SQL Operators, Control Structures, LOOPS, Bulk DML with FOR ALL Statement, PL/SQL Autonomous Transactions
  
  
• Cursors - Introduction to Cursors, Implicit & Explicit Cursors, Parameterized Cursors, Cursor for Loop, Locking through Cursors, Cursor Expressions, REF Cursors
  
  
• Exception Handling - Introduction to Exceptions, Types Of Exceptions, Exception Block
  
  
• Sub-Programs - Introduction to Sub-Programs, Procedures, Functions, Parameter Modes
  
  
• Packages - Introduction to Packages, Package Specification, Package Body, Forward Declaration, Overloading, Packaged Variables, Functions, Procedures, Exceptions, Cursors
  
  
• Triggers - Introduction to Triggers, Types of Triggers, Triggers On Views, Database Level Triggers
  
  
• Table Partitions - Introduction to PARTITIONS, Types of Partitions
  
  
• Large Objects - Introduction to Large Objects, Types of LOBS (BLOB, CLOB, NCLOB, BFILE)
  
  
• Oracle and OOPS - Introduction to OOPS, Creating Object Types, Object Tables, Object Columns and Views, Object Collections Using VARRAYS & NESTED TABLES, Triggers on NESTED TABLES, Object Polymorphism and Inheritance
  
  
• Oracle and Java - Introduction to JAVA, JDBC, SQLJ, Java Stored Procedures (JSP)
  
  
• Oracle and Xml - Introduction to XML, Using SYS.XMLTYPE Data type, Using DBMS_XMLGEN Package
  
  
• Oracle DBA introduction - Oracle Architecture, Table Spaces, Creation of Users, Startup and Shutdown Operations, Database Structure and Space Management, Memory Structure and Processes