Sql Advanced

About the Database Installation Preview 03:02

The Ways to Get a Database Preview 14:50

In this SQL tutorial, the participants will learn how to get a database to proceed with the Advanced SQL: SQL Expert Certification Preparation course.

Option 1: Installing VMware and VirtualBox on Windows Preview 07:33

In this SQL tutorial, the participants will learn how to download and install two virtualization software programs which are VMware and VirtualBox step by step.

Option 1: How to Install the Virtual Box on Mac OS X? Preview 01:48

Option 1: Downloading Virtual Machine Image Preview 04:11

In this tutorial, the participants will learn how to download the virtual machine image.

Option 1: Configuring the VMware Virtualization Software Preview 08:18

In this SQL tutorial, the participants will learn how to import the virtual machine image they downloaded into the VMware virtualization software as well as how to configure the virtual machine to get the most out of it.

Option 1: Configuring the Oracle VirtualBox Virtualization Software Preview 06:45

In this SQL tutorial, the participants will learn how to import the virtual machine image they downloaded into the Oracle VirtualBox virtualization software as well as how to configure the virtual machine to get the most out of it.

Option 1: Configuring SQL Developer inside of the Virtual Machine Preview 13:02

In this SQL tutorial, the participants will learn how to configure SQL Developer inside of the Virtual Machine image that they downloaded step by step.

What is Pluggable Database (Multitenant Architecture)? Preview 03:13

In this lecture, you're going to learn what the pluggable database (multitenant architecture) is in Oracle Database.

Lesson keywords: "multitenant architecture", "oracle pluggable database".

Option 2: Downloading And Installing the Oracle Database Preview 18:18

In this lecture, students are going to learn the oracle database 19c installation.

Lecture keywords: "oracle", "oracle sql", "oracle database", "oracle database installation", "oracle database 19c installation".

Option 2: Unlocking the HR Schema Preview 07:34

In this lecture, our students are going to learn how to unlock the HR schema to practice throughout the course.

Lesson keywords: "hr schema", "unlock hr schema".

Option 2: Configuring and Using the SQL Developer Preview 22:14

Option 3: Using Oracle Live SQL Preview 07:40

Option 3: About Oracle Live SQL Restrictions Preview 00:20

The Sample (HR) Schema Used in This Course Preview 07:23

Introducing Database Objects and Reaching Another User's Objects Preview 09:37

You need to be familiar with Database Objects to understand Advanced SQL subjects easily.

Reaching Another User's Objects Preview 06:20

Explains how to reach another user's objects (tables, views, etc) with SQL queries

The Working Document Preview 00:16

This working document is prepared for our students.

Don't Forget to Leave a Rating! Preview 00:19

This lecture introduces shows how much we appriciate your thoughts.

Code Samples Preview 09:46

Sample codes that I have used along the Advanced SQL Course

Quiz 1

This quiz is for the database objects and selecting from the other schemas.

What Are Data Dictionary Views? Preview 01:15

A brief introduction for Data Dictionary Views

What Is There In Data Dictionary Views? Preview 01:12

Explains what is there in Data Dictionary Views and how can we use them with SQL Queries.

Dictionary Table Preview 03:18

Explains Dictionary Table with SQL query

Differences Between USER, ALL, DBA, V$ Prefixes Preview 01:30

A biref explanation on the difference between user, all, dba and v$ prefixes that you can use with your SQL Queries.

USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS Views Preview 09:13

Explains these subjects with using SQL queries and with different users.

USER_TABLES View Preview 05:11

Explains User_tables data dictionary view to see the tables that we can use with our SQL queries.

USER_TAB_COLUMNS View Preview 05:04

Explains user_tab_colums view with SQL query.

User Constraints View Preview 09:47

Explains user_constraints view and how to use this view with our sql queries in detail

USER_CONS_COLUMNS View Preview 05:28

Explains how to get columns of our constraints with sql queries.

USER_TAB_COMMENTS & USER_COL_COMMENTS Views Preview 03:42

How we get the comments on tables or columns with using SQL Queries

Quiz 2

The questions for Data Dictionary Views

What is a Sequence and Why is It Used For? Preview 01:27

A biref explanation for sequences and the usage with SQL.

Creating Sequences Preview 06:42

How to create sequences with using SQL codes

Modifying Sequences Preview 02:47

Explains how to modify sequences with SQL codes

Dropping Sequences Preview 01:23

Explains how to drop sequences with using just one SQL code.

Using Sequences Preview 09:08

Explains how to use sequences with SQL codes in detail.

Using Sequences As a Default Value Preview 04:30

How can we use sequences as a default value with our SQL DML operations.

