Oracle Database 19c: Advanced SQL

Focused View

Bob Bryla

2:01:34

0 View

01.01-oracle database advanced sql why 19c.mp4

01:03

02.01-hierarchical functions.mp4

05:36

02.02-null-handling functions.mp4

05:22

02.03-analytic functions grouping in a window.mp4

04:55

03.01-set operators and their order.mp4

04:14

03.02-union.mp4

04:31

03.03-union all.mp4

03:49

03.04-intersect.mp4

03:41

03.05-minus.mp4

04:37

03.06-using order by with set operators.mp4

02:50

04.01-overview of dml statements.mp4

05:03

04.02-merge statement overview.mp4

03:48

04.03-into clause.mp4

02:47

04.04-using clause.mp4

02:33

04.05-when matched . . . update clause.mp4

03:37

04.06-when not matched . . . insert clause.mp4

03:10

04.07-delete clause.mp4

03:08

05.01-ddl command types.mp4

03:35

05.02-transactions and ddl commands.mp4

02:52

06.01-using commit.mp4

05:06

06.02-using rollback.mp4

02:00

06.03-using savepoints.mp4

03:27

07.01-truncating tables.mp4

04:17

07.02-synonyms.mp4

05:13

07.03-sequences.mp4

04:32

08.01-row-level constraints (same column or another column).mp4

04:43

08.02-unique indexes and constraints.mp4

04:06

08.03-overview of indexes.mp4

05:36

08.04-primary key constraints.mp4

03:57

08.05-foreign key constraints.mp4

06:14

09.01-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.