Course Name: Oracle 9i (Duration 48 Hrs) Introduction to Oracle Client/Server Systems ORACLE8 as a Client/Server System Relational Database Management System (RDBMS) Features of an Object Model Introduction to SQL Storing Data in Oracle Database Data Retrieval SQL vs. SQL*Plus SQL*Plus Environment Executing SQL Commands in SQL*Plus Environment Writing Basic SQL Statements Writing Queries Based on Conditions Writing Queries Using Operators Setting Query Results Single Row and Group SQL Functions SQL Functions Single Row Functions Character Functions Number Functions Date Functions Conversion Functions Group Functions Querying Multiple Tables Joins SubQueries Hierarchical Queries Pseudocolumns Using SQL*Plus Commands Substitution Variables Writing Queries Using DEFINE and ACCEPT Commands Customizing the SQL*Plus Environment Formatting Query Output Creating a Command File Data Definition Language Data Definition Creating Tables Using DDL Altering a Table Structure Removing a Table
Constraints Creating Tables with Constraints Adding and Altering Table Constraints Data manipulation Language Inserting, Updating and Deleting Rows Transaction processing Data Dictionary Sequences and Synonyms Using a Sequence Altering and Deleting a Sequence Synonyms Views, Indexes and Clusters Views Indexes Clusters Managing Users and Roles Privileges System Privileges Roles Object Privileges Altering Users and Roles Dropping Users and Roles PL/SQL Introduction to PL/SQL Structure of a PL/SQL Block Variables in PO/SQL More on PL/SQL Blocks Environment for PL/SQL Blocks Nested Blocks PL/SQL Operators Control Structures Control constructs in PL/SQL Conditional Control Constructs Interactive Control Constructs Sequential Control Constructs Composite Datatypes and Exception Handling Composite Datatypes PL/SQL Tables PL/SQL Records Exception Handling Trapping Exceptions WHEN OTHERS Exception Handler Error Trapping Functions RAISE_APPLICATION_ERROR Procedure
Cursors Need for Cursors Explicit Cursors Cursor Attributes Cursors and Records Cursor FOR Loops Updating Data Using Cursors Implicit Cursors