Udemy - Advanced SQL The Ultimate Guide (2025) (8.2025)

Creation Time	Sept. 9, 2025, 5:54 p.m.
Last Access Time	Sept. 14, 2025, 6:45 p.m.
File Size	3.6 GB
Keywords	- Udemy 2025 Ultimate SQL 8 The Guide Advanced
Total Requests	15
Total Files	325
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

02. Software Installation/12. Option 2 Downloading And Installing the Oracle Database.mp4 191.5 MB
02. Software Installation/14. Option 2 Configuring and Using the SQL Developer.mp4 136.9 MB
04. Data Dictionary Views/8. User Constraints View.mp4 89.7 MB
02. Software Installation/15. Option 2 Installing Sample Schemas in Oracle Database.mp4 89.6 MB
11. Advanced Data Manipulations/8. Flashback Operations.mp4 89.2 MB
02. Software Installation/3. Option 1 Installing VMware and VirtualBox on Windows.mp4 85.5 MB
08. Managing Views/8. Using WITH CHECK OPTION Clause.mp4 84.9 MB
12. Constraints (Controlling Schema Objects)/9. Deferring Constraints.mp4 82.2 MB
02. Software Installation/7. Option 1 Configuring the VMware Virtualization Software.mp4 71.7 MB
13. Administering User Privileges and Roles/8. Granting Object Privileges.mp4 70.5 MB
08. Managing Views/3. Creating Simple Views.mp4 70.0 MB
09. Materialized Views/6. Refreshing Materialized Views Manually.mp4 69.1 MB
02. Software Installation/2. The Ways to Get a Database.mp4 66.7 MB
09. Materialized Views/5. Types of Refreshing Materialized Views.mp4 58.8 MB
16. Regular Expressions/2. What Are Metacharacters.mp4 54.7 MB
04. Data Dictionary Views/6. USER_TABLES View.mp4 50.5 MB
17. SQL Analytic Functions/1. What are the Analytic Functions.mp4 50.5 MB
02. Software Installation/1. About the Database Installation.mp4 50.0 MB
11. Advanced Data Manipulations/7. Merging Data.mp4 48.6 MB
02. Software Installation/8. Option 1 Configuring the Oracle VirtualBox Virtualization Software.mp4 46.2 MB
02. Software Installation/19. The Sample (HR) Schema Used in This Course.mp4 45.2 MB
18. Appendix + Conclusion/1. Appendix 1 Oracle Database 12c Installation into Your Computer.mp4 43.5 MB
02. Software Installation/9. Option 1 Configuring SQL Developer inside of the Virtual Machine.mp4 42.8 MB
10. Using Advanced Subqueries/3. Multiple Column Subqueries.mp4 41.1 MB
07. Understanding Indexes/8. USER_INDEXES and USER_IND_COLUMNS Views.mp4 41.0 MB
06. Creating, Using and Analyzing Synonyms/2. Creating & Dropping Synonyms.mp4 37.0 MB
10. Using Advanced Subqueries/10. Manipulating Data by Using WITH CHECK OPTION Keyword.mp4 36.6 MB
04. Data Dictionary Views/5. USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS Views.mp4 36.0 MB
03. Introducing Database Objects/1. Introducing Database Objects and Reaching Another User's Objects.mp4 35.3 MB
02. Software Installation/6. Option 1 Downloading Virtual Machine Image(If the previous lecture didn't work).mp4 35.2 MB
13. Administering User Privileges and Roles/10. Searching For Privileges in Data Dictionary Views.mp4 34.4 MB
18. Appendix + Conclusion/3. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c.mp4 34.0 MB
10. Using Advanced Subqueries/2. Scalar Subqueries.mp4 33.9 MB
11. Advanced Data Manipulations/3. Unconditional Insert Statements.mp4 33.3 MB
05. Creating, Using and Managing Sequences/2. Creating Sequences.mp4 32.9 MB
11. Advanced Data Manipulations/11. FLASHBACK Query.mp4 32.1 MB
12. Constraints (Controlling Schema Objects)/10. Creating Temporary Tables.mp4 31.8 MB
12. Constraints (Controlling Schema Objects)/3. On Delete CASCADE & On Delete SET NULL.mp4 30.6 MB
17. SQL Analytic Functions/5. Windowing Clause in Analytic Functions - Part 1.mp4 30.4 MB
04. Data Dictionary Views/9. USER_CONS_COLUMNS View.mp4 29.9 MB
10. Using Advanced Subqueries/11. Correlated Update.mp4 29.0 MB
14. Hierarchical Queries (Tree Structure)/6. Pruning Branches Of a Tree.mp4 28.7 MB
11. Advanced Data Manipulations/4. Conditional Insert Statements.mp4 26.4 MB
16. Regular Expressions/8. Using REGEXP_COUNT() Function.mp4 26.4 MB
17. SQL Analytic Functions/4. LEAD & LAG Analytic Functions (Next & Previous Values).mp4 25.8 MB
07. Understanding Indexes/6. Multiple Indexes With Same Columns.mp4 25.7 MB
12. Constraints (Controlling Schema Objects)/4. Cascading Constraints.mp4 25.5 MB
02. Software Installation/11. What is Pluggable Database (Multitenant Architecture).mp4 24.9 MB
09. Materialized Views/2. Creating Materialized Views Part 1.mp4 24.7 MB
10. Using Advanced Subqueries/9. Inserting Data By Using a Subquery as a Target.mp4 24.2 MB
17. SQL Analytic Functions/6. Windowing Clause in Analytic Functions - Part 2.mp4 24.0 MB
05. Creating, Using and Managing Sequences/6. Using Sequences As a Default Value.mp4 23.8 MB
13. Administering User Privileges and Roles/5. What is A Role and Why is It Used For.mp4 23.6 MB
16. Regular Expressions/5. Using REGEXP_REPLACE() Function.mp4 23.3 MB
07. Understanding Indexes/4. Creating Index on Table Creation.mp4 23.0 MB
03. Introducing Database Objects/2. Reaching Another User's Objects.mp4 22.6 MB
14. Hierarchical Queries (Tree Structure)/3. Walking On The Tree (Bottom to Up - Up to Down).mp4 22.3 MB
15. Generating Dynamic SQL Scripts/1. Generating Scripts By Using Data Dictionary Views.mp4 22.1 MB
10. Using Advanced Subqueries/7. Using WITH Clause.mp4 21.8 MB
08. Managing Views/7. Performing DML Operations with Views.mp4 21.3 MB
13. Administering User Privileges and Roles/4. Granting System Privileges.mp4 21.3 MB
10. Using Advanced Subqueries/1. Using Subqueries as a Source.mp4 21.0 MB
08. Managing Views/6. Analyzing User Views.mp4 20.7 MB
14. Hierarchical Queries (Tree Structure)/2. Generating Hierarchical Queries.mp4 19.6 MB
09. Materialized Views/1. What is a Materialized View and Why is it Used For.mp4 19.6 MB
11. Advanced Data Manipulations/1. Using DEFAULT Keyword on Insert And Update Statements.mp4 19.3 MB
11. Advanced Data Manipulations/12. FLASHBACK VERSIONS Query.mp4 19.0 MB
04. Data Dictionary Views/7. USER_TAB_COLUMNS View.mp4 19.0 MB
02. Software Installation/17. Option 3 Using Oracle Live SQL.mp4 18.8 MB
17. SQL Analytic Functions/2. ROW_NUMBER Analytic Function.mp4 18.7 MB
17. SQL Analytic Functions/8. FIRST_VALUE and LAST_VALUE Analytic Functions.mp4 18.7 MB
16. Regular Expressions/7. Using REGEXP_INSTR() Function.mp4 18.6 MB
11. Advanced Data Manipulations/5. Conditional Insert First Statements.mp4 18.2 MB
12. Constraints (Controlling Schema Objects)/1. Adding Constraints.mp4 17.5 MB
13. Administering User Privileges and Roles/6. Changing The User Password.mp4 17.1 MB
02. Software Installation/13. Option 2 Unlocking the HR Schema.mp4 17.0 MB
10. Using Advanced Subqueries/8. Using Recursive WITH Clause.mp4 17.0 MB
10. Using Advanced Subqueries/5. EXISTS Operator.mp4 16.8 MB
05. Creating, Using and Managing Sequences/5. Using Sequences.mp4 16.7 MB
07. Understanding Indexes/3. Creating Indexes.mp4 16.1 MB
16. Regular Expressions/6. Using REGEXP_SUBSTR() Function.mp4 15.8 MB
10. Using Advanced Subqueries/6. NOT EXISTS Operator.mp4 15.7 MB
04. Data Dictionary Views/10. USER_TAB_COMMENTS & USER_COL_COMMENTS Views.mp4 15.0 MB
05. Creating, Using and Managing Sequences/8. User Sequences.mp4 14.5 MB
14. Hierarchical Queries (Tree Structure)/4. Ranking Rows (Using LEVEL Pseudocolumn).mp4 14.4 MB
02. Software Installation/15. sample_schemas.zip 14.0 MB
13. Administering User Privileges and Roles/2. Creating A User.mp4 13.6 MB
13. Administering User Privileges and Roles/9. Revoking Object Privileges.mp4 13.2 MB
04. Data Dictionary Views/3. Dictionary Table.mp4 13.2 MB
17. SQL Analytic Functions/3. RANK and DENSE_RANK Analytic Functions.mp4 13.1 MB
17. SQL Analytic Functions/7. INTERVAL Keyword In Analytic Functions.mp4 13.0 MB
11. Advanced Data Manipulations/6. Pivoting Insert.mp4 12.7 MB
10. Using Advanced Subqueries/4. Correlated Subqueries.mp4 12.7 MB
12. Constraints (Controlling Schema Objects)/6. Disabling Constraints.mp4 12.5 MB
06. Creating, Using and Analyzing Synonyms/3. Using Synonyms.mp4 12.5 MB
14. Hierarchical Queries (Tree Structure)/5. Formatting Tree Structure (LEVEL & LPAD).mp4 12.2 MB
16. Regular Expressions/4. Using REGEXP_LIKE() function.mp4 12.1 MB
09. Materialized Views/3. Creating Materialized Views Part 2.mp4 11.8 MB
06. Creating, Using and Analyzing Synonyms/4. Analyzing USER_SYNONYMS.mp4 11.7 MB
11. Advanced Data Manipulations/9. Purge Operations.mp4 11.3 MB
10. Using Advanced Subqueries/12. Correlated Delete.mp4 11.1 MB
09. Materialized Views/4. Complex Materialized Views.mp4 11.0 MB
07. Understanding Indexes/5. Function Based Indexes.mp4 10.7 MB
16. Regular Expressions/9. Using REGEX in Constraints.mp4 10.7 MB
13. Administering User Privileges and Roles/3. System Privileges.mp4 10.5 MB
08. Managing Views/9. Preventing DML Operations on A View.mp4 10.4 MB
14. Hierarchical Queries (Tree Structure)/1. Understanding Hierarchical Retrieval.mp4 9.9 MB
01. Course Introduction/2. UDEMY 101 How to Use Udemy +Some Useful Tips.mp4 9.8 MB
07. Understanding Indexes/7. Dropping Indexes.mp4 9.7 MB
08. Managing Views/4. Creating Complex Views.mp4 9.7 MB
16. Regular Expressions/3. Regular Expression Functions.mp4 9.5 MB
12. Constraints (Controlling Schema Objects)/2. Removing Constraints.mp4 9.4 MB
05. Creating, Using and Managing Sequences/3. Modifying Sequences.mp4 9.1 MB
12. Constraints (Controlling Schema Objects)/8. Status Of Constraints.mp4 8.4 MB
08. Managing Views/5. Modifying Views.mp4 8.4 MB
08. Managing Views/1. What is a View and Why Is It Used For.mp4 8.3 MB
17. SQL Analytic Functions/9. Selecting Top-N Rows with Analytic Functions.mp4 8.1 MB
13. Administering User Privileges and Roles/1. What Are Privileges And Why Are They Used For.mp4 7.8 MB
12. Constraints (Controlling Schema Objects)/5. Renaming Constraints.mp4 7.7 MB
07. Understanding Indexes/1. What is an Index and Why is It Used For.mp4 7.6 MB
07. Understanding Indexes/2. Types of Indexes.mp4 7.0 MB
12. Constraints (Controlling Schema Objects)/7. Enabling Constraints.mp4 7.0 MB
08. Managing Views/2. Types Of Views.mp4 6.9 MB
16. Regular Expressions/1. What is Regular Expressions and Why and Where Do We Use Them.mp4 6.9 MB
06. Creating, Using and Analyzing Synonyms/1. What Is a Synonym and Why Is It Used For.mp4 6.7 MB
05. Creating, Using and Managing Sequences/7. Sequence Caching.mp4 6.6 MB
08. Managing Views/10. Dropping Views.mp4 5.5 MB
13. Administering User Privileges and Roles/7. Object Privileges.mp4 5.4 MB
09. Materialized Views/7. Scheduling Periodic Refresh of Materialized Views.mp4 4.4 MB
04. Data Dictionary Views/4. Differences Between USER, ALL, DBA, V$ Prefixes.mp4 4.1 MB
11. Advanced Data Manipulations/10. Tracking Changes In Data In a Particular Time.mp4 4.0 MB
01. Course Introduction/1. Introduction.mp4 3.9 MB
05. Creating, Using and Managing Sequences/1. What is a Sequence and Why is It Used For.mp4 3.9 MB
11. Advanced Data Manipulations/2. Multitable Insert Statements.mp4 3.6 MB
04. Data Dictionary Views/1. What Are Data Dictionary Views.mp4 3.3 MB
05. Creating, Using and Managing Sequences/4. Dropping Sequences.mp4 3.2 MB
04. Data Dictionary Views/2. What Is There In Data Dictionary Views.mp4 3.0 MB
02. Software Installation/3. How to Download the VMware Workstation Player.pdf 1.2 MB
16. Regular Expressions/2. Metacharacters Chart.pdf 745.4 KB
18. Appendix + Conclusion/2. 2019-11-13_08-30-27-6394965f16e448587bb6f8c7eec9bf39.gif 717.4 KB
18. Appendix + Conclusion/5. 2025-01-06_06-33-00-639ed9f204ba29dcfe0479d691f29353.png 317.8 KB
18. Appendix + Conclusion/4. 2021-07-28_12-31-00-c1f25cee46bc8defab09a5876ff965a0.png 279.9 KB
02. Software Installation/13. (Oracle Master Training) - Scripts to Unlock the HR Schema.pdf 230.8 KB
18. Appendix + Conclusion/5. 2021-02-08_05-26-31-2e72db21d261e8726c8d5d44763c56d1.png 210.1 KB
18. Appendix + Conclusion/5. 2021-02-08_05-27-03-21d34b275ff47d0ae36084e8aabbb3f6.png 191.4 KB
02. Software Installation/4. 2017-12-03_13-44-25-8859411b7fb86c134aa15ae39f4cb5a9.png 160.3 KB
02. Software Installation/4. 2017-12-03_13-34-04-e95c88dbb546e552490f3653d20dcb3a.png 154.3 KB
18. Appendix + Conclusion/5. 2021-02-08_05-26-22-5dc5a8d95f3ad901892b68efd9e76815.png 152.3 KB
18. Appendix + Conclusion/5. 2021-02-08_05-26-49-ca812fa36a67a5f39ec40be63f4954f4.png 129.9 KB
02. Software Installation/4. 2017-12-03_13-42-50-16decad85c37f1cae284460426c8a3c3.png 129.0 KB
18. Appendix + Conclusion/5. 2021-02-08_05-27-14-9b9b06c3e9ba47e0d012e974f2e46845.png 99.3 KB
02. Software Installation/16. HR+Schema+Create+Code.sql 70.3 KB
02. Software Installation/16. Option 2 HR Schema Create Code (if you could not get the HR user in other ways).html 69.8 KB
02. Software Installation/5. 2023-04-10_12-31-29-338dfd5a9e5f1b134fa958c9a1ec41ab.PNG 68.3 KB
02. Software Installation/4. 2017-12-03_13-46-24-cf7e6597e72ddae0f897ffdcefd298c2.png 60.8 KB
03. Introducing Database Objects/4. students-review.png 57.8 KB
02. Software Installation/4. 2017-12-03_13-36-14-f70f97e08418ab4676b425b0cb65dc86.png 41.5 KB
12. Constraints (Controlling Schema Objects)/11.10 Quiz 10.html 27.6 KB
07. Understanding Indexes/9.5 Quiz 5.html 26.3 KB
04. Data Dictionary Views/11.2 Quiz 2.html 26.1 KB
11. Advanced Data Manipulations/13.9 Quiz 9.html 25.7 KB
08. Managing Views/11.6 Quiz 6.html 25.6 KB
05. Creating, Using and Managing Sequences/9.3 Quiz 3.html 24.1 KB
10. Using Advanced Subqueries/13.8 Quiz 8.html 23.8 KB
09. Materialized Views/8.7 Quiz 7.html 23.7 KB
13. Administering User Privileges and Roles/11.11 Quiz 11.html 23.4 KB
18. Appendix + Conclusion/4. 2021-07-28_12-33-55-bd9091405377882a86141d063ae8a8c7.png 22.8 KB
02. Software Installation/14. Option 2 Configuring and Using the SQL Developer.vtt 22.6 KB
03. Introducing Database Objects/5. Code Samples.html 22.6 KB
06. Creating, Using and Analyzing Synonyms/5.4 Quiz 4.html 21.2 KB
03. Introducing Database Objects/6.1 Quiz 1.html 20.8 KB
18. Appendix + Conclusion/4. 2021-07-28_12-32-49-bf8f77c403ae854d0a92712895813d85.png 19.8 KB
14. Hierarchical Queries (Tree Structure)/7.12 Quiz 12.html 18.9 KB
02. Software Installation/12. Option 2 Downloading And Installing the Oracle Database.vtt 18.6 KB
18. Appendix + Conclusion/4. 2021-07-28_12-33-19-133b255e9ab9947014826c0288246c5d.png 17.8 KB
02. Software Installation/2. The Ways to Get a Database.vtt 17.4 KB
08. Managing Views/8. Using WITH CHECK OPTION Clause.vtt 15.2 KB
08. Managing Views/3. Creating Simple Views.vtt 14.5 KB
16. Regular Expressions/2. What Are Metacharacters.vtt 13.9 KB
02. Software Installation/9. Option 1 Configuring SQL Developer inside of the Virtual Machine.vtt 13.8 KB
04. Data Dictionary Views/5. USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS Views.vtt 12.7 KB
10. Using Advanced Subqueries/2. Scalar Subqueries.vtt 11.6 KB
07. Understanding Indexes/6. Multiple Indexes With Same Columns.vtt 10.8 KB
17. SQL Analytic Functions/1. What are the Analytic Functions.vtt 10.4 KB
03. Introducing Database Objects/1. Introducing Database Objects and Reaching Another User's Objects.vtt 10.3 KB
11. Advanced Data Manipulations/8. Flashback Operations.vtt 10.1 KB
04. Data Dictionary Views/8. User Constraints View.vtt 10.0 KB
18. Appendix + Conclusion/3. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c.vtt 9.6 KB
06. Creating, Using and Analyzing Synonyms/2. Creating & Dropping Synonyms.vtt 9.6 KB
18. Appendix + Conclusion/1. Appendix 1 Oracle Database 12c Installation into Your Computer.vtt 9.4 KB
13. Administering User Privileges and Roles/8. Granting Object Privileges.vtt 9.2 KB
17. SQL Analytic Functions/5. Windowing Clause in Analytic Functions - Part 1.vtt 9.2 KB
16. Regular Expressions/5. Using REGEXP_REPLACE() Function.vtt 9.1 KB
09. Materialized Views/5. Types of Refreshing Materialized Views.vtt 9.0 KB
12. Constraints (Controlling Schema Objects)/9. Deferring Constraints.vtt 8.9 KB
10. Using Advanced Subqueries/5. EXISTS Operator.vtt 8.5 KB
02. Software Installation/7. Option 1 Configuring the VMware Virtualization Software.vtt 8.3 KB
02. Software Installation/15. Option 2 Installing Sample Schemas in Oracle Database.vtt 8.2 KB
02. Software Installation/13. Option 2 Unlocking the HR Schema.vtt 8.1 KB
03. Introducing Database Objects/2. Reaching Another User's Objects.vtt 8.0 KB
07. Understanding Indexes/5. Function Based Indexes.vtt 7.9 KB
16. Regular Expressions/6. Using REGEXP_SUBSTR() Function.vtt 7.9 KB
02. Software Installation/19. The Sample (HR) Schema Used in This Course.vtt 7.9 KB
08. Managing Views/7. Performing DML Operations with Views.vtt 7.8 KB
05. Creating, Using and Managing Sequences/5. Using Sequences.vtt 7.7 KB
17. SQL Analytic Functions/6. Windowing Clause in Analytic Functions - Part 2.vtt 7.7 KB
11. Advanced Data Manipulations/7. Merging Data.vtt 7.5 KB
02. Software Installation/17. Option 3 Using Oracle Live SQL.vtt 7.5 KB
09. Materialized Views/6. Refreshing Materialized Views Manually.vtt 7.4 KB
11. Advanced Data Manipulations/4. Conditional Insert Statements.vtt 7.3 KB
02. Software Installation/3. Option 1 Installing VMware and VirtualBox on Windows.vtt 7.2 KB
02. Software Installation/8. Option 1 Configuring the Oracle VirtualBox Virtualization Software.vtt 7.1 KB
12. Constraints (Controlling Schema Objects)/1. Adding Constraints.vtt 7.0 KB
12. Constraints (Controlling Schema Objects)/3. On Delete CASCADE & On Delete SET NULL.vtt 6.8 KB
17. SQL Analytic Functions/4. LEAD & LAG Analytic Functions (Next & Previous Values).vtt 6.8 KB
04. Data Dictionary Views/7. USER_TAB_COLUMNS View.vtt 6.7 KB
12. Constraints (Controlling Schema Objects)/10. Creating Temporary Tables.vtt 6.7 KB
14. Hierarchical Queries (Tree Structure)/3. Walking On The Tree (Bottom to Up - Up to Down).vtt 6.4 KB
05. Creating, Using and Managing Sequences/2. Creating Sequences.vtt 6.4 KB
07. Understanding Indexes/3. Creating Indexes.vtt 6.4 KB
10. Using Advanced Subqueries/1. Using Subqueries as a Source.vtt 6.3 KB
09. Materialized Views/2. Creating Materialized Views Part 1.vtt 6.3 KB
10. Using Advanced Subqueries/3. Multiple Column Subqueries.vtt 6.2 KB
05. Creating, Using and Managing Sequences/6. Using Sequences As a Default Value.vtt 6.0 KB
10. Using Advanced Subqueries/10. Manipulating Data by Using WITH CHECK OPTION Keyword.vtt 6.0 KB
06. Creating, Using and Analyzing Synonyms/4. Analyzing USER_SYNONYMS.vtt 6.0 KB
06. Creating, Using and Analyzing Synonyms/1. What Is a Synonym and Why Is It Used For.vtt 5.9 KB
13. Administering User Privileges and Roles/4. Granting System Privileges.vtt 5.9 KB
07. Understanding Indexes/8. USER_INDEXES and USER_IND_COLUMNS Views.vtt 5.9 KB
10. Using Advanced Subqueries/9. Inserting Data By Using a Subquery as a Target.vtt 5.9 KB
17. SQL Analytic Functions/8. FIRST_VALUE and LAST_VALUE Analytic Functions.vtt 5.7 KB
16. Regular Expressions/7. Using REGEXP_INSTR() Function.vtt 5.7 KB
04. Data Dictionary Views/6. USER_TABLES View.vtt 5.6 KB
09. Materialized Views/1. What is a Materialized View and Why is it Used For.vtt 5.4 KB
01. Course Introduction/2. UDEMY 101 How to Use Udemy +Some Useful Tips.vtt 5.4 KB
06. Creating, Using and Analyzing Synonyms/3. Using Synonyms.vtt 5.3 KB
11. Advanced Data Manipulations/1. Using DEFAULT Keyword on Insert And Update Statements.vtt 5.3 KB
11. Advanced Data Manipulations/3. Unconditional Insert Statements.vtt 5.3 KB
07. Understanding Indexes/2. Types of Indexes.vtt 5.3 KB
07. Understanding Indexes/7. Dropping Indexes.vtt 5.2 KB
08. Managing Views/4. Creating Complex Views.vtt 5.1 KB
10. Using Advanced Subqueries/11. Correlated Update.vtt 5.0 KB
11. Advanced Data Manipulations/11. FLASHBACK Query.vtt 5.0 KB
17. SQL Analytic Functions/3. RANK and DENSE_RANK Analytic Functions.vtt 5.0 KB
10. Using Advanced Subqueries/7. Using WITH Clause.vtt 4.9 KB
13. Administering User Privileges and Roles/6. Changing The User Password.vtt 4.9 KB
05. Creating, Using and Managing Sequences/3. Modifying Sequences.vtt 4.9 KB
07. Understanding Indexes/1. What is an Index and Why is It Used For.vtt 4.9 KB
07. Understanding Indexes/4. Creating Index on Table Creation.vtt 4.7 KB
16. Regular Expressions/4. Using REGEXP_LIKE() function.vtt 4.7 KB
04. Data Dictionary Views/10. USER_TAB_COMMENTS & USER_COL_COMMENTS Views.vtt 4.7 KB
05. Creating, Using and Managing Sequences/8. User Sequences.vtt 4.6 KB
02. Software Installation/1. About the Database Installation.vtt 4.6 KB
08. Managing Views/5. Modifying Views.vtt 4.6 KB
09. Materialized Views/3. Creating Materialized Views Part 2.vtt 4.5 KB
11. Advanced Data Manipulations/12. FLASHBACK VERSIONS Query.vtt 4.3 KB
10. Using Advanced Subqueries/6. NOT EXISTS Operator.vtt 4.3 KB
08. Managing Views/9. Preventing DML Operations on A View.vtt 4.3 KB
15. Generating Dynamic SQL Scripts/1. Generating Scripts By Using Data Dictionary Views.vtt 4.2 KB
08. Managing Views/10. Dropping Views.vtt 4.2 KB
08. Managing Views/6. Analyzing User Views.vtt 4.2 KB
11. Advanced Data Manipulations/5. Conditional Insert First Statements.vtt 4.2 KB
02. Software Installation/6. Option 1 Downloading Virtual Machine Image(If the previous lecture didn't work).vtt 4.2 KB
02. Software Installation/4. Option 1 How to Install the Virtual Box on Mac OS X.html 4.2 KB
17. SQL Analytic Functions/9. Selecting Top-N Rows with Analytic Functions.vtt 4.1 KB
17. SQL Analytic Functions/7. INTERVAL Keyword In Analytic Functions.vtt 4.1 KB
13. Administering User Privileges and Roles/5. What is A Role and Why is It Used For.vtt 4.0 KB
04. Data Dictionary Views/3. Dictionary Table.vtt 4.0 KB
08. Managing Views/2. Types Of Views.vtt 4.0 KB
17. SQL Analytic Functions/2. ROW_NUMBER Analytic Function.vtt 3.9 KB
10. Using Advanced Subqueries/4. Correlated Subqueries.vtt 3.9 KB
16. Regular Expressions/9. Using REGEX in Constraints.vtt 3.8 KB
12. Constraints (Controlling Schema Objects)/4. Cascading Constraints.vtt 3.8 KB
11. Advanced Data Manipulations/6. Pivoting Insert.vtt 3.8 KB
10. Using Advanced Subqueries/8. Using Recursive WITH Clause.vtt 3.8 KB
13. Administering User Privileges and Roles/2. Creating A User.vtt 3.7 KB
14. Hierarchical Queries (Tree Structure)/5. Formatting Tree Structure (LEVEL & LPAD).vtt 3.7 KB
12. Constraints (Controlling Schema Objects)/2. Removing Constraints.vtt 3.6 KB
02. Software Installation/11. What is Pluggable Database (Multitenant Architecture).vtt 3.6 KB
16. Regular Expressions/8. Using REGEXP_COUNT() Function.vtt 3.6 KB
04. Data Dictionary Views/9. USER_CONS_COLUMNS View.vtt 3.5 KB
13. Administering User Privileges and Roles/3. System Privileges.vtt 3.4 KB
14. Hierarchical Queries (Tree Structure)/6. Pruning Branches Of a Tree.vtt 3.4 KB
09. Materialized Views/4. Complex Materialized Views.vtt 3.4 KB
14. Hierarchical Queries (Tree Structure)/4. Ranking Rows (Using LEVEL Pseudocolumn).vtt 3.4 KB
11. Advanced Data Manipulations/9. Purge Operations.vtt 3.3 KB
08. Managing Views/1. What is a View and Why Is It Used For.vtt 3.2 KB
18. Appendix + Conclusion/2. Appendix 2 How to Unlock the HR User (Schema) in the Oracle Database 12c.html 3.2 KB
14. Hierarchical Queries (Tree Structure)/2. Generating Hierarchical Queries.vtt 3.1 KB
13. Administering User Privileges and Roles/9. Revoking Object Privileges.vtt 3.1 KB
12. Constraints (Controlling Schema Objects)/6. Disabling Constraints.vtt 3.0 KB
12. Constraints (Controlling Schema Objects)/8. Status Of Constraints.vtt 3.0 KB
04. Data Dictionary Views/2. What Is There In Data Dictionary Views.vtt 2.8 KB
12. Constraints (Controlling Schema Objects)/7. Enabling Constraints.vtt 2.8 KB
14. Hierarchical Queries (Tree Structure)/1. Understanding Hierarchical Retrieval.vtt 2.8 KB
05. Creating, Using and Managing Sequences/1. What is a Sequence and Why is It Used For.vtt 2.7 KB
16. Regular Expressions/3. Regular Expression Functions.vtt 2.7 KB
13. Administering User Privileges and Roles/1. What Are Privileges And Why Are They Used For.vtt 2.6 KB
04. Data Dictionary Views/4. Differences Between USER, ALL, DBA, V$ Prefixes.vtt 2.6 KB
16. Regular Expressions/1. What is Regular Expressions and Why and Where Do We Use Them.vtt 2.6 KB
05. Creating, Using and Managing Sequences/7. Sequence Caching.vtt 2.4 KB
18. Appendix + Conclusion/5. Bonus Lecture.html 2.3 KB
10. Using Advanced Subqueries/12. Correlated Delete.vtt 2.3 KB
12. Constraints (Controlling Schema Objects)/5. Renaming Constraints.vtt 2.3 KB
13. Administering User Privileges and Roles/7. Object Privileges.vtt 2.1 KB
09. Materialized Views/7. Scheduling Periodic Refresh of Materialized Views.vtt 2.0 KB
05. Creating, Using and Managing Sequences/4. Dropping Sequences.vtt 2.0 KB
18. Appendix + Conclusion/4. How to remove the database.html 1.8 KB
02. Software Installation/5. Option 1 Downloading Virtual Machine Image (19c).html 1.7 KB
11. Advanced Data Manipulations/2. Multitable Insert Statements.vtt 1.5 KB
11. Advanced Data Manipulations/10. Tracking Changes In Data In a Particular Time.vtt 1.5 KB
01. Course Introduction/1. Introduction.vtt 1.5 KB
04. Data Dictionary Views/1. What Are Data Dictionary Views.vtt 1.5 KB
02. Software Installation/15. Installation Code.txt 1.3 KB
02. Software Installation/10. Important Note.html 1.2 KB
02. Software Installation/18. Option 3 About Oracle Live SQL Restrictions.html 785 bytes
03. Introducing Database Objects/3. Course Materials.html 692 bytes
03. Introducing Database Objects/4. Don't Forget to Leave a Rating!.html 651 bytes
16. Regular Expressions/9. Email validation sql script.sql 245 bytes
02. Software Installation/3. Download-VMware-Workstation-Player.txt 85 bytes
02. Software Installation/6. Download-Virtual-Machine-Image-19c-.txt 84 bytes
03. Introducing Database Objects/3. Working-Document-Link.txt 61 bytes
13. Administering User Privileges and Roles/10. Searching For Privileges in Data Dictionary Views.vtt 51 bytes
02. Software Installation/3. Download-Oracle-Virtualbox.txt 41 bytes
18. Appendix + Conclusion/1. Oracles-Official-Website.txt 23 bytes

Udemy - Advanced SQL The Ultimate Guide (2025) (8.2025)

File List

Download Torrent

Related Resources

Copyright Infringement