# Oracle Database 19c SQL Workshop - Table of Contents

This folder contains the study note chapters only. Lab documents are not included.

## Lessons

1. [01 - Course Introduction](01_Course_Introduction.md)
2. [02 - Retrieving Data Using the SQL SELECT Statement](02_Retrieving_Data_Using_the_SQL_SELECT_Statement.md)
3. [03 - Restricting and Sorting Data](03_Restricting_and_Sorting_Data.md)
4. [04 - Using Single-Row Functions to Customize Output](04_Using_Single-Row_Functions_to_Customize_Output.md)
5. [05 - Using Conversion Functions and Conditional Expressions](05_Using_Conversion_Functions_and_Conditional_Expressions.md)
6. [06 - Reporting Aggregated Data Using Group Functions](06_Reporting_Aggregated_Data_Using_Group_Functions.md)
7. [07 - Displaying Data from Multiple Tables Using Joins](07_Displaying_Data_from_Multiple_Tables_Using_Joins.md)
8. [08 - Using Subqueries to Solve Queries](08_Using_Subqueries_to_Solve_Queries.md)
9. [09 - Using Set Operators](09_Using_Set_Operators.md)
10. [10A - Managing Tables Using DML Statements in Oracle](10A_Managing_Tables_Using_DML_Statements_in_Oracle.md)
11. [10B - Managing Tables Using DML Statements in MySQL](10B_Managing_Tables_Using_DML_Statements_in_MySQL.md)
12. [11A - Introduction to Data Definition Language in Oracle](11A_Introduction_to_Data_Definition_Language_in_Oracle.md)
13. [11B - Introduction to Data Definition Language in MySQL](11B_Introduction_to_Data_Definition_Language_in_MySQL.md)
14. [12 - Introduction to Data Dictionary Views](12_Introduction_to_Data_Dictionary_Views.md)
15. [13 - Creating Sequences, Synonyms, and Indexes](13_Creating_Sequences_Synonyms_and_Indexes.md)
16. [14 - Creating Views](14_Creating_Views.md)
17. [15 - Managing Schema Objects](15_Managing_Schema_Objects.md)
18. [16 - Retrieving Data by Using Subqueries](16_Retrieving_Data_by_Using_Subqueries.md)
19. [17 - Manipulating Data by Using Subqueries](17_Manipulating_Data_by_Using_Subqueries.md)
20. [18 - Controlling User Access](18_Controlling_User_Access.md)
21. [19 - Manipulating Data Using Advanced Queries](19_Manipulating_Data_Using_Advanced_Queries.md)
22. [20 - Managing Data in Different Time Zones](20_Managing_Data_in_Different_Time_Zones.md)