SQL Fundamentals for Oracle Functional Consultants
3.3 (2 ratings)
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.
15 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Fundamentals for Oracle Functional Consultants to your Wishlist.

Add to Wishlist

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
3.3 (2 ratings)
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.
15 students enrolled
Created by Kabeer Khan
Last updated 1/2015
English
Price: $20
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Basic functional knowledge of Oracle E-Business Suite
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

Who is the target audience?
  • Functional Implementer
  • End Users
  • IT Consultants who are looking for making career as Oracle Functional Consultant
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 33 Lectures Collapse All 33 Lectures 02:17:02
+
Overview of SQL
5 Lectures 30:46

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
+
Download and Install SQL Developer
5 Lectures 13:23

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
+
Retrieving Data using the SQL SELECT Statement
10 Lectures 42:28

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


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
+
Entity Relationship (ER) Diagrams for Oracle Applications database tables
4 Lectures 10:02

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
+
Retrieving Data using SQL from Multiple Tables
6 Lectures 34:50

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
About the Instructor
Kabeer Khan
3.5 Average rating
110 Reviews
9,912 Students
10 Courses
Oracle Solution Architect

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.