Description

The Oracle Database 19c: SQL Workshop course offers students an introduction to Oracle Database 19c database technology. In this class, students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

Skills Gained

Identify the major components of an Oracle Database
Retrieve row and column data from tables with the SELECT statements
Create reports of sorted and restricted data
Employee SQL functions

Upcoming Classes

Virtual Classroom Live
January 20, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Virtual Classroom Live
February 10, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Virtual Classroom Live
March 10, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Virtual Classroom Live
April 07, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Virtual Classroom Live
May 12, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Virtual Classroom Live
June 02, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Private Training Available

No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.

Course Overview

Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables Using Joins
Using Subqueries to Solve Queries
Using the Set Operators
Manipulating Data
Introduction to Data Definition Language
Introduction to Data Dictionary Views
Creating Sequences, Synonyms, and Indexes
Creating Views
Managing Schema Objects
Retrieving Data by Using Subqueries
Controlling User Access
Manipulating Data Using Advanced Queries
Managing Data in Different Time Zones

Upcoming Classes

Virtual Classroom Live
January 20, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Virtual Classroom Live
February 10, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Virtual Classroom Live
March 10, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Virtual Classroom Live
April 07, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Virtual Classroom Live
May 12, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Virtual Classroom Live
June 02, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Private Training Available

No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.

Prerequisites

none

Upcoming Classes

Virtual Classroom Live
January 20, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Virtual Classroom Live
February 10, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Virtual Classroom Live
March 10, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Virtual Classroom Live
April 07, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Virtual Classroom Live
May 12, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Virtual Classroom Live
June 02, 2025

$5,000.00

5 Days 9 AM ET - 5 PM ET

Private Training Available

No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.

Oracle Database 19c: SQL Workshop

5 Days

Description

Skills Gained

Upcoming Classes

Course Overview

Upcoming Classes

Prerequisites

Upcoming Classes

Find a Course

Corporate Services

Contact us