- Natural key and surrogate key
- Overview of PL/SQL
- PL/SQL – Basic Syntax
- PL/SQL %ROWTYPE Attribute
- Introduction to database objects
- Direct Access to Objects in Another Schema
- Data dictionary views in Oracle
- SYS and SYSTEM Users in Oracle
- Joins – An Introduction
- Equijoin in Oracle
- Band Join in Oracle
- Cartesian Product of Tables in Oracle
- inner join in Oracle
- Outer join in Oracle
- Semi-join in Oracle
- Anti-Join in Oracle
- EXISTS Condition in Oracle
