ORACLE Units:

1. RELATIONAL DATABASES & DATA MODELS
2. SELECTION & SETUP OF THE DATABASE INTERFACE
3. USING THE DATABASE INTERFACE
4. INTRODUCTION TO THE SQL LANGUAGE
5. THE SELECT STATEMENT
6. RESTRICTING RESULTS WITH THE WHERE CLAUSE
7. SORTING DATA WITH THE ORDER BY CLAUSE
8. JOINING TABLES
9. USING THE SET OPERATORS
10. USE DDL TO CREATE & MANAGE TABLES
11. USE DML TO MANIPULATE DATA
12. UNDERSTANDING THE DATA MODELS
13. SQL FUNCTIONS: NUMERIC HANDLING
14. DATABASE OBJECTS: SECURITY

Minimum Entry Requirements

• Course Duration: 3 months
• Minimum Entry grade:Open entry