Sequence Caching Preview 02:28

Explains how to and why cache sequences and how effects our SQL.

User Sequences Preview 02:29

Explains how to query our sequences with sql codes.

Quiz 3

This quiz is for Sequences..

What Is a Synonym and Why Is It Used For? Preview 02:32

Explains the synonyms in brief and why you should use in your SQL queries.

Creating & Dropping Synonyms Preview 07:03

Explains how to create and drop synonyms with SQL Codes.

Using Synonyms Preview 02:34

Explains how to use Synonyms with your SQL Codes.

Analyzing USER_SYNONYMS Preview 03:43

Looks deep into user_synonyms by querying with SQL codes.

Quiz 4

This Quiz is for Synonyms in SQL

What is an Index and Why is It Used For? Preview 02:43

A brief explanation for indexes' usage and benefits in SQL queries

Types of Indexes Preview 02:32

Explains types of indexes and which one to choose in your sql codes

Creating Indexes Preview 08:02

Explains how to create indexes with or without SQL queries.

Creating Index on Table Creation Preview 07:43

How to create index while creating a table with SQL codes.

Function Based Indexes Preview 04:52

Explains why and how to create function based indexes with your SQL Codes.

Multiple Indexes With Same Columns Preview 09:04

The way and why for creating multiple indexes in your SQL

Dropping Indexes Preview 02:51

How to drop an Index with just one SQL Code

USER_INDEXES and USER_IND_COLUMNS Views Preview 04:03

How to get information about indexes with a simle SQL Query

Quiz 5

This quiz is for testing your knowledge about indexes

What is a View and Why Is It Used For? Preview 03:04

SQL, Advanced sql: This lesson includes View topics and using views with lots of examples.

Types Of Views Preview 01:58

SQL, Advanced sql: In this lesson we're going to learn "Types of Views" in Oracle Database.

Creating Simple Views Preview 12:25

SQL, advanced sql: In this lesson we're going to learn how to create "Simple Views" in Oracle Database.

Creating Complex Views Preview 04:35

SQL, Advanced sql: In this lesson we're going to learn how to create "Complex Views" in Oracle Database.

Modifying Views Preview 03:37

SQL, Advanced sql: In this lesson we're going to learn how to modify a view (Modifying Views) in Oracle Database.

Analyzing User Views Preview 03:20

SQL, Advanced SQL: This lesson explains "Analyzing User Views" in Oracle Database.

Performing DML Operations with Views Preview 06:52

SQL, Advanced SQL: This lesson covers Performing DML operations vith views.

Using WITH CHECK OPTION Clause Preview 11:06

SQL, Advanced SQL: In this lesson we're going to learn "Using with CHECK Option" in Oracle Database.

Preventing DML Operations on A View Preview 02:22

SQL, Advanced sql: In this lesson we're going to learn how to prevent DML(Data Manipulation Languages) Operations on a view in Oracle Database.

Dropping Views Preview 02:14

SQL, Advanced SQL: In this lesson we're going to learn how to drop a view (Dropping Views) in Oracle Database.

Quiz 6

This quiz is a recap for views

What is a Materialized View and Why is it Used For? Preview 05:12

SQL, Advanced SQL: This lesson introduces Materialized Views section.

Creating Materialized Views Part 1 Preview 06:32

SQL, Advanced SQL: In this lesson we're going to learn how to create Materialized Views. (Part 1)

Creating Materialized Views Part 2 Preview 04:54

SQL, Advanced SQL: In this lesson we're going to learn how to create Materialized Views. (Part 2)

Complex Materialized Views Preview 03:49

SQL, Advanced SQL: In this lesson we're going to learn how to create Complex Materialized Views.

Types of Refreshing Materialized Views Preview 10:02

SQL, Advanced SQL: This lesson we're going to learn Types of Refreshing Materialized Views.

Refreshing Materialized Views Manually Preview 10:39

SQL, Advanced SQL: In this lesson we are going to learn how to refresh materialized views manually.

Scheduling Periodic Refresh of Materialized Views Preview 01:48

SQL, Advanced SQL: In this lesson we're going to learn Scheduling Periodic Refresh of Materialized Views.

Quiz 7

This quiz is a recap for Materialized Views.

Using Subqueries as a Source Preview 05:56

SQL, Advanced SQL: This lesson explains how do we use a subquery as a source.

Scalar Subqueries Preview 09:11

SQL, Advanced sql: In this lesson we are going to learn Scalar Subqueries.

Multiple Column Subqueries Preview 07:21

SQL, Advanced sql: In this lesson we are going to learn Multiple Column Subqueries.

