OD-19c-SQLW: Oracle Database 19c: SQL Workshop 

Module 1: Course Overview

• Course Overview – Oracle Database 19c: SQL Workshop

Module 2: Introduction

• Introduction
• Practice 1-1: Introduction

Module 3: Retrieving Data Using the SQL SELECT Statement

• Retrieving Data Using the SQL SELECT Statement
• Practice 2-1: Retrieving Data Using the SQL SELECT Statement

Module 4: Restricting and Sorting Data

• Restricting and Sorting Data
• Practice 3-1: Restricting and Sorting Data

Module 5: Using Single-Row Functions to Customize Output

• Using Single-Row Functions to Customize Output
• Practice 4-1: Using Single-Row Functions to Customize Output

Module 6: Using Conversion Functions and Conditional Expressions

• Using Conversion Functions and Conditional Expressions
• Using the COALESCE Function
• Practice 5-1: Using Conversion Functions and Conditional Expressions

Module 7: Reporting Aggregated Data Using the Group Functions

• Reporting Aggregated Data Using the Group Functions
• Practice 6-1: Reporting Aggregated Data by Using Group Functions

Module 8: Displaying Data from Multiple Tables Using Joins

• Displaying Data from Multiple Tables Using Joins
• Practice 7-1: Displaying Data from Multiple Tables by Using Joins

Module 9: Using Subqueries to Solve Queries

• Using Subqueries to Solve Queries
• Practice 8-1: Using Subqueries to Solve Queries

Module 10: Using Set Operators

• Using Set Operators
• Practice 9-1: Using Set Operators

Module 11: Managing Tables Using DML Statements

• Managing Tables Using DML Statements in Oracle
• Managing Tables Using DML Statements in MySQL
• Practice 10-1: Managing Tables by Using DML Statements

Module 12: Introduction to Data Definition Language

• Introduction to Data Definition Language in Oracle
• Introduction to Data Definition Language in MySQL
• Practice 11-1: Introduction to Data Definition Language

Module 13: Introduction to Data Dictionary Views

• Introduction to Data Dictionary Views
• Practice 12-1: Introduction to Data Dictionary Views

Module 14: Creating Sequences, Synonyms, and Indexes

• Creating Sequences, Synonyms, and Indexes
• Practice 13-1: Creating Sequences, Synonyms, and Indexes

Module 15: Creating Views

• Creating Views
• Practice 14-1: Creating Views

Module 16: Managing Schema Objects

• Managing Schema Objects
• Practice 15-1: Managing Schema Objects

Module 17: Retrieving Data by Using Subqueries

• Retrieving Data by Using Subqueries
• Practice 16-1: Retrieving Data by Using Subqueries

Module 18: Manipulating Data by Using Subqueries

• Manipulating Data by Using Subqueries
• Practice 17-1: Manipulating Data by Using Subqueries

Module 19: Controlling User Access

• Controlling User Access
• Practice 18-1: Controlling User Access

Module 20: Manipulating Data Using Advanced Queries

• Manipulating Data Using Advanced Queries
• Practice 19-1: Manipulating Data Part 1
• Practice 19-1: Manipulating Data Part 2

Module 21: Managing Data in Different Time Zones

• Managing Data in Different Time Zones
• Practice 20-1: Managing Data in Different Time Zones

Module 22: Conclusion

• Conclusion