Course Content
10 – Using Advanced Subqueries
0/12
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
0/2
001 Appendix 1 Oracle Database 12c Installation into Your Computer.mp4
08:58
003 Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c.mp4
09:53
17 – SQL Analytic Functions
0/9
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
0/9
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
0/1
001 Generating Scripts By Using Data Dictionary Views.mp4
06:07
14 – Hierarchical Queries (Tree Structure)
0/6
001 Understanding Hierarchical Retrieval.mp4
02:48
002 Generating Hierarchical Queries.mp4
03:12
003 Walking On The Tree (Bottom to Up – Up to Down).mp4
07:12
004 Ranking Rows (Using LEVEL Pseudocolumn).mp4
04:06
005 Formatting Tree Structure (LEVEL & LPAD).mp4
03:59
006 Pruning Branches Of a Tree.mp4
03:51
13 – Administering User Privileges and Roles
0/10
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)
0/10
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
0/12
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
0/2
001 Introduction.mp4
01:23
002 UDEMY 101 How to Use Udemy +Some Useful Tips.mp4
05:01
09 – Materialized Views
0/7
001 What is a Materialized View and Why is it Used For.mp4
05:12
002 Creating Materialized Views Part 1.mp4
06:32
003 Creating Materialized Views Part 2.mp4
04:54
004 Complex Materialized Views.mp4
03:49
005 Types of Refreshing Materialized Views.mp4
10:02
006 Refreshing Materialized Views Manually.mp4
10:39
007 Scheduling Periodic Refresh of Materialized Views.mp4
01:48
08 – Managing Views
0/10
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
0/8
001 What is an Index and Why is It Used For.mp4
02:43
002 Types of Indexes.mp4
02:32
003 Creating Indexes.mp4
08:02
004 Creating Index on Table Creation.mp4
07:43
005 Function Based Indexes.mp4
04:52
006 Multiple Indexes With Same Columns.mp4
09:04
007 Dropping Indexes.mp4
02:51
008 USER_INDEXES and USER_IND_COLUMNS Views.mp4
04:03
06 – Creating, Using and Analyzing Synonyms
0/4
001 What Is a Synonym and Why Is It Used For.mp4
02:32
002 Creating & Dropping Synonyms.mp4
07:03
003 Using Synonyms.mp4
02:34
004 Analyzing USER_SYNONYMS.mp4
03:43
05 – Creating, Using and Managing Sequences
0/8
001 What is a Sequence and Why is It Used For.mp4
01:27
002 Creating Sequences.mp4
06:42
003 Modifying Sequences.mp4
02:47
004 Dropping Sequences.mp4
01:23
005 Using Sequences.mp4
09:08
006 Using Sequences As a Default Value.mp4
04:30
007 Sequence Caching.mp4
02:28
008 User Sequences.mp4
02:29
04 – Data Dictionary Views
0/10
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
0/2
001 Introducing Database Objects and Reaching Another User’s Objects.mp4
09:37
002 Reaching Another User’s Objects.mp4
06:20
02 – Software Installation
0/14
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
[Last updated 4/2024] Advanced SQL : The Ultimate Guide (2024) (Udemy – Vietsub and Engsub)
Previous
Next
0% Complete