Introduction to DBMS and Database Design: Overview of DBMS Database, DBMS & RDBMS Essentials of Data Modeling (ER Modeling) Normalization Client/Server Oracle Architecture  Introduction to SQL Working with tables Data types & pseudo-columns Schema, users and synonyms Creating tables with CREATE TABLE Adding, deleting and modifying data with INSERT, UPDATE, DELETE Altering and dropping tables Efficient data access methods Unique and non-unique indexes Concatenated indexes Using the SELECT command Selecting & ordering rows & columns Handling null values Using functions and expressions Joining tables Additional SQL query techniques Oracle's SQL statement processing Sub-queries, correlated queries UNION, INTERSECT and MINUS Grouping data and applying aggregate functions Using SQL*PLUS Using SET and SHOW commands to control the environment Writing simple reports Accepting user input Controlling Data Integrity & Security Constraints The importance of referential integrity Maintaining referential integrity constraints at CREATE time

Transaction processing and locking The purpose of transactions Controlling transactions through the use of COMMIT, ROLLBACK and SAVEPOINT Data and dictionary locks Maintaining security through the use of views and roles Creating views and synonyms Specifying object privileges using GRANT and REVOKE Manipulating privileges via roles Introduction to PL/SQL-Procedural Language extension to SQL Basic concepts Program Structure Declaring constants and variables Assigning values Logical condition statements and iterations Producing well-structured modular code Use of variables in SQL statements Using cursors Exceptions and exception handling Advanced PL/SQL Features Using PL/SQL Tables and Records Stored procedures and functions Constructing database Packages Creating and manipulating triggers Overview of Oracle tools and utilities Importing and exporting data SQL*Loader Case Study