Database Concepts : A Relational Approach: Database-An Introduction-Relationships-Database Management System-The Relational Database4 Model-Integrity Rules-Theoretical Relational Languages-Relational Algebra-Relational calculus. Database Design: Data Modeling and Normalization: Data Modeling-Dependency-Database Design-Normal Forms-Dependency Diagrams-De-normalization.

Oracle 9i : An Overview: Personal Databases-Client Server Databases – Oracle 9i : An Introduction-The SQL * Plus Environment – Structures Query Language- Logging into SQL * Plus- SQL * Plus Commands-Oracle Error and Online Help. Oracle Tables: Data Definition Language(DDL): Naming Rules and Conventions-Data types-Constraints-Creating Oracle Table-Displaying Table Information-Altering An Existing Table –Dropping ,Renaming and Truncating Table.

Working with Tables: Data Management and Retrieval: Data Manipulation Language-Adding a new Row/record-Customized Prompts-Updating and Deleting Existing Row/record-Retrieving Data from a Table-Restricting Data with Where clause. Built-In Functions- Grouping Data. Multiple Tables: Join and Set Operators.

PL/SQL: A Programming Language: A Brief History of PL/SQL-Fundamentals of PL/SQL-PL/SQL block Structure-Comments-Data Types-Other Data Types-Variable Declaration-Anchored Declaration-Assignment Operation-Bind Variables-Substitution Variables in PL/SQL. Control Structures and Embedded SQL: Control Structures- Nested Blocks- SQL in PL/SQL-Data Manipulation in PL/SQL- Transaction Control Statements.

PL/SQL Cursors and Exceptions: Cursors-Implicit Cursors-Explicit Cursors- Explicit Cursor Attributes-Implicit Cursor Attributes. PL/SQL Composite Data Types: Composite Data Types-PL/SQL Records-PL/SQL Tables-PL/SQL Varrays.PL/SQL Named Blocks: Procedures-Functions-Packages-Triggers