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 OverviewPersonal 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.

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.