Development
Databases
SQL
Advanced SQL : SQL Expert Certification Preparation Course
4.3 (1,659 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
18,517 students enrolled

Advanced SQL : SQL Expert Certification Preparation Course

Complete Your Oracle SQL Knowledge From Intermediate to Advanced Level and Become a Database SQL Expert in Oracle!
4.3 (1,659 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
18,517 students enrolled
Created by Oracle Master Training • 60,000+ Students Worldwide, Code Star Academy
Last updated 6/2020
English
English, Indonesian [Auto], 5 more
  • Italian [Auto]
  • Polish [Auto]
  • Romanian [Auto]
  • Spanish [Auto]
  • Thai [Auto]
Preview this course
Advanced SQL : SQL Expert Certification Preparation Course
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 13 hours on-demand video
  • 7 articles
  • 7 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • All the advanced subjects that you need for SQL Expert Certification
  • Learn Advanced SQL Query with Hundreds of Examples!
  • Write, Read, Analyze Any Advanced SQL Codes Easily
  • Over 125+ Lectures, 12+ Hours On-Demand Content
  • Learn Advanced SQL Functions in Oracle
  • Get a Better Job and Income!
  • Analytical SQL Functions in Oracle
  • Regular Expressions
  • Introducing Database Objects
  • Creating and Using Indexes
  • Creating and Using Views
  • Creating and Using Synonyms
  • Creating and Using Sequences
  • Data Dictionary Views
  • Using Advanced Subqueries
  • Generating (Dynamic) SQL Scripts
  • Advanced Data Manipulations
  • Advanced Aggregation Techniques
  • Windowing functions for working with ordered data sets
  • Lifetime Support from the Authors
  • Working Materials
  • Weekly Quizzes & Assessments
Course content
Expand all 138 lectures 13:05:02
+ – Course Introduction
2 lectures 06:24

A brief introduction for why Advanced SQL and why my course..

Introduction
Preview 01:23

This lecture is about how to use the Udemy platform. And also includes some useful tips to get most of out the course.

UDEMY 101: How to Use Udemy? +Some Useful Tips
05:01
+ – Software Installation
11 lectures 01:36:57
About the Database Installation
Preview 03:02
Which Option to Have a Database?
09:07

This lecture shows how to get Oracle database without installing, downloading and much more efforts.

We've prepared a virtual machine that contains a completely running Oracle database in it for you.

So you don't need to install Oracle database at all.

All you have to do is just to install the Oracle Virtual Box image.

Then, you'll get your database easily.

Option 1: Having the Database with the Oracle Virtual Box
16:29
Option 1: How to Install the Virtual Box on Mac OS X?
01:36

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".

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

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: Downloading And Installing the Oracle Database
Preview 18:18

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: Unlocking the HR Schema
07:34
Option 2: Configuring and Using the SQL Developer
22:14
Option 3: Using Oracle Live SQL
07:40
Option 3: About Oracle Live SQL Restrictions
00:20
The Sample (HR) Schema Used in This Course
07:23
+ – Introducing Database Objects
5 lectures 26:19

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

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

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

Reaching Another User's Objects
06:20

This working document is prepared for our students.

The Working Document
00:16

This lecture introduces shows how much we appriciate your thoughts.

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

Sample codes that I have used along the Advanced SQL Course

Code Samples
09:46

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

Quiz 1
5 questions
+ – Data Dictionary Views
10 lectures 45:40

A brief introduction for Data Dictionary Views

What Are Data Dictionary Views?
01:15

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

What Is There In Data Dictionary Views?
01:12

Explains Dictionary Table with SQL query

Dictionary Table
03:18

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

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

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

USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS Views
09:13

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

USER_TABLES View
05:11

Explains user_tab_colums view with SQL query.

USER_TAB_COLUMNS View
05:04

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

User Constraints View
09:47

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

USER_CONS_COLUMNS View
05:28

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

USER_TAB_COMMENTS & USER_COL_COMMENTS Views
03:42

The questions for Data Dictionary Views

Quiz 2
10 questions
+ – Creating, Using and Managing Sequences
8 lectures 30:54

A biref explanation for sequences and the usage with SQL.

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

How to create sequences with using SQL codes

Creating Sequences
06:42

Explains how to modify sequences with SQL codes

Modifying Sequences
02:47

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

Dropping Sequences
01:23

Explains how to use sequences with SQL codes in detail.

Using Sequences
Preview 09:08

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

Using Sequences As a Default Value
04:30

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

Sequence Caching
02:28

Explains how to query our sequences with sql codes.

User Sequences
02:29

This quiz is for Sequences..

Quiz 3
8 questions
+ – Creating, Using and Analyzing Synonyms
4 lectures 15:52

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

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

Explains how to create and drop synonyms with SQL Codes.

Creating & Dropping Synonyms
07:03

Explains how to use Synonyms with your SQL Codes.

Using Synonyms
02:34

Looks deep into user_synonyms by querying with SQL codes.

Analyzing USER_SYNONYMS
03:43

This Quiz is for Synonyms in SQL

Quiz 4
5 questions
+ – Understanding Indexes
8 lectures 41:50

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

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

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

Types of Indexes
02:32

Explains how to create indexes with or without SQL queries.

Creating Indexes
Preview 08:02

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

Creating Index on Table Creation
07:43

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

Function Based Indexes
04:52

The way and why for creating multiple indexes in your SQL

Multiple Indexes With Same Columns
09:04

How to drop an Index with just one SQL Code

Dropping Indexes
02:51

How to get information about indexes with a simle SQL Query

USER_INDEXES and USER_IND_COLUMNS Views
04:03

This quiz is for testing your knowledge about indexes

Quiz 5
10 questions
+ – Managing Views
10 lectures 51:33

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

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

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


Types Of Views
01:58

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


Creating Simple Views
12:25

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


Creating Complex Views
04:35

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


Modifying Views
03:37

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

Analyzing User Views
03:20

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

Performing DML Operations with Views
06:52

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

Using WITH CHECK OPTION Clause
11:06

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.

Preventing DML Operations on A View
02:22

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

Dropping Views
02:14

This quiz is a recap for views

Quiz 6
8 questions
+ – Materialized Views
7 lectures 42:56

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

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

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


Creating Materialized Views Part 1
06:32

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


Creating Materialized Views Part 2
04:54

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


Complex Materialized Views
03:49

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


Types of Refreshing Materialized Views
10:02

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

Refreshing Materialized Views Manually
10:39

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

Scheduling Periodic Refresh of Materialized Views
Preview 01:48

This quiz is a recap for Materialized Views.

Quiz 7
7 questions
+ – Using Advanced Subqueries
12 lectures 01:11:20

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

Using Subqueries as a Source
05:56

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

Scalar Subqueries
09:11

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

Multiple Column Subqueries
07:21

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

Correlated Subqueries
04:18

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

EXISTS Operator
05:16

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

NOT EXISTS Operator
04:56

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

Using WITH Clause
06:31

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

Using Recursive WITH Clause
05:33

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

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

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

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

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

Correlated Update
06:15

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

Correlated Delete
02:33

This quiz is recap for Advanced Subqueries Section

Quiz 8
7 questions
Requirements
  • Need to know SQL in basic level
  • SQL Developer
  • Oracle Database Software
Description

"One", "Enough", "Ultimate" Course to make you an "SQL Expert!".

Advance Your SQL Knowledge and Get Better Income From Your Job, like $100k.

Get Oracle's SQL Expert Certification.

Oracle has two Certification Exams for SQL;

The first one (SQL Fundamentals) covers the basic subjects (All of these subjects are covered in my first course.)

The second one (SQL Expert) covers more advanced subjects including the basic ones. (All the advanced subjects (and more) for this exam are covered in this course.)

All the subjects are explained in detail, and exampled as many as I can do with Oracle's HR schema. You can check the subjects from Oracle's related pages.

Now, you are looking at a course that will make you pass this exam.

  • You can ask any questions about this course from discussion board.

  • Your questions will be answered as soon as possible.

You can check my website for more details.

What are you going to learn from this course? 

  • Introducing Database Objects

  • Data Dictionary Views

  • Creating, Using and Managing Sequences

  • Creating, Using and Analyzing Synonyms

  • Understanding and Using Indexes

  • Managing Views

  • Materialized Views

  • Creating and Using Advanced Subqueries

  • Advanced Data Manipulation

  • Controlling Schema Objects)

  • Administering User Privileges and Roles

  • Hierarchical Queries (Tree Structure)

  • Writing Advanced Scripts

  • Generating Dynamic SQL Scripts

  • Analytical SQL Functions

  • Regular Expressions

  • And much more beyond these... (+Quizzes, +Bonus Lectures, +New Updates)...

More?

  • Hundreds of Examples

  • Professional Course Design,

  • Well-organised Content

  • In-Depth Subjects (All subjects are explained with all details)

  • Lifetime Author Support.

Who this course is for:
  • This SQL Course is meant for who already know SQL in basic level and want to improve it to Advance.
  • It is not for newbies. Newbies can take my beginner courses by checking the Intructor Page
Featured review
Seng Kong
Seng Kong ( 17 courses, 7 reviews )
6 months ago
This is my third course with Mr Omer. As usual, despite the thick accent in the lectures and occasional grammatical errors (that sometimes cause confusions) in the teaching materials, Mr Omer is very knowledgeable about SQL and going through his course will definitely make you a better SQL user. I recommend this course for anyone who needs a SQL refresher. Looking forward to the next course with Mr Omer.