Oracle Database 19c: SQL Workshop

COURSE TOPICS

Module 1 : Introduction

• Introduction
• Practice 1-1: Introduction

Module 2 : 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 3 : Restricting and Sorting Data

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

Module 4 : 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 5 : 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 6 : Reporting Aggregated Data Using the Group Functions

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

Module 7 : Displaying Data from Multiple Tables Using Joins

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

Module 8 : Using Subqueries to Solve Queries

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

Module 9 : Using Set Operators

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

Module 10 : Managing Tables Using DML Statements

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

Module 11 : 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 12 : Introduction to Data Dictionary Views

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

Module 13 : Creating Sequences, Synonyms, and Indexes

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

Module 14 : Creating Views

• Creating Views
• Practice 14-1: Creating Views

 Module 15 : Managing Schema Objects

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

Module 16 : Retrieving Data by Using Subqueries

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

Module 17 : Manipulating Data by Using Subqueries

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

 Module 18 : Controlling User Access

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

Module 19 : 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 20 : Managing Data in Different Time Zones

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

Module 21 : Conclusion

• Conclusion