Session 1 1. Introduction: Tables, Fields, Records, Data Types 2. SQL Commands: Create, Select, Insert, Update, Delete, Where, Order by, Aggregation 3. Closer look at String and Date functions 4. Sub-query , Join, Union, Intersection, Minus 5. Views, Clusters, Sequence Session 2 1. Relational Database Design and ER-Diagram 2. Introduction to PL-SQL 3. Executable commands, exception handling 4. Triggers 5. Procedures 6. Functions 7. Packages 8. Using Native Dynamic SQL and DBMS_SQL Session 3 1. Complex Queries 2. Text queries and text indexes, Index Sets 3. Oracle text for text-searches, Adding Text to the Databases 4. Backup and Recovery 5. Import, Export, Source View 6. Using SQL loader, 7. Working with table space 8. Encryption and Decryption Session 4 1. Basic Oracle Security 2. Users, Roles, Privileges 3. Granting Resources 4. Initial Security Configuration 5. Creating a Logon trigger 6. Creating a Security Policy and applying it to tables 7. Test VPD, Column-level VPD, disabling VPD 8. Using Policy Groups