SQL From Intermediate to Advanced Level

Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.

What’s included

  • 119 : Lectures
  • 11h 3m 47s : Duration
video-file-formats

$14.99/24.99

Lectures
1. Having The Database with Oracle VirtualBox- 16m 29s
Lectures
1. Introducing Database Objects and Reaching Another User's Objects- 9m 34s
2. Reaching Another User's Objects- 6m 21s
Lectures
1. What Are Data Dictionary Views?- 1m 15s
2. What Is There In Data Dictionary Views?- 1m 12s
3. Dictionary Table- 3m 18s
4. Differences Between USER, ALL, DBA, V$ Prefixes- 1m 31s
5. USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS Views- 9m 13s
6. USER_TABLES View- 5m 11s
7. USER_TAB_COLUMNS View- 5m 4s
8. User Constraints View- 9m 47s
9. USER_CONS_COLUMNS View- 5m 29s
10. USER_TAB_COMMENTS & USER_COL_COMMENTS Views- 3m 42s
Lectures
1. What is a Sequence and Why is It Used For?- 1m 27s
2. Creating Sequences- 6m 42s
3. Modifying Sequences- 2m 48s
4. Dropping Sequences- 1m 23s
5. Using Sequences- 9m 8s
6. Using Sequences As a Default Value- 4m 30s
7. Sequence Caching- 2m 28s
8. User Sequences- 2m 29s
Lectures
1. What Is a Synonym and Why Is It Used For?- 2m 32s
2. Creating & Dropping Synonyms- 7m 3s
3. Using Synonyms- 2m 34s
4. Analyzing USER_SYNONYMS- 3m 43s
Lectures
1. What is an Index and Why is It Used For?- 2m 43s
2. Types of Indexes- 2m 19s
3. Creating Indexes- 7m 47s
4. Creating Index on Table Creation- 7m 44s
5. Function Based Indexes- 4m 32s
6. Multiple Indexes With Same Columns- 9m 4s
7. Dropping Indexes- 2m 52s
8. USER_INDEXES and USER_IND_COLUMNS Views- 4m 3s
Lectures
1. What is a View and Why Is It Used For?- 2m 52s
2. Types Of Views- 1m 58s
3. Creating Simple Views- 12m 17s
4. Creating Complex Views- 4m 35s
5. Modifying Views- 3m 37s
6. Analyzing User Views- 3m 20s
7. Performing DML Operations with Views- 6m 41s
8. Using WITH CHECK OPTION Clause- 10m 54s
9. Preventing DML Operations on A View- 2m 22s
10. Dropping Views- 2m 2s
Lectures
1. What is a Materialized View and Why is it Used For?- 5m 2s
2. Creating Materialized Views Part 1- 6m 32s
3. Creating Materialized Views Part 2- 4m 54s
4. Complex Materialized Views- 3m 50s
5. Types of Refreshing Materialized Views- 9m 53s
6. Refreshing Materialized Views Manually- 10m 31s
7. Scheduling Periodic Refresh of Materialized Views- 1m 40s
Lectures
1. Using Subqueries as a Source- 5m 40s
2. Scalar Subqueries- 9m 11s
3. Multiple Column Subqueries- 7m 21s
4. Correlated Subqueries- 4m 10s
5. EXISTS Operator- 5m 16s
6. NOT EXISTS Operator- 4m 56s
7. Using WITH Clause- 6m 31s
8. Using Recursive WITH Clause- 5m 33s
9. Inserting Data By Using a Subquery as a Target- 7m 6s
10. Manipulating Data by Using "WITH CHECK OPTION" Keyword- 6m 24s
11. Correlated Delete- 2m 23s
12. Correlated Update- 6m 15s
Lectures
1. Using DEFAULT Keyword on Insert And Update Statements- 5m 45s
2. Multitable Insert Statements- 1m 20s
3. Unconditional Insert Statements- 6m 31s
4. Conditional Insert Statements- 8m 7s
5. Conditional Insert First Statements- 5m 21s
6. Pivoting Insert- 4m 28s
7. Merging Data- 10m 3s
8. Flashback Operations- 11m 6s
9. Purge Operations- 4m 2s
10. Tracking Changes In Data In a Particular Time- 1m 28s
11. FLASHBACK Query- 6m 31s
12. FLASHBACK VERSIONS Query- 4m 57s
Lectures
1. Adding Constraints- 7m 21s
2. Removing Constraints- 3m 51s
3. On Delete CASCADE & On Delete SET NULL- 9m 35s
4. Cascading Constraints- 3m 57s
5. Renaming Constraints- 2m 40s
6. Disabling Constraints- 3m 2s
7. Enabling Constraints- 2m 34s
8. Status Of Constraints- 3m 4s
9. Deferring Constraints- 13m 48s
10. Creating Temporary Tables- 10m 28s
Lectures
1. What Are Privileges And Why Are They Used For?- 2m 46s
2. Creating A User- 3m 55s
3. System Privileges- 3m 58s
4. Granting System Privileges- 7m 7s
5. What is A Role and Why is It Used For?- 4m 28s
6. Changing The User Password- 5m 5s
7. Object Privileges- 2m 2s
8. Granting Object Privileges- 10m 29s
9. Revoking Object Privileges- 3m 13s
10. Searching For Privileges in Data Dictionary Views- 6m 44s
Lectures
1. Understanding Hierarchical Retrieval- 2m 48s
2. Generating Hierarchical Queries- 3m 12s
3. Walking On The Tree (Bottom to Up - Up to Down)- 7m 12s
4. Ranking Rows (Using LEVEL Pseudocolumn)- 4m 6s
5. Formatting Tree Structure (LEVEL & LPAD)- 3m 59s
6. Pruning Branches Of a Tree- 3m 51s
Lectures
1. Generating Scripts By Using Data Dictionary Views- 6m 4s
Lectures
1. What is Regular Expressions and Why and Where Do We Use Them?- 2m 22s
2. What Are Metacharacters?- 13m 37s
3. Regular Expression Functions- 2m 34s
4. Using REGEXP_LIKE() function- 4m 45s
5. Using REGEXP_REPLACE() Function- 10m 18s
6. Using REGEXP_SUBSTR() Function- 8m 34s
7. Using REGEXP_INSTR() Function- 6m 11s
8. Using REGEXP_COUNT() Function- 4m
9. Using REGEX in Constraints- 4m 59s
Lectures
1. What are the Analytic Functions?- 12m 34s
2. ROW_NUMBER Analytic Function- 4m 22s
3. RANK and DENSE_RANK Analytic Functions- 4m 51s
4. LEAD & LAG Analytic Functions (Next & Previous Values)- 8m 13s
5. Windowing Clause in Analytic Functions - Part 1- 10m 56s
6. Windowing Clause in Analytic Functions - Part 2- 9m 16s
7. INTERVAL Keyword In Analytic Functions- 4m 26s
8. FIRST_VALUE and LAST_VALUE Analytic Functions..- 6m 46s
9. Selecting Top-N Rows with Analytic Functions- 4m 22s

PassQueen does not provide real Microsoft exam questions. Similarly, PassQueen does not supply real Amazon exam questions. The materials offered by PassQueen lack real questions and answers of certification exams. The CFA Institute neither endorses nor assures the accuracy or quality of PassQueen content. CFA® and Chartered Financial Analyst® are registered trademarks held by the CFA Institute.

Pages

Other Pages

Helpful Pages

© 2025 All Rights Reserved passqueen.com.