Oracle Database 19c: Advanced SQL

Focused View

Bob Bryla

2:01:34

0 View

01 Introduction

001 Oracle Database Advanced SQL Why 19c .mp4

01:03

02 Single- and Multi-Row Functions

001 Hierarchical functions.mp4

05:36

002 NULL-handling functions.mp4

05:22

003 Analytic functions grouping in a window.mp4

04:55

03 Set Operators

001 Set operators and their order.mp4

04:14

002 UNION.mp4

04:31

003 UNION ALL.mp4

03:49

004 INTERSECT.mp4

03:41

005 MINUS.mp4

04:37

006 Using ORDER BY with set operators.mp4

02:50

04 DML MERGE

001 Overview of DML statements.mp4

05:03

002 MERGE statement overview.mp4

03:48

003 INTO clause.mp4

02:47

004 USING clause.mp4

02:33

005 WHEN MATCHED . . . UPDATE clause.mp4

03:37

006 WHEN NOT MATCHED . . . INSERT clause.mp4

03:10

007 DELETE clause.mp4

03:08

05 Data Definition Language Overview

001 DDL command types.mp4

03:35

002 Transactions and DDL commands.mp4

02:52

06 DML Transaction Processing

001 Using COMMIT.mp4

05:06

002 Using ROLLBACK.mp4

02:00

003 Using SAVEPOINTs.mp4

03:27

07 DDL Creating and Manipulating Objects

001 Truncating tables.mp4

04:17

002 Synonyms.mp4

05:13

003 Sequences.mp4

04:32

08 DDL Managing Constraints with Indexes

001 Row-level constraints (same column or another column).mp4

04:43

002 Unique indexes and constraints.mp4

04:06

003 Overview of indexes.mp4

05:36

004 Primary key constraints.mp4

03:57

005 Foreign key constraints.mp4

06:14

09 Conclusion

001 After Advanced 19c SQL.mp4

01:12

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle SQL

Bob Bryla

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.