[Last updated 4/2024] Advanced SQL : The Ultimate Guide (2024) (Udemy – Vietsub and Engsub)

About Course

Views

What you’ll learn:
All the Advanced SQL Subjects Necessary for Becoming an Expert in SQL!
Learn How to Construct Advanced SQL Queries with Hundreds of Examples!
Easily Write, Read, and Analyze Any Advanced SQL Queries!
Over 130+ Lectures, 13+ Hours of On-Demand High-Quality Content!
Learn Advanced SQL Functions in Oracle
Get a Better Job and Income!
Master at Analytical SQL Functions in Oracle
Learn How to Work with Regular Expressions
Introducing Database Objects
Creating and Using Indexes
Creating and Using Views
Creating and Using Synonyms
Creating and Using Sequences
Data Dictionary Views
Using Advanced Subqueries
v.v…
Time video:
13.5 hours (147 Lessons + Documents)
Teacher:
Database Masters Training
Total weight:
5.96 GB

Original link:
https://www.udemy.com/course/sql-advanced/

Course Content

10 – Using Advanced Subqueries

001 Using Subqueries as a Source.mp4

05:56
002 Scalar Subqueries.mp4

09:11
003 Multiple Column Subqueries.mp4

07:21
004 Correlated Subqueries.mp4

04:18
005 EXISTS Operator.mp4

05:15
006 NOT EXISTS Operator.mp4

04:56
007 Using WITH Clause.mp4

06:31
008 Using Recursive WITH Clause.mp4

05:33
009 Inserting Data By Using a Subquery as a Target.mp4

07:06
010 Manipulating Data by Using WITH CHECK OPTION Keyword.mp4

06:24
011 Correlated Update.mp4

06:15
012 Correlated Delete.mp4

02:33

18 – Appendix + Conclusion

17 – SQL Analytic Functions

001 What are the Analytic Functions.mp4

12:34
002 ROW_NUMBER Analytic Function.mp4

04:22
003 RANK and DENSE_RANK Analytic Functions.mp4

04:51
004 LEAD & LAG Analytic Functions (Next & Previous Values).mp4

08:13
005 Windowing Clause in Analytic Functions – Part 1.mp4

10:55
006 Windowing Clause in Analytic Functions – Part 2.mp4

09:16
007 INTERVAL Keyword In Analytic Functions.mp4

04:26
008 FIRST_VALUE and LAST_VALUE Analytic Functions.mp4

06:46
009 Selecting Top-N Rows with Analytic Functions.mp4

04:22

16 – Regular Expressions

001 What is Regular Expressions and Why and Where Do We Use Them.mp4

02:27
002 What Are Metacharacters.mp4

13:37
003 Regular Expression Functions.mp4

02:33
004 Using REGEXP_LIKE() function.mp4

04:44
005 Using REGEXP_REPLACE() Function.mp4

10:18
006 Using REGEXP_SUBSTR() Function.mp4

08:34
007 Using REGEXP_INSTR() Function.mp4

06:11
008 Using REGEXP_COUNT() Function.mp4

04:00
009 Using REGEX in Constraints.mp4

04:59

15 – Generating Dynamic SQL Scripts

14 – Hierarchical Queries (Tree Structure)

13 – Administering User Privileges and Roles

001 What Are Privileges And Why Are They Used For.mp4

02:46
002 Creating A User.mp4

03:55
003 System Privileges.mp4

03:58
004 Granting System Privileges.mp4

07:07
005 What is A Role and Why is It Used For.mp4

04:27
006 Changing The User Password.mp4

05:05
007 Object Privileges.mp4

02:01
008 Granting Object Privileges.mp4

10:29
009 Revoking Object Privileges.mp4

03:13
010 Searching For Privileges in Data Dictionary Views.mp4

06:44

12 – Constraints (Controlling Schema Objects)

001 Adding Constraints.mp4

07:25
002 Removing Constraints.mp4

03:51
003 On Delete CASCADE & On Delete SET NULL.mp4

09:35
004 Cascading Constraints.mp4

03:57
005 Renaming Constraints.mp4

02:39
006 Disabling Constraints.mp4

03:02
007 Enabling Constraints.mp4

02:34
008 Status Of Constraints.mp4

03:03
009 Deferring Constraints.mp4

13:48
010 Creating Temporary Tables.mp4

10:28

11 – Advanced Data Manipulations

001 Using DEFAULT Keyword on Insert And Update Statements.mp4

05:58
002 Multitable Insert Statements.mp4

01:20
003 Unconditional Insert Statements.mp4

06:31
004 Conditional Insert Statements.mp4

08:06
005 Conditional Insert First Statements.mp4

05:21
006 Pivoting Insert.mp4

04:28
007 Merging Data.mp4

10:03
008 Flashback Operations.mp4

11:06
009 Purge Operations.mp4

04:02
010 Tracking Changes In Data In a Particular Time.mp4

01:28
011 FLASHBACK Query.mp4

06:31
012 FLASHBACK VERSIONS Query.mp4

04:57

01 – Course Introduction

09 – Materialized Views

08 – Managing Views

001 What is a View and Why Is It Used For.mp4

03:03
002 Types Of Views.mp4

01:58
003 Creating Simple Views.mp4

12:25
004 Creating Complex Views.mp4

04:35
005 Modifying Views.mp4

03:37
006 Analyzing User Views.mp4

03:20
007 Performing DML Operations with Views.mp4

06:51
008 Using WITH CHECK OPTION Clause.mp4

11:06
009 Preventing DML Operations on A View.mp4

02:22
010 Dropping Views.mp4

02:14

07 – Understanding Indexes

06 – Creating, Using and Analyzing Synonyms

