The Advanced SQL Course

The Advanced SQL Course, available at $89.99, has an average rating of 4.55, with 138 lectures, 2 quizzes, based on 2163 reviews, and has 49238 subscribers.

You will learn about Students will master advanced SQL functions and operations Analytical (Window) Functions Regular Expressions (RegEx) Materialized Views Group By Extensions Hierarchical Queries Common Table Expressions (CTEs) Advanced Subqueries Data Cleansing Data Manipulation This course is ideal for individuals who are Students aiming to take their SQL skills to the next level and master advanced SQL functions and operations or Individuals looking to pursue a career in a data related field It is particularly useful for Students aiming to take their SQL skills to the next level and master advanced SQL functions and operations or Individuals looking to pursue a career in a data related field.

Enroll now: The Advanced SQL Course

Summary

Title: The Advanced SQL Course

Price: $89.99

Average Rating: 4.55

Number of Lectures: 138

Number of Quizzes: 2

Number of Published Lectures: 138

Number of Published Quizzes: 2

Number of Curriculum Items: 140

Number of Published Curriculum Objects: 140

Original Price: ￡54.99

Quality Status: approved

Status: Live

What You Will Learn

Students will master advanced SQL functions and operations

Analytical (Window) Functions

Regular Expressions (RegEx)

Materialized Views

Group By Extensions

Hierarchical Queries

Common Table Expressions (CTEs)

Advanced Subqueries

Data Cleansing

Data Manipulation

Who Should Attend

Students aiming to take their SQL skills to the next level and master advanced SQL functions and operations

Individuals looking to pursue a career in a data related field

Target Audiences

Students aiming to take their SQL skills to the next level and master advanced SQL functions and operations

Individuals looking to pursue a career in a data related field

If you have some experience with SQL and want to develop your query skills to the next level from intermediate to advanced then this is the perfect course for you!

No downloads or software installation required. We will be using Oracle APEX which is a web-based application – you will be set up with your own virtual database hosted on the cloud! Although we will be using Oracle APEX the course has been designed to highlight key differences between some of the main Database Management Systems such as MySQL and Microsoft SQL Server, so what you learn in this course can be applied across all platforms supporting SQL.

This course will cover:

Analytical (Window) Functions

Regular Expressions (RegEx)

Materialized Views

Extensions to Group By

Correlated Subqueries

Common Table Expressions

Hierarchical Queries

Data Cleansing

Data Manipulation

The lectures in this course are arranged into short, bite-sized chunks. The course is designed to be comprehensive, but also concise in order to make the learning experience as easy as possible. Each section of the course has been specifically tailored to give the optimal learning experience, sections are packed with quizzes, assignments and real world type scenarios to give you an opportunity to develop your practical skills.

As your instructor I have 10+ years of professional experience consulting and working for a range of publicly listed companies. I have worked extensively across multiple database management systems including Oracle, MySQL and Microsoft SQL Server.

I hope to see you enrolled in the course!

Course Curriculum

Chapter 1: Introduction & Course Set Up

Lecture 1: Course Overview & Prerequisite Knowledge

Lecture 2: Oracle APEX Account Set Up

Lecture 3: Oracle APEX Overview

Lecture 4: Dataset Installation (Automatic)

Lecture 5: (Optional) Manual Data Installation

Lecture 6: Dataset Overview

Lecture 7: Dual Table

Lecture 8: Understanding Explain Plans In Oracle

Chapter 2: Data Cleansing And Manipulation

Lecture 1: Section Overview

Lecture 2: Coalesce and NVL

Lecture 3: Trim and Pad

Lecture 4: Greatest and Least

Lecture 5: Pivoting Tables

Lecture 6: Unpivoting Tables

Lecture 7: Assignment Question 1

Lecture 8: Assignment Question 1 Solution

Lecture 9: Assignment Question 1 Solution (SQL Code)

Lecture 10: Assignment Question 2

Lecture 11: Assignment Question 2 Solution

Lecture 12: Assignment Question 2 Solution (SQL Code)

Chapter 3: Regular Expressions (RegEx)

Lecture 1: Section Overview

Lecture 2: Regular Expressions And Metacharacters

Lecture 3: Pattern Matching With The . + ? * Metacharacters

