Curriculum For This Course

Software Installation

1Lectures

Time 00:16:29

Introducing Database Objects

2Lectures

Time 00:15:57

Data Dictionary Views

10Lectures

Time 00:45:40

Creating, Using and Managing Sequences

8Lectures

Time 00:30:54

Creating, Using and Analyzing Synonyms

4Lectures

Time 00:15:52

Understanding Indexes

8Lectures

Time 00:41:50

Managing Views

10Lectures

Time 00:51:33

Materialized Views

7Lectures

Time 00:42:56

Using Advanced Subqueries

12Lectures

Time 01:11:20

Advanced Data Manipulations

12Lectures

Time 01:09:51

Constraints (Controlling Schema Objects)

10Lectures

Time 00:60:22

Administering User Privileges and Roles

10Lectures

Time 00:49:46

Hierarchical Queries (Tree Structure)

6Lectures

Time 00:25:08

Generating Dynamic SQL Scripts

1Lectures

Time 00:06:07

Regular Expressions

9Lectures

Time 00:57:24

Analytical SQL Functions (New Videos: Sep, 2017)

9Lectures

Time 01:05:46

Software Installation
	1. Having The Database with Oracle VirtualBox	16:29

Introducing Database Objects
	1. Introducing Database Objects and Reaching Another User's Objects	09:34
	2. Reaching Another User's Objects	06:21

Data Dictionary Views
	1. What Are Data Dictionary Views?	01:15
	2. What Is There In Data Dictionary Views?	01:12
	3. Dictionary Table	03:18
	4. Differences Between USER, ALL, DBA, V$ Prefixes	01:31
	5. USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS Views	09:13
	6. USER_TABLES View	05:11
	7. USER_TAB_COLUMNS View	05:04
	8. User Constraints View	09:47
	9. USER_CONS_COLUMNS View	05:29
	10. USER_TAB_COMMENTS & USER_COL_COMMENTS Views	03:42

Creating, Using and Managing Sequences
	1. What is a Sequence and Why is It Used For?	01:27
	2. Creating Sequences	06:42
	3. Modifying Sequences	02:48
	4. Dropping Sequences	01:23
	5. Using Sequences	09:08
	6. Using Sequences As a Default Value	04:30
	7. Sequence Caching	02:28
	8. User Sequences	02:29

Creating, Using and Analyzing Synonyms
	1. What Is a Synonym and Why Is It Used For?	02:32
	2. Creating & Dropping Synonyms	07:03
	3. Using Synonyms	02:34
	4. Analyzing USER_SYNONYMS	03:43

Understanding Indexes
	1. What is an Index and Why is It Used For?	02:43
	2. Types of Indexes	02:19
	3. Creating Indexes	07:47
	4. Creating Index on Table Creation	07:44
	5. Function Based Indexes	04:32
	6. Multiple Indexes With Same Columns	09:04
	7. Dropping Indexes	02:52
	8. USER_INDEXES and USER_IND_COLUMNS Views	04:03

Managing Views
	1. What is a View and Why Is It Used For?	02:52
	2. Types Of Views	01:58
	3. Creating Simple Views	12:17
	4. Creating Complex Views	04:35
	5. Modifying Views	03:37
	6. Analyzing User Views	03:20
	7. Performing DML Operations with Views	06:41
	8. Using WITH CHECK OPTION Clause	10:54
	9. Preventing DML Operations on A View	02:22
	10. Dropping Views	02:02

Materialized Views
	1. What is a Materialized View and Why is it Used For?	05:02
	2. Creating Materialized Views Part 1	06:32
	3. Creating Materialized Views Part 2	04:54
	4. Complex Materialized Views	03:50
	5. Types of Refreshing Materialized Views	09:53
	6. Refreshing Materialized Views Manually	10:31
	7. Scheduling Periodic Refresh of Materialized Views	01:40

Using Advanced Subqueries
	1. Using Subqueries as a Source	05:40
	2. Scalar Subqueries	09:11
	3. Multiple Column Subqueries	07:21
	4. Correlated Subqueries	04:10
	5. EXISTS Operator	05:16
	6. NOT EXISTS Operator	04:56
	7. Using WITH Clause	06:31
	8. Using Recursive WITH Clause	05:33
	9. Inserting Data By Using a Subquery as a Target	07:06
	10. Manipulating Data by Using "WITH CHECK OPTION" Keyword	06:24
	11. Correlated Delete	02:23
	12. Correlated Update	06:15

Advanced Data Manipulations
	1. Using DEFAULT Keyword on Insert And Update Statements	05:45
	2. Multitable Insert Statements	01:20
	3. Unconditional Insert Statements	06:31
	4. Conditional Insert Statements	08:07
	5. Conditional Insert First Statements	05:21
	6. Pivoting Insert	04:28
	7. Merging Data	10:03
	8. Flashback Operations	11:06
	9. Purge Operations	04:02
	10. Tracking Changes In Data In a Particular Time	01:28
	11. FLASHBACK Query	06:31
	12. FLASHBACK VERSIONS Query	04:57

