SQL Fundamentals for Oracle Functional Consultants – Basic (FREE)

  • Released: 2014-12-27 09:31:08
  • Level: Beginner
Certificate:

No certificate is given for this course

Take This Course
Free for members

Table of Contents

Viewed
Level
Introduction
Overview of SQL
Download and Install SQL Developer
Retrieving Data using the SQL SELECT Statement
Entity Relationship (ER) Diagrams for Oracle Applications database tables
Retrieving Data using SQL from Multiple Tables

Description

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

Oracle Certiication

This course helps to prepare for following Oracle Certification:

+ Exam Number: 1Z0-047

+ Exam Name: Oracle Database SQL Expert

 

Price

Plan Name Price

Teacher

Kabeer Khan

author image

Kabeer is a seasoned Oracle professional and has been working with Oracle Applications since last 20 years. He is proficient in Oracle E Business Suite, Oracle Fusion Applications Cloud and  Solution Architecture. 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.

Since last couple of years Kabeer has been working on Oracle E-Business Suite, Oracle Fusion Applications Cloud, Virtualization using VM, Solution Architecture and Cloud Computing on leading cloud provides such as Oracle, AWS, Google, Microsoft Azure etc.

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.

View Kabeer's Profile on LinkedIn

 

Courses by this teacher

Name Level Release Date
R12i Oracle Procurement Contracts Fundamentals 2017-12-02 05:06:00
R12i Oracle iSupplier Portal Fundamentals 2014-10-04 05:17:06
R12i Oracle Services Procurement Fundamentals 2019-08-06 05:20:04
R12i Oracle Workflow and Alerts Overview 2019-06-21 13:28:27
R12i Oracle Inventory Fundamentals 2019-10-04 05:35:28
R12i Oracle Order Management Fundamentals 2014-10-04 05:39:58
R12i Oracle E Business Suite Fundamentals - Advanced 2017-12-03 13:27:00
R12.2 Install Patch and Maintain Oracle E Business Suite 2015-08-04 05:56:12
R12i Oracle Supplier Lifecycle Management Fundamentals 2014-10-04 06:07:11
R12i Oracle iProcurement Fundamentals 2019-07-04 06:28:12
R12i Oracle Shipping Execution Fundamentals 2017-11-27 06:30:00
R12i Advanced Pricing Fundamentals 2018-11-03 06:30:54
R12i Oracle Service Contracts Fundamentals 2014-10-04 06:30:54
Oracle Fusion Applications Installation, Patching and Administration 2017-10-20 06:44:00
R12i Oracle E Business Suite Fundamentals (FREE) 2014-10-04 05:44:26
R12i Oracle Order Management Fundamentals - Introduction (FREE) 2014-11-16 22:36:44
R12i Oracle Service Contract Fundamentals - Introduction (FREE) 2014-11-16 22:38:50
R12i Oracle Purchasing - Advanced - Introduction on R12.2.3 (FREE) 2014-11-16 22:40:04
R12i Advanced Pricing Fundamentals - Introduction on R12.2.3 (FREE) 2014-11-16 22:41:02
R12i Oracle Shipping Execution Fundamentals - Introduction on R12.2.3 (FREE) 2014-11-16 22:42:16
R12.2 Install Patch and Maintain Oracle E Business Suite (FREE) 2014-11-16 22:43:15
R12i Oracle Project Costing Fundamentals on R12.2.3 (FREE) 2014-11-16 22:44:19
Oracle E-Business Suite Release 12.2.4 Installation and Patching - End To End 2015-10-27 23:44:25
SQL Fundamentals for Oracle Functional Consultants – Basic (FREE) 2014-12-27 09:31:08
Oracle VM Installation and Administration on Linux x86-64 2015-05-02 11:10:12
Oracle AIM Fundamentals 2015-07-12 10:22:00
R11i Oracle E-Business Suite Installation 2015-08-13 11:52:06
R12i Oracle Financial Concepts 2016-04-21 13:29:25
R12i Oracle O2C Lifecycle in integration with iStore and iReceivables 2016-04-18 14:05:20
Oracle E-Business Suite Release 12.2 Installation in Cloud Server 2018-02-15 04:26:22
Oracle E-Business Suite Release 12.2.0 to 12.2.5 Upgrade in Cloud Server 2018-02-25 04:26:00
How to Install Oracle E-Business Suite Release 12.2.5 in Ten Steps? (FREE) 2016-03-24 15:48:12
R12i Oracle Services Procurement Fundamentals - processes for Fixed Priced Contracts 2019-09-03 23:00:08

Requirements

Others:

+ Basic functional knowledge of Oracle E-Business Suite + No prior knowledge of SQL is required
Quiz Status
Viewed
Level
Introduction
Overview of SQL
Download and Install SQL Developer
Retrieving Data using the SQL SELECT Statement
Entity Relationship (ER) Diagrams for Oracle Applications database tables
Retrieving Data using SQL from Multiple Tables
Free for members