Correlated Subqueries Preview 04:18

SQL, Advanced sql: In this lesson we are going to learn Correlated Subqueries.

EXISTS Operator Preview 05:16

SQL, Advanced sql: In this lesson we are going to learn how do we use EXISTS Operator in Advanced Subqueries.

NOT EXISTS Operator Preview 04:56

SQL, Advanced sql: In this lesson we are going to learn how do we use NOT EXISTS Operator in Advanced Subqueries.

Using WITH Clause Preview 06:31

SQL, Advanced sql: In this lesson we are going to learn Using "WITH" Clause.

Using Recursive WITH Clause Preview 05:33

SQL, Advanced sql: In this lesson we are going to learn Using Recursive "WITH" Clause.

Inserting Data By Using a Subquery as a Target Preview 07:06

SQL, Advanced sql: In this lesson we are going to learn how to Insert Data by Using A Subquery.

Manipulating Data by Using "WITH CHECK OPTION" Keyword Preview 06:24

SQL, Advanced sql: In this lesson we are going to learn Manipulating Data by Using "WITH CHECK OPTION" Keyword.

Correlated Update Preview 06:15

SQL, Advanced sql: In this lesson we are going to learn Correlated Update.

Correlated Delete Preview 02:33

SQL, Advanced sql: In this lesson we are going to learn Correlated Delete.

Quiz 8

This quiz is recap for Advanced Subqueries Section

Using DEFAULT Keyword on Insert And Update Statements Preview 05:58

SQL, Advanced SQL: This lesson introduces Using DEFAULT Keyword on Insert and Update Statement.

Multitable Insert Statements Preview 01:20

SQL, Advanced SQL: In this lesson we are going to learn Multitable Insert Statements.

Unconditional Insert Statements Preview 06:31

SQL, Advanced SQL: In this lesson we are going to learn Unconditional Multitable Insert Statements.

Conditional Insert Statements Preview 08:06

SQL, Advanced SQL: In this lesson we are going to learn Multitable Insert Statements with examples.

Conditional Insert First Statements Preview 05:21

SQL, Advanced SQL: In this lesson we are going to learn Conditional Insert First Statement.

Pivoting Insert Preview 04:28

SQL, Advanced SQL: In this lesson we are going to learn Pivoting Insert.

Merging Data Preview 10:03

SQL, Advanced SQL: In this lesson we are going to learn Merging Data.

Flashback Operations Preview 11:06

SQL, Advanced SQL: This lesson introduces Flashback Operations with examples.

Lesson Keywords: sql, advanced sql, flashback operations.

Purge Operations Preview 04:02

SQL, Advanced SQL: This lesson introduces Purge Operations with examples.

Lesson Keywords: sql, advanced sql, purge operations.

Tracking Changes In Data In a Particular Time Preview 01:28

SQL, Advanced SQL: This lesson introduces Tracking Changes In Data In a Particular Time.

Lesson Keywords: sql, advanced sql, tracking changes,

FLASHBACK Query Preview 06:31

SQL, Advanced SQL: This lesson introduces Flashback Query with examples.

Lesson Keywords: sql, advanced sql, flashback operations, flashback query.

FLASHBACK VERSIONS Query Preview 04:57

SQL, Advanced SQL: This lesson introduces Flashback Versions Query with examples.

Lesson Keywords: sql, advanced sql, flashback operations, flashback versions query.

Quiz 9

This quiz is about advanced data manipulations in SQL

Adding Constraints Preview 07:25

SQL, Advanced SQL: In this lesson, we are going to learn Adding Constraints with examples.

Lesson Keywords: sql, advanced sql, constraints.

Removing Constraints Preview 03:51

SQL, Advanced SQL: In this lesson, we are going to learn Removing Constraints with examples.

Lesson Keywords: sql, advanced sql, constraints.

On Delete CASCADE & On Delete SET NULL Preview 09:35

SQL, Advanced SQL: In this lesson, we are going to learn "ON DELETE CASCADE - ON DELETE SET NULL" clauses with examples.

Lesson Keywords: sql, advanced sql, on delete cascade, on delete set null.

Cascading Constraints Preview 03:57

SQL, Advanced SQL: In this lesson we are going to learn "Cascading Constraints".

Lesson Keywords: sql, advanced sql, constraints, cascading constraints.

Renaming Constraints Preview 02:39

SQL, Advanced SQL: In this lesson we are going to learn "Renaming Constraints".

Lesson Keywords: sql, advanced sql, constraints, renaming constraints.

Disabling Constraints Preview 03:02

SQL, Advanced SQL: In this lesson we are going to learn "Disabling Constraints".

