Oracle SQL Training

Mastering Oracle SQL is one of today's most marketable programming skills for end-to-end developers. This online, self-paced course covers the basics of Oracle SQL. You will learn the fundamentals, including queries, procedures, and functions through hands-on assignments. By course completion, your SQL skills will be on par with industry standards.

6 Months / 56 Course Hrs

Open enrollment

Offered in Partnership with your Preferred School

ed2go

Why this school?

Change School

Learning Method

Self-Paced

No instructor. Study on your own schedule

Oracle SQL Training

Details + Objectives
Course Code: T9790

What You Will Learn

How tables are structured and how data is stored
To use Oracle to output reports and to use SQL functions
To group data to get aggregate values
To write joins and subqueries to get data from multiple tables and to write INSERT, UPDATE, and DELETE statements
To use SET operators and to do conditional processing with CASE

How the course is taught

Self-paced, online course
6 months to complete
Open enrollment, begin anytime
56 course hours

How you will benefit

Gain skills that every developers needs
Bring your SQL skills to any web development job

Outline

Expand All

Details

I.	Relational Database Basics
II.	Creating Tables
III.	Basic Selects
IV.	Oracle SQL Functions
V.	Aggregate Functions
VI.	Subqueries
VII.	Set Operators
VIII.	Conditional Processing with CASE
IX.	Data Manipulation Language
X.	Creating Views

Requirements

Prerequisites:

Prior to enrolling in this course, it is recommended that you have an intermediate understanding of SQL or take the Oracle SQL Training course.

Requirements:

Hardware Requirements:

This course must be taken on a PC. Macs are not compatible.

Software Requirements:

Windows 7 or later.
Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS.
Oracle SQL Developer - The client interface for connecting to Oracle. (Software not included)
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Adobe Acrobat Reader. Click here to download the Acrobat Reader.
Software must be installed and fully operational before the course begins.

Other:

Email capabilities and access to a personal email account.

Instructional Materials

The instructional materials required for this course are included in enrollment and will be available online.

FAQs

Expand All

When can I get started?

You can start this course at any time your schedule permits.

How does it work?

You have three-month access to the course. After enrolling, you can learn and complete the course at your own pace, within the allotted access period.

How long do I have to complete each lesson?

There is no time limit to complete each lesson, other than completing all lessons before your six-month access.

What if I need an extension?

Because this course is self-paced, no extensions will be granted after the start of your enrollment.

Browse All

Oracle SQL Training

Oracle SQL Training

Details + Objectives Course Code: T9790

Outline

Requirements

FAQs

Details + Objectives
Course Code: T9790