Oracle Database 19c: SQL Workshop

Prerequisites:

• Basic Knowledge of SQL

Audience

• Database Administrators

Course Outline

• Introduction
• Retrieving Data Using the SQL SELECT Statement
• Restricting and Sorting Data
• Using Single-Row Functions to Customize Output
• Using Conversion Functions and Conditional Expressions
• Reporting Aggregated Data Using the Group Functions
• Displaying Data from Multiple Tables Using Joins
• Using Subqueries to Solve Queries
• Using Set Operators
• Managing Tables Using DML Statements in Oracle
• Introduction to Data Definition Language in Oracle
• Introduction to Data Dictionary Views
• Creating Sequences, Synonyms, and Indexes
• Creating Views
• Managing Schema Objects
• Retrieving Data by Using Subqueries
• Manipulating Data by Using Subqueries
• Controlling User Access
• Manipulating Data Using Advanced Queries
• Managing Data in Different Time Zones
• Conclusion