Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Introduction to the coursePreview
Who is this course for?Preview
Course Methodology and AssumptionsPreview
|Section 2: Overview of SQL|
What is SQL?
Categorize the different types of SQL statements
Examples of scenarios where SQL can used by Oracle Functional Consultants
|Section 3: Download and Install SQL Developer|
Download Oracle SQL Developer
Install Oracle SQL Developer
Access Database in Oracle SQL Developer
Command to Disable Linux Firewall
|Section 4: Retrieving Data using the SQL SELECT Statement|
Introduction to SQL and its standard Syntax
Explain the capabilities of SQL SELECT statements
Finding information about database objects from front-end Oracle Application for
Finding database tables linked to Oracle Applications database ViewsPreview
Retrieve all columns using a basic SQL SELECT Statement
Select Specific Columns
Use Arithmetic Operators
Learn the DESCRIBE command to display the table structure
|Section 5: Entity Relationship (ER) Diagrams for Oracle Applications database tables|
Exact source to download ER Diagrams for Oracle Applications database tables
How to do through ER Diagrams and understand the database tables relationships
Finding out about database tables relationships using eTRM's
|Section 6: Retrieving Data using SQL from Multiple Tables|
Write SELECT statements to access data from more than one table
View data that generally does not meet a join condition by using outer joins
Join a table to itself by using a self join
Use Sub-queries to Solve Queries
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.