Speaking, Listening, Reading, Writing, Hardware & Software

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 5. Join, Union, Intersection, Minus 6. Views, Clusters, Sequence 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 1. Complex Queries 2. Text queries and text indexes, Index Sets 3. Oracle text for textsearches, 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 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