Lesson Keywords: sql, advanced sql, constraints, disabling constraints.

Enabling Constraints Preview 02:34

SQL, Advanced SQL: In this lesson we are going to learn "Enabling Constraints".

Lesson Keywords: sql, advanced sql, constraints, enabling constraints.

Status Of Constraints Preview 03:03

SQL, Advanced SQL: In this lesson we are going to learn "Status of Constraints".

Lesson Keywords: sql, advanced sql, constraints, status of constraints.

Deferring Constraints Preview 13:48

SQL, Advanced SQL: In this lesson we are going to learn "Deferring Constraints".

Lesson Keywords: sql, advanced sql, constraints, deferring constraints.

Creating Temporary Tables Preview 10:28

SQL, Advanced SQL: We are going to learn how to create a temporary table in "Creating Temporary Tables" lesson.

Lesson Keywords: sql, advanced sql, constraints, creating temporary tables.

Quiz 10

This quiz is for Controlling Schema Objects Section

What Are Privileges And Why Are They Used For? Preview 02:46

SQL, Advanced SQL: This lesson demonstrates what are the privileges and why are they used for?

Lesson Keywords: sql, advanced sql, privileges.

Creating A User Preview 03:55

SQL, Advanced SQL: In this lesson we are going to learn creating a user.

Lesson Keywords: sql, advanced sql, privileges, creating user.

System Privileges Preview 03:58

SQL, Advanced SQL: In this lesson we are going to learn "System Privileges".

Lesson Keywords: sql, advanced sql, privileges, system privileges.

Granting System Privileges Preview 07:07

SQL, Advanced SQL: In this lesson we are going to learn "Granting System Privileges".

Lesson Keywords: sql, advanced sql, privileges, granting system privileges.

What is A Role and Why is It Used For? Preview 04:28

SQL, Advanced SQL: This lesson demonstrates what is a role and why is it used for?

Lesson Keywords: sql, advanced sql, privileges, role.

Changing The User Password Preview 05:05

SQL, Advanced SQL: In this lesson we are going to learn "Changing the User Password".

Lesson Keywords: "sql", "oracle sql", "advanced sql", "privileges", "changin the user password".

Object Privileges Preview 02:01

SQL, Advanced SQL: In this lesson we are going to learn "Object Privileges".

Lesson Keywords: "sql", "oracle sql", "advanced sql", "privileges", "object privileges".

Granting Object Privileges Preview 10:29

SQL, Advanced SQL: In this lesson we are going to learn "Granting Object Privileges".

Lesson Keywords: "sql", "oracle sql", "advanced sql", "privileges", "granting object privileges".

Revoking Object Privileges Preview 03:13

SQL, Advanced SQL: In this lesson we are going to learn "Revoking Object Privileges".

Lesson Keywords: "sql", "oracle sql", "advanced sql", "privileges", "revoking system privileges".

Searching For Privileges in Data Dictionary Views Preview 06:44

SQL, Advanced SQL: In this lesson we are going to learn "Searching For Privileges in Data Dictionary Views".

Lesson Keywords: "sql", "oracle sql", "advanced sql", "privileges", "searching for privileges in data dictionary views".

Quiz 11

This quiz is about privileges in SQL

Understanding Hierarchical Retrieval Preview 02:48

SQL, Advanced SQL: In this lesson we are going to learn "Understanding Hierarchical Retrieval".

Lesson Keywords: "sql", "oracle sql", "advanced sql", "privileges", "understanding hierarchical retrieval".

Generating Hierarchical Queries Preview 03:12

SQL, Advanced SQL: In this lesson we are going to learn  how to generate hierarchical queires.

Lesson Keywords: "sql", "oracle sql", "advanced sql", "privileges", "generating hierarchical queries".

Walking On The Tree (Bottom to Up - Up to Down) Preview 07:12

SQL, Advanced SQL: In this lesson we are going to learn "Walking on The Tree".

Lesson Keywords: "sql", "oracle sql", "advanced sql", "privileges", "walking on the tree".

Ranking Rows (Using LEVEL Pseudocolumn) Preview 04:06

SQL, Advanced SQL: In this lesson we are going to learn "Ranking Rows with using LEVEL Pseudocolumn".

Lesson Keywords: "sql", "oracle sql", "advanced sql", "privileges", "ranking rows", "level pseudocolumn".

Formatting Tree Structure (LEVEL & LPAD) Preview 03:59

SQL, Advanced SQL: In this lesson we are going to learn "Formatting Tree Structure with Using LEVEL & LPAD".

