SQL From Intermediate to Advanced Level

SQL From Intermediate to Advanced Level

BEST SELLER 119 Lectures 11h 3m 47s

Prepare for your examination with our training course. The course contains a complete batch of videos that will provide you with profound and thorough knowledge related to certification exam. Pass the test with flying colors.

$13.99 $24.99

Curriculum For This Course

1 lectures 16m 29s
  • 1. Having The Database with Oracle VirtualBox
    16m 29s

2 lectures 15m 55s
  • 1. Introducing Database Objects and Reaching Another User's Objects
    9m 34s
  • 2. Reaching Another User's Objects
    6m 21s

10 lectures 45m 42s
  • 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

8 lectures 30m 55s
  • 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

4 lectures 15m 52s
  • 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

8 lectures 41m 4s
  • 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

10 lectures 50m 38s
  • 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

7 lectures 42m 22s
  • 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

12 lectures 1h 10m 46s
  • 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

12 lectures 1h 9m 39s
  • 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

10 lectures 1h 20s
  • 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

10 lectures 49m 47s
  • 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

6 lectures 25m 8s
  • 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

1 lectures 6m 4s
  • 1. Generating Scripts By Using Data Dictionary Views
    6m 4s

9 lectures 57m 20s
  • 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

9 lectures 1h 5m 46s
  • 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
Hot Exams
VTSimu
VTSimu Exam Simulator
How to open .dumpsarena files

Use Free VTSimu Exam Simulator to open .dumpsarena files

VTSimu Exam Simulator

Windows Mac Learn More
Satisfaction Guaranteed

98.4% DumpsArena users pass

Our team is dedicated to delivering top-quality exam practice questions. We proudly offer a hassle-free satisfaction guarantee.

Why choose DumpsArena?

23,812+

Satisfied Customers Since 2018

  • Always Up-to-Date
  • Accurate and Verified
  • Free Regular Updates
  • 24/7 Customer Support
  • Instant Access to Downloads
Secure Experience

Guaranteed safe checkout.

At DumpsArena, your shopping security is our priority. We utilize high-security SSL encryption, ensuring that every purchase is 100% secure.

SECURED CHECKOUT
Need Help?

Feel free to contact us anytime!

Contact Support