SQL Fundamentals for Oracle Functional Consultants – Basic (FREE)

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

No certificate is given for this course

Free for members

Table of Contents

Viewed
Level

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

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 and  Enterprise Architecture. Originally from India, he has travelled extensively on consulting assignments across South Asia and Australasia, and now lives in New Zealand. He has worked with some of the well known large corporations, including Oracle Corporation.

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 loves to go on hiking to New Zealand's natural bushes, beaches and countryside over the weekend.

View Kabeer Khan's profile on LinkedIn

 

Courses by this teacher

Name Level Release Date
R12i Oracle Procurement Contracts Fundamentals 2014-10-04 05:06:16
R12i Oracle Sourcing Fundamentals 2014-10-04 05:14:00
R12i Oracle iSupplier Portal Fundamentals 2014-10-04 05:17:06
R12i Oracle Services Procurement Fundamentals 2014-10-04 05:20:04
R12i Oracle Payables Fundamentals 2016-04-21 13:32:17
R12i Oracle Workflow and Alerts Overview 2016-04-21 13:28:27
R12i Oracle iStore Fundamentals (on 12.2.3) 2016-04-20 13:47:00
R12i Oracle Inventory Fundamentals 2014-10-04 05:35:28
R12i Oracle Order Management Fundamentals 2014-10-04 05:39:58
R12i Oracle E Business Suite Fundamentals - Advanced 2016-04-21 13:27:33
R12i Oracle Payables - Advanced 2014-10-04 05:48:52
R12i Oracle Internet Expenses Fundamentals 2014-10-04 05:52:40
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 Project Portfolio Analysis Fundamentals 2016-04-07 06:10:00
R12i Oracle General Ledger - Financials Functional Foundation 2016-04-21 13:30:25
R12i Oracle E-Business Tax Fundamentals 2016-04-21 13:31:20
R12i Oracle Purchasing Fundamentals 2014-10-04 06:18:44
R12i Oracle Receivables Fundamentals 2014-10-04 06:23:23
R12i Oracle iProcurement Fundamentals 2014-10-04 06:28:12
R12i Oracle Shipping Execution Fundamentals 2014-10-04 06:30:54
R12i Advanced Pricing Fundamentals 2014-10-04 06:30:54
R12i Oracle Service Contracts Fundamentals 2014-10-04 06:30:54
Oracle Fusion Applications Installation, Patching and Administration 2014-10-04 06:44:19
Oracle Fusion General Ledger - Functional Foundation (on R11.1.7) 2014-10-04 06:47:39
R12i Oracle Purchasing - Advanced 2016-04-21 13:43:10
R12i Oracle Sourcing - Advanced 2014-10-04 06:57:44
R12i Oracle Project Costing Fundamentals 2014-10-04 07:00:37
R12i Oracle Project Resource Management Fundamentals 2016-04-04 14:17:23
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
Buy ALL Courses (E Business Suite) 2014-11-18 23:51:53
Buy ALL Courses (EBS + FA) 2014-11-18 23:57:04
Oracle E-Business Suite Release 12.2.4 Installation and Patching - End To End 2015-10-27 23:44:25
Mock Interview - Oracle Functional Consultant 2014-12-07 11:16:05
How to change Career from Oracle Technical to Functional Consultant 2014-12-07 11:25:18
R12i Oracle Project Management Fundamentals 2014-12-11 06:04:31
SQL Fundamentals for Oracle Functional Consultants – Basic (FREE) 2014-12-27 09:31:08
Oracle Fusion Applications 11g Essentials 2015-03-08 09:37:24
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 2016-02-15 04:26:22
Oracle E-Business Suite Release 12.2.0 to 12.2.5 Upgrade in Cloud Server 2016-02-25 04:26:00
Buy ALL Cloud Computing Courses 2016-02-24 23:51:00
How to Install Oracle E-Business Suite Release 12.2.5 in Ten Steps? (FREE) 2016-03-24 15:48:12
Oracle Functional Consultant Career – Q & A 2016-05-18 14:48:21

Requirements

Others:

+ Basic functional knowledge of Oracle E-Business Suite

+ No prior knowledge of SQL is required

Quiz Status
Viewed
Duration
Level
Free for members