Advanced SQL : The Ultimate Guide

Complete Your SQL Knowledge From Intermediate to Advanced Level. Get Your Advanced SQL Certification!..
4.5 (81 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,175 students enrolled Bestselling in SQL
$19
$200
90% off
Take This Course
  • Lectures 112
  • Length 9.5 hours
  • Skill Level Expert Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2016 English

Course Description

Course Updates:

  • 11-NOV-2016 : RANK & DENSE RANK Analytic Functions Lecture was added!
  • 01-NOV-2016 : ROW_NUMBER Analytic Function Lecture was added!
  • 31-SEP-2016 : What are the Analytical Functions Lecture was added!
  • 28-JUL-2016 : Regular Expressions: REGEXP_LIKE Function lecture was added!
  • 17-JUN-2016 : Refreshing Materialized Views lecture was added!
  • 16-MAY-2016 : Scheduling Periodic Refresh of Materialized Views lecture was added!
  • 25-APR-2016 : Types of Materialized Views lecture was added!

---

★★★★★ (High-rated Five-Star Course) ★★★★★

ONE, ENOUGH, ULTIMATE course for you!

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

My name is Omer Dagasan, I'm an Oracle Architect and a trainer at Oracle-Master. 

You can check the website for more details.

  • You can ask any questions about this course from discussion board.
  • Your questions will be answered immediately.

What are you going to learn from this course?

  • Introducing Database Objects
  • Data Dictionary Views
  • Sequences
  • Synonyms
  • Indexes
  • Views
  • Materialized Views
  • Advanced Subqueries
  • Advanced Data Manipulation
  • Controlling Schema Objects
  • Privileges
  • Hierarchical Retrieval
  • Writing Advanced Scripts
  • Analytical Functions
  • Regular Expressions
  • And much more..

More?

  • Hundreds of examples
  • Professional Course Design,
  • Well-organised Content
  • In-Depth Subjects (All subjects are explained with all details)
  • Lifetime Author Support.

Student Reviews Prove This Course's Worth

Those who have reviewed the course have pointed out that the instruction is clear and easy to follow, as well as thorough and highly informative. Other students enjoy the use of relevant examples throughout the course, as these make the content even easier to comprehend.

Many students had also taken other SQL courses in the past, only to find that this "Advanced SQL" course was their favorite. They enjoyed the structure of the content and the high quality audio/video(1080p).

Check out all of the great reviews in the review section ... a lot of happy students :-)

No Risk – Money-Back Guarantee

Finally, there is no risk. You can preview 10% of the course for free. Once you purchase the course, if for some reason you are not happy with the course, Udemy offers a 30-day money back guarantee.

So you have nothing to lose, sign up for this course and learn how to write SQL code easily from scratch to master level!

What are the requirements?

  • Need to know SQL in basic level
  • SQL Developer
  • Oracle Database Software

What am I going to get from this course?

  • Write Advanced SQL Codes Easily
  • Get a better job
  • Use SQL in deep like Analytical Functions, Regular Expressions, etc

What is the target audience?

  • 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 other course.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Introduction
01:23

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

08:43

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.

Section 2: Introducing Database Objects
09:37

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

06:20

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

Article

Sample codes that I have used along the Advanced SQL Course

Section 3: Data Dictionary Views
01:15

A brief introduction for Data Dictionary Views

01:12

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

03:18

Explains Dictionary Table with SQL query

01:30

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

09:14

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

05:11

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

05:04

Explains user_tab_colums view with SQL query.

09:47

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

05:38

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

03:42

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

Section 4: Sequences
01:27

A biref explanation for sequences and the usage with SQL

06:41

How to create sequences with using SQL codes

02:47

Explains how to modify sequences with SQL codes

01:23

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

09:08

Explains how to use sequences with SQL codes in detail.

04:30

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

02:28

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

02:29

Explains how to query our sequences with sql codes.

Section 5: Synonyms
02:32

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

07:03

Explains how to create and drop synonyms with SQL Codes.

02:34

Explains how to use Synonyms with your SQL Codes.

03:43

Looks deep into user_synonyms by querying with SQL codes.

Section 6: Indexes
02:43

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

02:32

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

08:02

Explains how to create indexes with or without SQL queries.

07:43

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

04:52

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

09:08

The way and why for creating multiple indexes in your SQL

02:51

How to drop an Index with just one SQL Code

04:04

How to get information about indexes with a simle SQL Query

Section 7: Views
03:04

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

01:58

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


12:34

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


04:35

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


03:37

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


03:20

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

06:52

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

11:06

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

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.

02:14

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

Section 8: Materialized Views
05:13

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

06:32

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


04:54

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


03:50

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


10:02

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


01:48

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

10:39

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

Section 9: Using Advanced Subqueries
05:56

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

09:14

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

07:21

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

04:18

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

05:16

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

04:56

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

06:31

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

05:33

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

07:06

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

06:24

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

02:34

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

06:15

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

Section 10: Advanced Data Manipulations
05:59

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

01:20

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

06:31

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

08:06

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

05:21

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

04:28

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

10:03

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

11:06

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


Lesson Keywords: sql, advanced sql, flashback operations.

04:02

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

Lesson Keywords: sql, advanced sql, purge operations.
01:28

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

Lesson Keywords: sql, advanced sql, tracking changes,
06:32

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

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

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

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

Section 11: Constraints (Controlling Schema Objects)
07:25

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


Lesson Keywords: sql, advanced sql, constraints.

03:51

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


Lesson Keywords: sql, advanced sql, constraints.

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.

03:57

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

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

02:40

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

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

03:02

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

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

02:34

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

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

03:04

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

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

13:48

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

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

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.

Section 12: Privileges
02:46

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

Lesson Keywords: sql, advanced sql, privileges.

03:55

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

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Omer Dagasan, Oracle Architect & Software Engineer

I have been working for more than 10 years on software development on many programming languages (like JAVA, C#, PHP, etc) and about 10 years on SQL- PL/SQL programming. And software project manager for more than 5 years.. For now, I am working on a database which has more than 15M active user as a project manager, and teaching SQL-PL/SQL courses...

Instructor Biography

Omer Faruk Ince, MSc Software & Computer Engineer

My name is Omer Faruk Ince. I have been working for more than 5 years in Software Projects in Government. Also I have a Masters Degree in computer science with around 15 years of experience in the IT industry.

Also I've worked in many freelance software project in IT industry. And I'm currently working for a fortune 500 company in the United Kingdom and leading the software architecture to this company. 

My areas of interests are mainly Database and Web Development and besides of these: 

 Big Data

Cloud Computing

Data Mining

Data Visualisation

 Data Security

Computer Security

Ready to start learning?
Take This Course