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
Kabeer is a seasoned Oracle professional and has been working with Oracle Applications since last 16 years. He is proficient in Oracle E Business Suite, Oracle Fusion Applications, Enterprise Architecture and a number of related Oracle Operating System, Server and Virtualization technologies. Originally from India, he has travelled extensively on consulting assignments across South Asia and Australasia, and now permanently lives in New Zealand. He has worked with some of the well known large corporations, including Oracle Corporation in New Zealand.
He started his career by learning Oracle Applications on 10.6 Character and 10.7 Smart Client versions. Since then he has extensively worked on Oracle E Business Suite releases 11, 11i and up until the latest release 12i.
Since last couple of years Kabeer has been managing Oracle Fusion Applications 11g, Enterprise Server Virtualization using VM and Solution Architecture.
Kabeer likes to work out in gym a couple of times in a week and likes to go to New Zealand's natural bushes and beaches over the weekend.