Lecture 4: Pattern Matching With The d and w Metacharacters

Lecture 5: Pattern Matching With Intervals, Lists and Groups

Lecture 6: Pattern Matching Continued

Lecture 7: Introduction To RegEx Functions In Oracle

Lecture 8: REGEXP_LIKE & Assignment Questions

Lecture 9: REGEXP_INSTR & Assignment Questions

Lecture 10: REGEXP_SUBSTR & Assignment Questions

Lecture 11: REGEXP_REPLACE & Assignment Questions

Lecture 12: Class Metacharacters

Lecture 13: Concluding Thoughts On RegEx

Lecture 14: Useful External Resources

Chapter 4: Analytical (Window) Functions

Lecture 1: Section Overview

Lecture 2: Introduction to Analytical Functions

Lecture 3: An Introduction To The Over Clause

Lecture 4: The Over Clause – Partition By

Lecture 5: The Over Clause – Order By

Lecture 6: An Introduction To Window Frames

Lecture 7: Window Frame – Rows

Lecture 8: Window Frame – Range

Lecture 9: Window Frame – Default Behaviour

Lecture 10: Quick Note on Window Frames

Lecture 11: Main Types Of Window Functions

Lecture 12: Aggregate Functions – SUM, AVG, MAX, MIN and COUNT

Lecture 13: Analytical Functions – LAG, LEAD, NTILE and NTH_VALUE

Lecture 14: Ranking Functions – ROW_NUMBER, RANK and DENSE_RANK

Lecture 15: Distribution Functions – PERCENT_RANK and CUME_DIST

Lecture 16: Order of Execution

Lecture 17: Practice Scenario Walkthrough 1

Lecture 18: Practice Scenario Walkthrough 2

Lecture 19: Practice Scenario Walkthrough 3

Lecture 20: Practice Scenario Walkthrough 4

Lecture 21: Assignment Data Preparation

Lecture 22: Assignment Data Preparation (SQL Code)

Lecture 23: Assignment Question 1

Lecture 24: Assignment Question 1 Solution

Lecture 25: Assignment Question 1 Solution (SQL Code)

Lecture 26: Assignment Question 2

Lecture 27: Assignment Question 2 Solution

Lecture 28: Assignment Question 2 Solution (SQL Code)

Lecture 29: Assignment Question 3

Lecture 30: Assignment Question 3 Solution

Lecture 31: Note on Assignment Solution

Lecture 32: Assignment Question 3 Solution (SQL Code)

Lecture 33: BONUS (Running Totals): Assignment Question 4

Lecture 34: BONUS (Running Totals): Assignment Question 4 Solution (SQL Code)

Chapter 5: Group By Extensions

Lecture 1: Section Overview

Lecture 2: Introduction To Group By Extensions

Lecture 3: ROLLUP

Lecture 4: CUBE

Lecture 5: Quick Video On Why I Am Using NVL()

Lecture 6: GROUPING_ID Function

Lecture 7: Grouping Sets

Lecture 8: Combining Columns

Lecture 9: Useful External Resources

Lecture 10: Assignment Question 1

Lecture 11: Assignment Question 1 Solution

Lecture 12: Assignment Question 1 Solution (SQL Code)

Lecture 13: Assignment Question 2

Lecture 14: Assignment Question 2 Solution

Lecture 15: Assignment Question 2 Solution (SQL Code)

Lecture 16: Assignment Question 3

Lecture 17: Assignment Question 3 Solution

Lecture 18: Assignment Question 3 Solution (SQL Code)

Chapter 6: Hierarchical Queries

Lecture 1: Section Overview

Lecture 2: Introduction To Hierarchical Queries

Lecture 3: The Connect By & Start With Clauses

Lecture 4: The Level Pseudocolumn

Lecture 5: CONNECT_BY_ROOT & SYS_CONNECT_BY_PATH

Lecture 6: Ordering Your Hierarchical Query Results

Lecture 7: Formatting Your Hierarchical Query

Instructors

Malvik Vaghadia
Founder – Pathfinder Analytics

Rating Distribution

1 stars: 11 votes

2 stars: 28 votes

3 stars: 163 votes

4 stars: 801 votes

5 stars: 1160 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!