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
Resolve the captcha to access the links!