SQL From Intermediate to Advanced Level
What’s included
$14.99 / $24.99
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.
Pay once, own it forever
Video Courses
Software Installation
| Lectures | Duration |
|---|---|
| 1. Having The Database with Oracle VirtualBox | 16m 29s |
1. Having The Database with Oracle VirtualBox
16m 29s
Introducing Database Objects
| Lectures | Duration |
|---|---|
| 1. Introducing Database Objects and Reaching Another User's Objects | 9m 34s |
| 2. Reaching Another User's Objects | 6m 21s |
1. Introducing Database Objects and Reaching Another User's Objects
9m 34s
2. Reaching Another User's Objects
6m 21s
Data Dictionary Views
| Lectures | Duration |
|---|---|
| 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 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
Creating, Using and Managing Sequences
| Lectures | Duration |
|---|---|
| 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 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
Creating, Using and Analyzing Synonyms
| Lectures | Duration |
|---|---|
| 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 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
Understanding Indexes
| Lectures | Duration |
|---|---|
| 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 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
Managing Views
| Lectures | Duration |
|---|---|
| 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 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
Materialized Views
| Lectures | Duration |
|---|---|
| 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. 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
Using Advanced Subqueries
| Lectures | Duration |
|---|---|
| 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 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
Advanced Data Manipulations
| Lectures | Duration |
|---|---|
| 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. 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
Constraints (Controlling Schema Objects)
| Lectures | Duration |
|---|---|
| 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. 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
Administering User Privileges and Roles
| Lectures | Duration |
|---|---|
| 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. 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
Hierarchical Queries (Tree Structure)
| Lectures | Duration |
|---|---|
| 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. 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
Generating Dynamic SQL Scripts
| Lectures | Duration |
|---|---|
| 1. Generating Scripts By Using Data Dictionary Views | 6m 4s |
1. Generating Scripts By Using Data Dictionary Views
6m 4s
Regular Expressions
| Lectures | Duration |
|---|---|
| 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 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
Analytical SQL Functions (New Videos: Sep, 2017)
| Lectures | Duration |
|---|---|
| 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 |
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