Description

In this course students will learn how to create and maintain Oracle database objects and how to store, retrieve, and manipulate data. The class covers the concepts of both relational and object relational databases and the powerful SQL and PL/SQL programming languages. Participants will also learn sub queries to solve data retrieval problems. Moreover participants will build a variety of forms and reports using Oracle Developer 6 in a client-server environment.


Content:

Part I. Introduction to RDBMS
Part II. SQL and Oracle DB architecture
Part III. Elements of Database Administration
Part IV. PL/SQL programming
Part V. Client Programming for Oracle

Objectives:

By the end of the course, the student will acquire following skills:

- Concepts of Relational Database Management System (RDBMS);
- Management of SQL statements;
- Standard single-row and group SQL functions;
- Concept of OOP with Oracle;
- Access data from more than one table using joins and aggregating data using group functions;
- Set up, maintain, and troubleshoot an Oracle8 or Oracle8i database;
- Basic concepts of Database administration;
- Organizing the database and to move data into and between databases, under different environments;
- Understanding basic concepts of the Oracle security system;
- Programming application modules in PL/SQL
- Managing cursors, PL/SQL tables, objects, and packages;
- Programming and debug Oracle triggers;