05 – Creating, Using and Managing Sequences

04 – Data Dictionary Views

001 What Are Data Dictionary Views.mp4

01:15
002 What Is There In Data Dictionary Views.mp4

01:12
003 Dictionary Table.mp4

03:18
004 Differences Between USER ALL DBA V$ Prefixes.mp4

01:30
005 USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS Views.mp4

09:13
006 USER_TABLES View.mp4

05:11
007 USER_TAB_COLUMNS View.mp4

05:04
008 User Constraints View.mp4

09:47
009 USER_CONS_COLUMNS View.mp4

05:28
010 USER_TAB_COMMENTS & USER_COL_COMMENTS Views.mp4

03:42

03 – Introducing Database Objects

02 – Software Installation

001 About the Database Installation.mp4

03:01
002 The Ways to Get a Database.mp4

14:49
003 Option 1 Installing VMware and VirtualBox on Windows.mp4

07:33
006 Option 1 Downloading Virtual Machine Image(If the previous lecture didn’t work).mp4

04:11
007 Option 1 Configuring the VMware Virtualization Software.mp4

08:18
008 Option 1 Configuring the Oracle VirtualBox Virtualization Software.mp4

06:45
009 Option 1 Configuring SQL Developer inside of the Virtual Machine.mp4

13:02
011 What is Pluggable Database (Multitenant Architecture).mp4

03:13
012 Option 2 Downloading And Installing the Oracle Database.mp4

18:18
013 Option 2 Unlocking the HR Schema.mp4

07:34
014 Option 2 Configuring and Using the SQL Developer.mp4

22:14
015 Option 2 Installing Sample Schemas in Oracle Database.mp4

07:44
017 Option 3 Using Oracle Live SQL.mp4

07:40
019 The Sample (HR) Schema Used in This Course.mp4

07:23

Student Ratings & Reviews

No Review Yet

About Course

Course Content

10 – Using Advanced Subqueries

001 Using Subqueries as a Source.mp4

002 Scalar Subqueries.mp4

003 Multiple Column Subqueries.mp4

004 Correlated Subqueries.mp4

005 EXISTS Operator.mp4

006 NOT EXISTS Operator.mp4

007 Using WITH Clause.mp4

008 Using Recursive WITH Clause.mp4

009 Inserting Data By Using a Subquery as a Target.mp4

010 Manipulating Data by Using WITH CHECK OPTION Keyword.mp4

011 Correlated Update.mp4

012 Correlated Delete.mp4

18 – Appendix + Conclusion

001 Appendix 1 Oracle Database 12c Installation into Your Computer.mp4

003 Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c.mp4

17 – SQL Analytic Functions

001 What are the Analytic Functions.mp4

002 ROW_NUMBER Analytic Function.mp4

003 RANK and DENSE_RANK Analytic Functions.mp4

004 LEAD & LAG Analytic Functions (Next & Previous Values).mp4

005 Windowing Clause in Analytic Functions – Part 1.mp4

006 Windowing Clause in Analytic Functions – Part 2.mp4

007 INTERVAL Keyword In Analytic Functions.mp4

008 FIRST_VALUE and LAST_VALUE Analytic Functions.mp4

009 Selecting Top-N Rows with Analytic Functions.mp4

16 – Regular Expressions

001 What is Regular Expressions and Why and Where Do We Use Them.mp4

002 What Are Metacharacters.mp4

003 Regular Expression Functions.mp4

004 Using REGEXP_LIKE() function.mp4

005 Using REGEXP_REPLACE() Function.mp4

006 Using REGEXP_SUBSTR() Function.mp4

007 Using REGEXP_INSTR() Function.mp4

008 Using REGEXP_COUNT() Function.mp4

009 Using REGEX in Constraints.mp4

15 – Generating Dynamic SQL Scripts

001 Generating Scripts By Using Data Dictionary Views.mp4

14 – Hierarchical Queries (Tree Structure)

001 Understanding Hierarchical Retrieval.mp4

002 Generating Hierarchical Queries.mp4

003 Walking On The Tree (Bottom to Up – Up to Down).mp4

004 Ranking Rows (Using LEVEL Pseudocolumn).mp4

005 Formatting Tree Structure (LEVEL & LPAD).mp4

006 Pruning Branches Of a Tree.mp4

13 – Administering User Privileges and Roles

001 What Are Privileges And Why Are They Used For.mp4

002 Creating A User.mp4

003 System Privileges.mp4

004 Granting System Privileges.mp4

005 What is A Role and Why is It Used For.mp4

006 Changing The User Password.mp4

007 Object Privileges.mp4

008 Granting Object Privileges.mp4

009 Revoking Object Privileges.mp4

010 Searching For Privileges in Data Dictionary Views.mp4

12 – Constraints (Controlling Schema Objects)

001 Adding Constraints.mp4

002 Removing Constraints.mp4

003 On Delete CASCADE & On Delete SET NULL.mp4

004 Cascading Constraints.mp4

005 Renaming Constraints.mp4

006 Disabling Constraints.mp4

007 Enabling Constraints.mp4

008 Status Of Constraints.mp4

009 Deferring Constraints.mp4

010 Creating Temporary Tables.mp4

11 – Advanced Data Manipulations

001 Using DEFAULT Keyword on Insert And Update Statements.mp4

002 Multitable Insert Statements.mp4

003 Unconditional Insert Statements.mp4

004 Conditional Insert Statements.mp4

005 Conditional Insert First Statements.mp4

006 Pivoting Insert.mp4

007 Merging Data.mp4

008 Flashback Operations.mp4

009 Purge Operations.mp4

010 Tracking Changes In Data In a Particular Time.mp4