Online Course
Advanced SQL

Name: Advanced SQL Course
Price: 36 USD

Gain a competitive advantage over other analysts with advanced SQL. Learn how to work with window functions, common table expressions, and temporary tables

4.8

862 reviews on

Start for free

16,192 students already enrolled

Skill level:

Basic

Duration:

7 hours

Lessons (2 hours)

Practice exams (25 minutes)

Projects (5 hours)

CPE credits:

3

CPE stands for Continuing Professional Education and represents the mandatory credits a wide range of professionals must earn to maintain their licenses and stay current with regulations and best practices. One CPE credit typically equals 50 minutes of learning. For more details, visit NASBA's official website: www.nasbaregistry.org

Accredited

certificate

What you learn

Acquire critical SQL skills for roles in data analytics and engineering.
Boost your resume with advanced data analysis skills in SQL.
Use common table expressions for precise data retrieval.
Simplify workflows with temporary tables in SQL.
Master window functions like ROW_NUMBER(), RANK(), DENSE_RANK(), and LAG().

Topics & tools

SQLRelational DatabasesProgrammingData AnalysisData EngineeringData PreprocessingSql

Your instructor

Martin Ganchev

Content Creator & Content Manager at 365 Data Science | Data Science Instructor

Track record

Bringing real-world expertise from leading global companies

Academic background

Master's degree, Economic and Social Sciences

Ask Martin a question

Vladimir Saev

Software Engineer | Database Design & SQL Expert

Track record

Bringing real-world expertise from leading global companies

Academic background

Master's degree, Computer Engineering

Ask Vladimir a question

Course overview

Accredited certificates

Course OVERVIEW

Description

CPE Credits: 3 Field of Study: Information Technology
Delivery Method: QAS Self Study

Unlike some other programming languages, SQL’s syntax is quite intuitive to understand and use, facilitating many to take their first steps toward working with relational database management systems (RDBMS). But knowing how to apply SQL’s basic instruments—such as aggregate functions, joins, and stored procedures—won’t allow you to reach its full potential. In this course, we’ll extensively cover window functions, common table expressions, and temporary tables to enrich your skill set and toolbox for handling relational databases and reveal plenty of options for data retrieval.

Prerequisites

Any SQL environment (such as SQLite, MySQL Workbench, or an online SQL editor).
Completion of an introductory SQL course is recommended.

Advanced preparation

Curriculum

33 lessons 45 exercises 1 project 2 exams

1. SQL Window Functions

76 min

When we say “window,” we mean a particular part of your database on which we want to apply some function. The functions to use can be ranking window functions (ROW_NUMBER(), RANK(), or DENSE_RANK()), value window functions (LAG() and LEAD()), or MySQL aggregate window functions applied in the context of window functions, such as MAX() or MIN().

76 min

When we say “window,” we mean a particular part of your database on which we want to apply some function. The functions to use can be ranking window functions (ROW_NUMBER(), RANK(), or DENSE_RANK()), value window functions (LAG() and LEAD()), or MySQL aggregate window functions applied in the context of window functions, such as MAX() or MIN().

SQL Window Functions - Section Introduction Free

SQL Window Functions - Introduction Free

The ROW_NUMBER() Ranking Window Function Free

Exercise

The ROW_NUMBER() Ranking Window Function - Exercise

Coding exercise

Coding exercise

Using Several Window Functions in a Query Free

Using Several Window Functions in a Query - Exercise

Coding exercise

Coding exercise

SQL Window Functions Syntax Free

Exercise

SQL Window Functions Syntax - Exercise

Coding exercise

PARTITION BY vs GROUP BY Free

PARTITION BY vs GROUP BY - Exercise

Coding exercise

Coding exercise

Coding exercise

The RANK() and DENSE_RANK() Window Functions Free

Exercise

The RANK() and DENSE_RANK() Window Functions - Exercise

Coding exercise

Coding exercise

Coding exercise

Using MySQL Ranking Window Functions and Joins Together

Using MySQL Ranking Window Functions and Joins Together - Exercise

Coding exercise

Coding exercise

The LAG() and LEAD() Value Window Functions

