Oracle SQL Training

This self-paced training course will teach you the basics of writing SQL queries with Oracle.

SHARE
6 Months / 56 Course Hrs
Open Enrollment
Offered in partnership with your preferred school

University of Central Florida

Change School
Learning method

Oracle SQL Training

Enroll Now

Course code: T9790

Mastering Oracle SQL is one 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.

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 you will benefit

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

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 you will benefit

  • Gain the SQL skills that every developer needs
  • Bring your SQL knowledge to any web development job

How the course is taught

  • Self-Guided, online course
  • 6 Months access
  • 56 course hours
  1. Relational Database Basics
  2. Creating Tables
  3. Basic Selects
  4. Oracle SQL Functions
  5. Aggregate Functions
  6. Subqueries
  7. Set Operators
  8. Conditional Processing with CASE
  9. Data Manipulation Language
  10. Creating Views
Self-Study

Prerequisites:

Prior to enrolling in this course, we recommend having an intermediate understanding of SQL or taking the Introduction to SQL Training course.

Requirements:

Hardware Requirements:

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

Software Requirements:

  • PC: Windows 10 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.

Other:

  • Software must be installed and fully operational before the course begins.

Instructional Material Requirements:

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

Your course begins immediately after you enroll.​

You have 3 months of access to the course. After enrolling, you can learn and complete the course at your own pace, within the allotted access period. You will have the opportunity to interact with other students in the online discussion area.

There is no time limit to complete each lesson, other than completing all lessons within the allotted access period. Discussion areas for each lesson are open for the entire duration of the course.

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