Constraints (Controlling Schema Objects)
	1. Adding Constraints	07:21
	2. Removing Constraints	03:51
	3. On Delete CASCADE & On Delete SET NULL	09:35
	4. Cascading Constraints	03:57
	5. Renaming Constraints	02:40
	6. Disabling Constraints	03:02
	7. Enabling Constraints	02:34
	8. Status Of Constraints	03:04
	9. Deferring Constraints	13:48
	10. Creating Temporary Tables	10:28

Administering User Privileges and Roles
	1. What Are Privileges And Why Are They Used For?	02:46
	2. Creating A User	03:55
	3. System Privileges	03:58
	4. Granting System Privileges	07:07
	5. What is A Role and Why is It Used For?	04:28
	6. Changing The User Password	05:05
	7. Object Privileges	02:02
	8. Granting Object Privileges	10:29
	9. Revoking Object Privileges	03:13
	10. Searching For Privileges in Data Dictionary Views	06:44

Hierarchical Queries (Tree Structure)
	1. Understanding Hierarchical Retrieval	02:48
	2. Generating Hierarchical Queries	03:12
	3. Walking On The Tree (Bottom to Up - Up to Down)	07:12
	4. Ranking Rows (Using LEVEL Pseudocolumn)	04:06
	5. Formatting Tree Structure (LEVEL & LPAD)	03:59
	6. Pruning Branches Of a Tree	03:51

Generating Dynamic SQL Scripts
	1. Generating Scripts By Using Data Dictionary Views	06:04

Regular Expressions
	1. What is Regular Expressions and Why and Where Do We Use Them?	02:22
	2. What Are Metacharacters?	13:37
	3. Regular Expression Functions	02:34
	4. Using REGEXP_LIKE() function	04:45
	5. Using REGEXP_REPLACE() Function	10:18
	6. Using REGEXP_SUBSTR() Function	08:34
	7. Using REGEXP_INSTR() Function	06:11
	8. Using REGEXP_COUNT() Function	04:00
	9. Using REGEX in Constraints	04:59

Analytical SQL Functions (New Videos: Sep, 2017)
	1. What are the Analytic Functions?	12:34
	2. ROW_NUMBER Analytic Function	04:22
	3. RANK and DENSE_RANK Analytic Functions	04:51
	4. LEAD & LAG Analytic Functions (Next & Previous Values)	08:13
	5. Windowing Clause in Analytic Functions - Part 1	10:56
	6. Windowing Clause in Analytic Functions - Part 2	09:16
	7. INTERVAL Keyword In Analytic Functions	04:26
	8. FIRST_VALUE and LAST_VALUE Analytic Functions..	06:46
	9. Selecting Top-N Rows with Analytic Functions	04:22

About This Course

This video course is intended for those specialists who already possess medium-level professional skills in using SQL and want to take the next step in their careers. If you are one of such individuals, then welcome to the training! The knowledge you will gain here will sufficiently increase your chances to pass the SQL-related Oracle certification exams at your first attempt.

In the course, you will find an imposing collection of 119 video lectures covering the following objectives:

Installing software. Database + Oracle VirtualBox
Database objects: an introduction. How to reach the objects that belong to another user?
About Data Dictionary Views
Sequences: an introduction. How to create, use, modify, and drop sequences
How to use, create, drop, and analyze synonyms
What are indexes and how to create, use, and drop them? Types of indexes
How to use, create, modify, drop, and analyze views? Types of Views
About materialized views and how to create and refresh them
Advanced subqueries. Working with operators and clauses
Data manipulations on an advanced level. More about Insert statements
How to add, remove, rename, enable, disable, and defer constraints
How to administer user roles and privileges?
The hierarchy of queries. About the tree structure
How to generate dynamic SQL scripts?
Regular expressions and their types. REGEXP_LIKE(), REGEXP_REPLACE(), and other functions
About analytical SQL functions and how to use them

With this detailed, precise, and at the same time interesting tutorial, you will be able to boost your SQL skills and get ready for the Oracle certification tests. Start your training today – beat the competition tomorrow!

Pass Databases Courses SQL From Intermediate to Advanced Level Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!
30 Days Free Updates, Instant Download!

Student Feedback

4.4

Good

42%

58 %

Add Comments

Name:^*

E-mail:^*

Comment:^* Comment will be moderated and published within 1-4 hours

Verification:^*

Type the characters from the picture.

Rate Course:^*

Limited Time Discount Offer 10% Off - Ends in 02:00:00

SQL From Intermediate to Advanced Level

Curriculum For This Course

About This Course

Pass Databases Courses SQL From Intermediate to Advanced Level Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!30 Days Free Updates, Instant Download!

Student Feedback

Add Comments

Get Premium Membership

Limited Time Discount Offer
10% Off - Ends in 02:00:00

Get 100% Latest Exam Questions, Accurate & Verified Answers!
30 Days Free Updates, Instant Download!