Oracle Database 19c: Advanced SQL
2h 2mAdvanced2021-02-18
Authors
Bob Bryla
30 years of experience in the database business
Course details
Mastering SQL is an essential skill for any Oracle Database professional. If you feel like you’ve got a firm handle on the basics and want to take your skills up a notch, this course is for you. Join Oracle Database administrator Bob Bryla as he covers the advanced features of Oracle SQL in an Oracle 19c Database environment. Bob explains advanced topics like database concurrency and isolation levels, Oracle-specific schema objects, data types, data models, and many more features you need to understand to become an Oracle SQL expert. At the end of this course, if you’re still hungry for more, Bob provides a list of resources to help you continue your learning.
Skills covered
Oracle DatabaseDatabase AdministrationDatabase DevelopmentOracleDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsSoftware DevelopmentDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Oracle Database Advanced SQL - Why 19c
1. Single- and Multi-Row Functions
- 02 - Hierarchical functions
- 03 - NULL-handling functions
- 04 - Analytic functions, grouping in a window
2. Set Operators
- 05 - Set operators and their order
- 06 - UNION
- 07 - UNION ALL
- 08 - INTERSECT
- 09 - MINUS
- 10 - Using ORDER BY with set operators
3. DML - MERGE
- 11 - Overview of DML statements
- 12 - MERGE statement overview
- 13 - INTO clause
- 14 - USING clause
- 15 - WHEN MATCHED . . . UPDATE clause
- 16 - WHEN NOT MATCHED . . . INSERT clause
- 17 - DELETE clause
4. Data Definition Language Overview
- 18 - DDL command types
- 19 - Transactions and DDL commands
5. DML - Transaction Processing
- 20 - Using COMMIT
- 21 - Using ROLLBACK
- 22 - Using SAVEPOINTs
6. DDL - Creating and Manipulating Objects
- 23 - Truncating tables
- 24 - Synonyms
- 25 - Sequences
7. DDL - Managing Constraints with Indexes
- 26 - Row-level constraints (same column or another column)
- 27 - Unique indexes and constraints
- 28 - Overview of indexes
- 29 - Primary key constraints
- 30 - Foreign key constraints
Conclusion
- 31 - After Advanced 19c SQL