Oracle Database 19c: SQL Workshop Course Overview

The Oracle Database 19c: SQL Workshop course is an extensive training program designed to teach learners the essential skills for working with the SQL language within the Oracle Database 19c environment. This course covers a broad spectrum of SQL techniques, from basic Data retrieval to more complex functions such as manipulating data and managing user access.

Starting with an introduction, participants quickly move on to learn how to retrieve data using the SQL SELECT statement, apply restrictions, sort data, and customize output with Single-row functions. Conversion functions, Conditional expressions, and Group functions are explored to report aggregated data.

Learners will gain practical experience with Multiple-table joins, Subqueries, Set operators, and data manipulation language (DML) statements. The course teaches data definition language (DDL) basics, explores data dictionary Views, and instructs on Creating sequences, Synonyms, Indexes, and Views. Schema object management, Advanced queries, User access control, and Managing data across different time zones are also key components of this comprehensive workshop.

By completing the Oracle Database 19c: SQL Workshop, participants will develop a robust understanding of Oracle SQL, enabling them to effectively manage and query an Oracle database, enhancing their database management and analysis skills.