Oracle Database 23ai: SQL Workshop

1    Introduction

2    Retrieving Data Using the SQL SELECT Statement

3    Restricting and Sorting Data

4    Using Single-Row Functions to Customize Output

5    Using Conversion Functions and Conditional Expressions

6    Reporting Aggregated Data Using the Group Functions

7    Displaying Data from Multiple Tables Using Joins

8    Using Subqueries to Solve Queries

9    Using Set Operators

10  Managing Tables Using DML Statements

11  Introduction to Data Definition Language

12  Introduction to Data Dictionary Views

13  Creating Sequences, Synonyms, and Indexes

14  Creating Views

15  Managing Schema Objects

16  Retrieving Data by Using Subqueries

17   Manipulating Data by Using Subqueries

18  Controlling User Access

19  Manipulating Data Using Advanced Queries

20  Managing Data in Different Time Zones

A   Table Descriptions

B   Using SQL Developer

C   Using SQL*Plus

D   Commonly Used SQL Commands

E    Generating Reports by Grouping Related Data

F    Hierarchical Retrieval

G   Writing Advanced Scripts

H   Oracle Database Architectural Components

I     Regular Expression Support

J    MySQL Syntax