- Working with objects using SQL for the following
- Data definition language: create, alter, grant, revoke, drop, truncate.
- Data manipulation language: select, insert, update, delete.
- Transaction control statements: commit, rollback, savepoint.
- Constraints – Queries: Simple selection, projection and selection with conditions.
- Functions: aggregate functions, group by, order by, date and conversion functions.
- Set operators, joins, sub query: simple, nested, correlated, existence test, membership test, DDL and sub
- queries and DML and sub queries.
- Working with other schema objects: view, sequence, index, synonym, cluster, lock, BLOB, CLOB, nested
- table, type.
- PL/SQL programs, cursors, functions, procedures, packages, triggers, exception handling.
- Front end tool: form creation, validation, trigger and report generation.
- Mini Project.
