How will this course help me write better SQL queries for real-world data analysis?

This course teaches you how to use SELECT statements, joins, subqueries, and SQL functions to retrieve and analyze data from one or more Oracle tables. You’ll gain hands-on experience writing queries that support business reporting, troubleshooting, and application development.

How does this course help with managing database objects like views or indexes?

You’ll learn how to create and maintain key database objects—including views, indexes, sequences, and synonyms—enabling you to optimize performance and structure data access for secure and efficient applications.

Do I need previous SQL experience?

No prior SQL experience is required, but familiarity with databases or programming concepts will be helpful.

Does this course prepare me for any Oracle certification?

While this course is not tied to a specific exam, it provides the essential SQL knowledge required for Oracle’s foundational certifications—particularly the Oracle Database SQL Certified Associate (Exam 1Z0-071). Completing this course is an excellent first step toward earning that credential.

Oracle Database 19c: SQL Workshop Training Course

Q: What is the Oracle Database 19c: SQL Workshop course?

It’s a 5-day, instructor-led course that provides foundational SQL training for Oracle Database 19c. Students learn to write queries, manage data, and create database structures.

Price
$4,000.00 USD

Duration
5 Days

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information

Download Course Details

Course Details Only
Course Details & Schedule

Skip to Class Dates

Course Overview

Don’t just code—decode the data that matters.

SQL appears in over 45% of technical job postings. The Oracle Database 19c: SQL Workshop Training Course teaches essential SQL skills needed to work with Oracle’s powerful relational database system.

This 5-day, hands-on training introduces relational concepts and SQL usage in Oracle Database 19c—you’ll write queries, manipulate data, and create essential database structures in a real Oracle environment.

Course Objectives

By the end of this course, you’ll be able to:

Retrieve data using SELECT, filtering, sorting, and formatting output
Use SQL functions, joins, and subqueries for data analysis
Create and manage views, indexes, sequences, and synonyms
Perform DML and manage transaction control
Control access and work with time zone–aware data types

Who Should Attend?

Designed for developers, data analysts, DBAs, and technical professionals needing foundational Oracle SQL skills for application development, reporting, or database management.

Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

What is the Oracle Database 19c: SQL Workshop course?

A 5-day instructor-led course providing foundational Oracle SQL training with query writing, data manipulation, and database object handling.

How will this course help me write real-world SQL queries?

You’ll master functions, joins, subqueries, and filtering through applied, hands-on labs—ideal for reporting and development.

How does this course help manage database objects like views or indexes?

You’ll practice creating and optimizing views, indexes, sequences, and synonyms to structure and speed data access.

Is prior SQL experience required?

No background in SQL is needed; familiarity with databases or coding is beneficial but not essential.

Does this course support Oracle certification?

While not tied to an exam, it prepares candidates for the Oracle Database SQL Certified Associate (1Z0-071) credential.

Agenda

1. Retrieving Data Using the SELECT Statement

Syntax, expressions, operators
Column aliases, arithmetic expressions

2. Restricting and Sorting Data

WHERE clause filters
ORDER BY

3. Single-Row Functions

Text, number, date functions
Function nesting

4. Conversion Functions & Conditional Logic

TO_CHAR, TO_DATE, NVL, COALESCE
CASE, DECODE

5. Group Queries & Aggregation

COUNT, AVG, SUM, MIN, MAX
GROUP BY, HAVING

6. Data from Multiple Tables

Inner, outer, self joins
ANSI and Oracle syntax

7. Using Subqueries

Single-row, multiple-row, correlated subqueries
EXISTS, IN, NOT IN

8. Set Operators

UNION, INTERSECT, MINUS

9. DML Operations

INSERT, UPDATE, DELETE
COMMIT, ROLLBACK

10. Data Definition Language

CREATE, ALTER, DROP
Table/column constraints

11. Data Dictionary Views

USER_TABLES, ALL_TABLES
Metadata overview

12. Sequences, Synonyms & Indexes

Auto-increment values
Access simplification, performance optimization

13. Working with Views

Simple/complex views
Managing updatable views

14. Schema Object Management

Dropping, renaming, truncating objects
Modifying columns, constraints

15. Advanced Subqueries

Complex subquery patterns

16. User Access Control

GRANT, REVOKE, roles
System/object privileges

17. Advanced DML

MERGE, multi-table INSERT

18. Time Zone Data Management

Time zone-aware types
Formatting/conversions

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.