Lesson Keywords: "sql", "oracle sql", "advanced sql", "privileges", "formatting tree","LEVEL", "level", "LPAD","lpad".

Pruning Branches Of a Tree Preview 03:51

SQL, Advanced SQL: In this lesson we are going to learn "Pruning Branches of a Tree".

Lesson Keywords: "sql", "oracle sql", "advanced sql", "privileges", "pruning trees".

Quiz 12

This quiz is about tree structure in SQL

Generating Scripts By Using Data Dictionary Views Preview 06:07

SQL, Advanced SQL: In this lesson we are going to learn "Generating Dynamic SQL Scripts".

Lesson Keywords: "sql", "oracle sql", "advanced sql", "privileges", "dynamic sql scripts".

What is Regular Expressions and Why and Where Do We Use Them? Preview 02:27

SQL, Advanced SQL: In this lesson we are going to learn:

"What is Regular Expressions and Why and Where do we use them?".

Lesson Keywords: "sql", "oracle sql", "advanced sql", "regular expressions", "oracle regular expressions".

What Are Metacharacters? Preview 13:37

This lecture shows what are metacharactes in regular expression section.

Lesson keywords: sql, advanced sql, regular expressions, metacharacters.

Regular Expression Functions Preview 02:34

SQL, Advanced SQL: In this lesson we are going to learn "Regular Expressions Functions". 

Lesson Keywords: "sql", "oracle sql", "advanced sql", "regular expressions", "regular expression functions".

Using REGEXP_LIKE() function Preview 04:44

SQL, Advanced SQL: In this lesson we are going to learn "Using REGEXP_LIKE Function". 

Lesson Keywords: "sql", "oracle sql", "advanced sql", "regular expressions", "regular expression functions","regexp_like function".

Using REGEXP_REPLACE() Function Preview 10:18

This lecture shows how to replace the texts with a regular expression by using regexp_replace function

Using REGEXP_SUBSTR() Function Preview 08:34

This lecture explains how to use regexp_substr function in sql

Using REGEXP_INSTR() Function Preview 06:11

How to find the place of the string in a string with using the pattern, in sql queries.

Using REGEXP_COUNT() Function Preview 04:00

This lecture explains how to use regexp_count function in sql

Using REGEX in Constraints Preview 04:59

This lecture demonstrates how to use regular expression in constraints.

What are the Analytic Functions? Preview 12:34

SQL, Advanced SQL: In this lesson we are going to learn "what are the Analytic Functions in Oracle".

Lesson Keywords: "sql", "oracle sql", "advanced sql", "sql analytic", "analytic functions","analytical functions".

ROW_NUMBER Analytic Function Preview 04:22

SQL, Advanced SQL: In this lesson we are going to learn "ROW_NUMBER Analytic Function".

Lesson Keywords: "sql", "oracle sql", "advanced sql", "sql analytic", "analytic functions","row_number function".

RANK and DENSE_RANK Analytic Functions Preview 04:51

SQL, Advanced SQL: In this lesson we are going to learn "RANK and DENSE_RANK Analytic Function".

Lesson Keywords: "sql", "oracle sql", "advanced sql", "sql analytic", "analytic functions","rank function", "dense_rank function".

LEAD & LAG Analytic Functions (Next & Previous Values) Preview 08:13

In this lecture, you will learn how to get next and previous values of the columns, without querying it, with analytic functions in SQL.

Windowing Clause in Analytic Functions - Part 1 Preview 10:56

In this lesson, you will see how to divide the partitions into smaller pieces, get some operations with next or previous values..

Windowing Clause in Analytic Functions - Part 2 Preview 09:16

In this lesson, you will see how to divide the partitions into smaller pieces, get some operations with next or previous values..

INTERVAL Keyword In Analytic Functions Preview 04:26

In this lesson we will learn how to use INTERVAL keyword in windowing, in Analytic Clauses.

FIRST_VALUE and LAST_VALUE Analytic Functions Preview 06:46

Selecting Top-N Rows with Analytic Functions Preview 04:22

With this lecture, you will learn how to select top (first) n rows with using Analytic Functions

Appendix 1: Oracle Database 12c Installation into Your Computer Preview 08:58

This course explains how to download and install Oracle Database 12c, from my first course.

I added this video again into my this course, since some of my students my not get the first course, but they confuse how to install the software.

Appendix 2: How to Unlock the HR User (Schema) in the Oracle Database 12c? Preview 01:41

In this SQL tutorial, if you are having problems while connecting to the HR schema, you need to follow these instructions step by step.

Appendix 3: Configuring and Using Oracle SQL Developer for Oracle Database 12c Preview 09:53

Bonus Lecture Preview 00:25