Oracle Database 19c: Advanced SQL

In this course, Bob Bryla covers the advanced features of Oracle SQL in an Oracle 19c Database environment.

Introduction

• Oracle Database Advanced SQL: Why 19c?

1. Single- and Multi-Row Functions

• Hierarchical functions
• NULL-handling functions
• Analytic functions, grouping in a window
• SQL Macro table functions

2. Set Operators

• Set operators and their order
• UNION
• UNION ALL
• INTERSECT
• MINUS
• Using ORDER BY with set operators

3. DML: MERGE

• Overview of DML statements
• MERGE statement overview
• INTO clause
• USING clause
• WHEN MATCHED . . . UPDATE clause
• WHEN NOT MATCHED . . . INSERT clause
• DELETE clause

4. Data Definition Language Overview

• DDL command types
• Transactions and DDL commands

5. DML: Transaction Processing

• Using COMMIT
• Using ROLLBACK
• Using SAVEPOINTs

6. DDL: Creating and Manipulating Objects

• Truncating tables
• Synonyms
• Sequences

7. DDL: Managing Constraints with Indexes

• Row-level constraints (same column or another column)
• Unique indexes and constraints
• Overview of indexes
• Primary key constraints
• Foreign key constraints

Conclusion

• After Advanced 19c SQL