Oracle Database 19c: Advanced SQL

Oracle Database 19c: Advanced SQL

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 2h 01m | 337 MB

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.
+ Table of Contents

Introduction
1 Oracle Database Advanced SQL Why 19c

Single- and Multi-Row Functions
2 Hierarchical functions
3 NULL-handling functions
4 Analytic functions grouping in a window

Set Operators
5 Set operators and their order
6 UNION
7 UNION ALL
8 INTERSECT
9 MINUS
10 Using ORDER BY with set operators

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

Data Definition Language Overview
18 DDL command types
19 Transactions and DDL commands

DML Transaction Processing
20 Using COMMIT
21 Using ROLLBACK
22 Using SAVEPOINTs

DDL Creating and Manipulating Objects
23 Truncating tables
24 Synonyms
25 Sequences

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