Oracle Database 19c: SQL Workshop

Skip to Scheduled 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.

Who Should Attend

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

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

Course Outline

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

< Back to Course Search

Class Dates & Times

Class times are listed Central time

This is a 5-day class

Class dates not listed.
Please contact us for available dates and times.