The LAG() and LEAD() Value Window Functions - Exercise

Coding exercise

Coding exercise

SQL Aggregate Functions and Window Functions - Part I

Exercise

SQL Aggregate Functions and Window Functions - Part I - Exercise

SQL Aggregate Functions and Window Functions - Part II

Exercise

SQL Aggregate Functions and Window Functions - Part II - Exercise

Coding exercise

Coding exercise
2. SQL Common Table Expressions (CTEs)

27 min

This section covers MySQL Common Table Expressions (CTEs)—a tool allowing you to obtain a temporary result set that you can use and reuse within the scope of a query. More precisely, we’ll explore single and multiple subclauses in a WITH clause and refer to already specified common table expressions in a WITH clause.

27 min

This section covers MySQL Common Table Expressions (CTEs)—a tool allowing you to obtain a temporary result set that you can use and reuse within the scope of a query. More precisely, we’ll explore single and multiple subclauses in a WITH clause and refer to already specified common table expressions in a WITH clause.

SQL Common Table Expressions (CTEs) - Section Introduction

SQL Common Table Expressions (CTEs) - Introduction

Exercise

The Same CTE Task - an Alternative Solution

The Same CTE Task - an Alternative Solution - Exercise

Coding exercise

Coding exercise

A WITH Clause with Multiple Subclauses - Part I

A WITH Clause with Multiple Subclauses - Part II - Exercise

A WITH Clause with Multiple Subclauses - Part II

Referring to CTEs in a WITH Clause

Exercise

Coding exercise

Coding exercise

Coding exercise
3. SQL Temporary Tables

17 min

As you progress as an SQL analyst, you’ll increasingly work with more extensive databases containing tables with millions of records. In other words, the queries you write can easily take a few minutes before returning the desired result. In such cases, you’ll look for tools like MySQL temporary tables to increase the efficiency of the data retrieval process. In this section, you’ll create your first MySQL Temporary Table and explore some of its features.

17 min

As you progress as an SQL analyst, you’ll increasingly work with more extensive databases containing tables with millions of records. In other words, the queries you write can easily take a few minutes before returning the desired result. In such cases, you’ll look for tools like MySQL temporary tables to increase the efficiency of the data retrieval process. In this section, you’ll create your first MySQL Temporary Table and explore some of its features.

SQL Temporary Tables - Introduction

SQL Temporary Tables - Application

Exercise

SQL Temporary Tables - Application - Exercise

SQL Temporary Tables - Extra Features

Exercise

SQL Temporary Tables - Extra Features - Exercise

Practice exam

Student Streaks Analysis with SQL Project
4. Course exam

25 min

25 min

Course exam

Free lessons

1.1 SQL Window Functions - Section Introduction

1 min

1.2 SQL Window Functions - Introduction

2 min

1.3 The ROW_NUMBER() Ranking Window Function

9 min

1.8 Using Several Window Functions in a Query

3 min

1.12 SQL Window Functions Syntax

4 min

1.16 PARTITION BY vs GROUP BY

6 min

Start for free

When I began my master’s program, I felt lost—statistical jargon was overwhelming, and Python and R seemed impossible. 365 Data Science changed that. The clear explanations, structured courses, and practical projects helped me build a solid foundation in statistics, programming, and SQL. I not only completed my degree but also advanced to a better role. 365 made complex topics approachable and gave me skills that boosted both my academic and professional growth.

Enamul K. B.

After 365: Accounting Manager | JFE Engineering Corporation

See all reviews

9 in 10

of our graduates landed a new AI & data job

after enrollment

So far, I am in love with this course. Being taught in a very clear, organized manner. And the medal is to the recap questions because they really come through in solidifying one's understanding.

Isaac K.

See all reviews

96%

of our students recommend

365 Data Science.

The 365 Data Science program helped me transition to a new role where I apply Python, Excel, and Power BI daily. I analyzed mystery shopper data at work using skills from the courses, built stunning visuals, and presented insights to my team. The practical examples showed me how things work in real life—not just in theory. I’ve recommended 365 to friends and colleagues because it genuinely prepares you for real-world data tasks.