Certification training
119Lectures
11h 3m 47sDuration
Vendor
SQL From Intermediate to Advanced Level
Prepare for your exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.
Best seller
certification training
119 lessons arranged in a guided course path
Course overview
Study with a clear path.
Move through focused sections, review lecture timing, and return directly to the objectives that need more work.
Sequenced lessons
Follow the course in order or jump directly to the section you need to revisit.
Video-first prep
Use concise lecture blocks for technical review before moving into exam practice.
Fast access
Your purchased course becomes available in the member area after confirmed payment.
Curriculum
Course sections.
16 sections, 119 lessons, and lecture-level duration details.
01
Having The Database with Oracle VirtualBox
16m 29s
01
Introducing Database Objects and Reaching Another User's Objects
9m 34s
02
Reaching Another User's Objects
6m 21s
01
What Are Data Dictionary Views?
1m 15s
02
What Is There In Data Dictionary Views?
1m 12s
03
Dictionary Table
3m 18s
04
Differences Between USER, ALL, DBA, V$ Prefixes
1m 31s
05
USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS Views
9m 13s
06
USER_TABLES View
5m 11s
07
USER_TAB_COLUMNS View
5m 4s
08
User Constraints View
9m 47s
09
USER_CONS_COLUMNS View
5m 29s
10
USER_TAB_COMMENTS & USER_COL_COMMENTS Views
3m 42s
01
What is a Sequence and Why is It Used For?
1m 27s
02
Creating Sequences
6m 42s
03
Modifying Sequences
2m 48s
04
Dropping Sequences
1m 23s
05
Using Sequences
9m 8s
06
Using Sequences As a Default Value
4m 30s
07
Sequence Caching
2m 28s
08
User Sequences
2m 29s
01
What Is a Synonym and Why Is It Used For?
2m 32s
02
Creating & Dropping Synonyms
7m 3s
03
Using Synonyms
2m 34s
04
Analyzing USER_SYNONYMS
3m 43s
01
What is an Index and Why is It Used For?
2m 43s
02
Types of Indexes
2m 19s
03
Creating Indexes
7m 47s
04
Creating Index on Table Creation
7m 44s
05
Function Based Indexes
4m 32s
06
Multiple Indexes With Same Columns
9m 4s
07
Dropping Indexes
2m 52s
08
USER_INDEXES and USER_IND_COLUMNS Views
4m 3s
01
What is a View and Why Is It Used For?
2m 52s
02
Types Of Views
1m 58s
03
Creating Simple Views
12m 17s
04
Creating Complex Views
4m 35s
05
Modifying Views
3m 37s
06
Analyzing User Views
3m 20s
07
Performing DML Operations with Views
6m 41s
08
Using WITH CHECK OPTION Clause
10m 54s
09
Preventing DML Operations on A View
2m 22s
10
Dropping Views
2m 2s
01
What is a Materialized View and Why is it Used For?
5m 2s
02
Creating Materialized Views Part 1
6m 32s
03
Creating Materialized Views Part 2
4m 54s
04
Complex Materialized Views
3m 50s
05
Types of Refreshing Materialized Views
9m 53s
06
Refreshing Materialized Views Manually
10m 31s
07
Scheduling Periodic Refresh of Materialized Views
1m 40s
01
Using Subqueries as a Source
5m 40s
02
Scalar Subqueries
9m 11s
03
Multiple Column Subqueries
7m 21s
04
Correlated Subqueries
4m 10s
05
EXISTS Operator
5m 16s
06
NOT EXISTS Operator
4m 56s
07
Using WITH Clause
6m 31s
08
Using Recursive WITH Clause
5m 33s
09
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
01
Using DEFAULT Keyword on Insert And Update Statements
5m 45s
02
Multitable Insert Statements
1m 20s
03
Unconditional Insert Statements
6m 31s
04
Conditional Insert Statements
8m 7s
05
Conditional Insert First Statements
5m 21s
06
Pivoting Insert
4m 28s
07
Merging Data
10m 3s
08
Flashback Operations
11m 6s
09
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
01
Adding Constraints
7m 21s
02
Removing Constraints
3m 51s
03
On Delete CASCADE & On Delete SET NULL
9m 35s
04
Cascading Constraints
3m 57s
05
Renaming Constraints
2m 40s
06
Disabling Constraints
3m 2s
07
Enabling Constraints
2m 34s
08
Status Of Constraints
3m 4s
09
Deferring Constraints
13m 48s
10
Creating Temporary Tables
10m 28s
01
What Are Privileges And Why Are They Used For?
2m 46s
02
Creating A User
3m 55s
03
System Privileges
3m 58s
04
Granting System Privileges
7m 7s
05
What is A Role and Why is It Used For?
4m 28s
06
Changing The User Password
5m 5s
07
Object Privileges
2m 2s
08
Granting Object Privileges
10m 29s
09
Revoking Object Privileges
3m 13s
10
Searching For Privileges in Data Dictionary Views
6m 44s
01
Understanding Hierarchical Retrieval
2m 48s
02
Generating Hierarchical Queries
3m 12s
03
Walking On The Tree (Bottom to Up - Up to Down)
7m 12s
04
Ranking Rows (Using LEVEL Pseudocolumn)
4m 6s
05
Formatting Tree Structure (LEVEL & LPAD)
3m 59s
06
Pruning Branches Of a Tree
3m 51s
01
Generating Scripts By Using Data Dictionary Views
6m 4s
01
What is Regular Expressions and Why and Where Do We Use Them?
2m 22s
02
What Are Metacharacters?
13m 37s
03
Regular Expression Functions
2m 34s
04
Using REGEXP_LIKE() function
4m 45s
05
Using REGEXP_REPLACE() Function
10m 18s
06
Using REGEXP_SUBSTR() Function
8m 34s
07
Using REGEXP_INSTR() Function
6m 11s
08
Using REGEXP_COUNT() Function
4m
09
Using REGEX in Constraints
4m 59s
01
What are the Analytic Functions?
12m 34s
02
ROW_NUMBER Analytic Function
4m 22s
03
RANK and DENSE_RANK Analytic Functions
4m 51s
04
LEAD & LAG Analytic Functions (Next & Previous Values)
8m 13s
05
Windowing Clause in Analytic Functions - Part 1
10m 56s
06
Windowing Clause in Analytic Functions - Part 2
9m 16s
07
INTERVAL Keyword In Analytic Functions
4m 26s
08
FIRST_VALUE and LAST_VALUE Analytic Functions..
6m 46s
09
Selecting Top-N Rows with Analytic Functions
4m 22s