SQL Fundamentals for Oracle Functional Consultants

Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle database.

SQL provides statements for a variety of tasks, including:

• Querying data
• Inserting, updating, and deleting rows in a table
• Creating, replacing, altering, and dropping objects
• Controlling access to the database and its objects
• Guaranteeing database consistency and integrity

Course Objectives

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.

This course covers the 'Part 1 - Basic Level', and includes 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

Training Audience

• Functional Implementer
• End Users
• IT Consultants who are looking for making career as Oracle Functional Consultant

Kabeer is a seasoned Oracle professional and has been working with Oracle Applications since last 22 years. He is functional Solution Architect and proficient in implementing and giving functional solutions for Oracle E Business Suite and Oracle Fusion Cloud Applications.

Originally from India, he has traveled extensively on consulting assignments across South Asia and Australasia. He has worked with some of the well known large corporations, including Oracle Corporation in their Consulting Services division.

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.

Subsequently, he picked Oracle Fusion Applications and from then onwards involved in implementing Oracle Fusion SaaS Cloud functional solutions for large corporations in areas such as Procurement, Financials, Order Management, Inventory and Projects..

Kabeer likes to work out in gym a couple of times in a week, and loves to go on hiking to natural bushes, beaches and countryside over the weekend.

Classes by this teacher