Exclusive SALE Offer Today

SQL From Intermediate to Advanced Level

Best Seller 119 Lectures 11h 3m 47s
Prepare for your Microsoft examination with our training course. The No_code course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft No_code test with flying colors.
$13.99$24.99
Curriculum For This Course
  • 1. Introducing Database Objects and Reaching Another User's Objects 9m 34s
  • 2. Reaching Another User's Objects 6m 21s
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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. Generating Scripts By Using Data Dictionary Views 6m 4s
  • 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
  • 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

How to Open Test Engine .dumpsarena Files

Use FREE DumpsArena Test Engine player to open .dumpsarena files

DumpsArena Test Engine

Windows

Refund Policy
Refund Policy

DumpsArena.com has a remarkable success record. We're confident of our products and provide a no hassle refund policy.

How our refund policy works?

safe checkout

Your purchase with DumpsArena.com is safe and fast.

The DumpsArena.com website is protected by 256-bit SSL from Cloudflare, the leader in online security.

Need Help Assistance?

Customer Support