By the end of this course you will be able to write basic SQL queries using Oracle Applications Database. This will ultimately complement your job of an Oracle Functional Consultant.

The entire course has been delivered by the way of a realistic business scenario, and has been demonstrated over Oracle Applications Database.

This course covers following sub-modules within it:

+ Overview of Oracle Applications Database and SQL

+ Download and Install SQL Developer

+ Retrieving Data using the SQL SELECT Statement

+ Finding information about database objects from front-end Oracle Application forms

+ Finding database tables linked to Oracle Applications database Views

+ Entity Relationship (ER) Diagrams for Oracle Applications database tables

+ Retrieving Data using SQL from Multiple Tables

+ Restricting and Sorting Data