SQL Fundamentals for Oracle Functional Consultants

Learn to write basic SQL queries on Oracle Applications Database to be successful in job of Oracle Functional Consultant
1.5 (1 rating) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
11 students enrolled
Instructed by Kabeer Khan IT & Software / Other
$20
Take This Course
  • Lectures 33
  • Contents Video: 2.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2014 English

Course Description

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

What are the requirements?

  • Basic functional knowledge of Oracle E-Business Suite

What am I going to get from this course?

  • You will be able to write basic SQL queries under Oracle Applications E-Business Suite Database
  • Better equipped for the job of an Oracle Functional Consultant

What is the target audience?

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction to the course
Preview
03:57
Who is this course for?
Preview
00:14
Course Methodology and Assumptions
Preview
01:22
Section 2: Overview of SQL
Module Summary
Preview
00:44
What is SQL?
03:16
Categorize the different types of SQL statements
18:53
Examples of scenarios where SQL can used by Oracle Functional Consultants
05:21
Documentation References
02:32
Section 3: Download and Install SQL Developer
Module Summary
Preview
00:47
Download Oracle SQL Developer
01:53
Install Oracle SQL Developer
01:51
Access Database in Oracle SQL Developer
06:53
Command to Disable Linux Firewall
01:59
Section 4: Retrieving Data using the SQL SELECT Statement
Module Summary
Preview
01:49
Business Scenario
03:58
Introduction to SQL and its standard Syntax
05:03
Explain the capabilities of SQL SELECT statements
02:10
Finding information about database objects from front-end Oracle Application for
04:31
Finding database tables linked to Oracle Applications database Views
Preview
03:23
Retrieve all columns using a basic SQL SELECT Statement
05:54
Select Specific Columns
07:14
Use Arithmetic Operators
05:35
Learn the DESCRIBE command to display the table structure
02:51
Section 5: Entity Relationship (ER) Diagrams for Oracle Applications database tables
Module Summary
Preview
00:44
Exact source to download ER Diagrams for Oracle Applications database tables
04:16
How to do through ER Diagrams and understand the database tables relationships
01:44
Finding out about database tables relationships using eTRM's
03:18
Section 6: Retrieving Data using SQL from Multiple Tables
Module Summary
Preview
00:58
Business Scenario
04:03
Write SELECT statements to access data from more than one table
03:12
View data that generally does not meet a join condition by using outer joins
06:48
Join a table to itself by using a self join
15:17
Use Sub-queries to Solve Queries
04:32

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kabeer Khan, Oracle Solution Architect

Kabeer is a seasoned Oracle professional and has been working with Oracle Applications since last 15 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.

Ready to start learning?
Take This Course