Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
In this course, Bob Bryla covers the advanced features of Oracle SQL in an Oracle 19c Database environment.
Start speaking a new language. It’s just 3 weeks away.
Master AI & Data—50% Off Udacity (Code CC50)
Overview
Syllabus
Introduction
- Oracle Database Advanced SQL: Why 19c?
- Hierarchical functions
- NULL-handling functions
- Analytic functions, grouping in a window
- SQL Macro table functions
- Set operators and their order
- UNION
- UNION ALL
- INTERSECT
- MINUS
- Using ORDER BY with set operators
- Overview of DML statements
- MERGE statement overview
- INTO clause
- USING clause
- WHEN MATCHED . . . UPDATE clause
- WHEN NOT MATCHED . . . INSERT clause
- DELETE clause
- DDL command types
- Transactions and DDL commands
- Using COMMIT
- Using ROLLBACK
- Using SAVEPOINTs
- Truncating tables
- Synonyms
- Sequences
- Row-level constraints (same column or another column)
- Unique indexes and constraints
- Overview of indexes
- Primary key constraints
- Foreign key constraints
- After Advanced 19c SQL
Taught by
Bob Bryla
