Advanced SQL

with Martin Ganchev and Vladimir Saev
4.8/5
(518)

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

7 hours of content 11900 students

$99.00

Lifetime access

Buy now
14-Day Money-Back Guarantee

What you get:

  • 7 hours of content
  • 23 Interactive exercises
  • 29 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

Advanced SQL

A course by Martin Ganchev and Vladimir Saev

$99.00

Lifetime access

Buy now
14-Day Money-Back Guarantee

What you get:

  • 7 hours of content
  • 23 Interactive exercises
  • 29 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

$99.00

Lifetime access

Buy now

$99.00

Lifetime access

Buy now
14-Day Money-Back Guarantee

What you get:

  • 7 hours of content
  • 23 Interactive exercises
  • 29 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

What You Learn

  • Acquire critical SQL skills that will help you land a job as a data analyst, data scientist, or data engineer
  • Become an SQL pro and boost your resume with advanced data analysis skills
  • Improve your data retrieval precision by using common table expressions
  • Simplify and save time in your work with temporary tables
  • Learn how to combine newly-learned tools with joins and aggregate functions
  • Get acquainted with and explore such window functions as ROW_NUMBER(), RANK(), DENSE_RANK(), LAG(), and LEAD()Install MySQL Server and MySQL Workbench on your machine

Top Choice of Leading Companies Worldwide

Industry leaders and professionals globally rely on this top-rated course to enhance their skills.

Course Description

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.

See More

Learn for Free

SQL Window Functions - Section Introduction

1.1 SQL Window Functions - Section Introduction

1 min

SQL Window Functions - Introduction

1.2 SQL Window Functions - Introduction

2 min

The ROW_NUMBER() Ranking Window Function

1.3 The ROW_NUMBER() Ranking Window Function

9 min

Using Several Window Functions in a Query

1.6 Using Several Window Functions in a Query

3 min

SQL Window Functions Syntax

1.8 SQL Window Functions Syntax

4 min

PARTITION BY vs GROUP BY

1.11 PARTITION BY vs GROUP BY

6 min

Interactive Exercises

Practice what you've learned with coding tasks, flashcards, fill in the blanks, multiple choice, and other fun exercises.

Practice what you've learned with coding tasks, flashcards, fill in the blanks, multiple choice, and other fun exercises.

true-false exercise
single-choice exercise
multiple-choice exercise
flashcards exercise
fill-blank-typing exercise
fill-blank-selection exercise
order exercise
categorize exercise

Curriculum

  • 1. SQL Window Functions
    20 Lessons 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 Read now
    1 min
    SQL Window Functions - Introduction
    2 min
    The ROW_NUMBER() Ranking Window Function
    9 min
    The ROW_NUMBER() Ranking Window Function - Exercise Read now
    1 min
    Using Several Window Functions in a Query
    3 min
    Using Several Window Functions in a Query - Exercise Read now
    2 min
    SQL Window Functions Syntax
    4 min
    SQL Window Functions Syntax - Exercise Read now
    1 min
    PARTITION BY vs GROUP BY
    6 min
    PARTITION BY vs GROUP BY - Exercise Read now
    2 min
    The RANK() and DENSE_RANK() Window Functions
    8 min
    The RANK() and DENSE_RANK() Window Functions - Exercise Read now
    1 min
    Using MySQL Ranking Window Functions and Joins Together
    8 min
    Using MySQL Ranking Window Functions and Joins Together - Exercise Read now
    1 min
    The LAG() and LEAD() Value Window Functions
    9 min
    The LAG() and LEAD() Value Window Functions - Exercise Read now
    2 min
    SQL Aggregate Functions and Window Functions - Part I
    6 min
    SQL Aggregate Functions and Window Functions - Part I - Exercise Read now
    1 min
    SQL Aggregate Functions and Window Functions - Part II - Exercise Read now
    2 min
    SQL Aggregate Functions and Window Functions - Part II
    7 min
  • 2. SQL Common Table Expressions (CTEs)
    8 Lessons 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 Read now
    1 min
    SQL Common Table Expressions (CTEs) - Introduction
    7 min
    The Same CTE Task - an Alternative Solution
    2 min
    The Same CTE Task - an Alternative Solution - Exercise Read now
    1 min
    A WITH Clause with Multiple Subclauses - Part I
    6 min
    A WITH Clause with Multiple Subclauses - Part II - Exercise Read now
    1 min
    A WITH Clause with Multiple Subclauses - Part II
    5 min
    Referring to CTEs in a WITH Clause
    4 min
  • 3. SQL Temporary Tables
    5 Lessons 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
    3 min
    SQL Temporary Tables - Application
    5 min
    SQL Temporary Tables - Application - Exercise Read now
    1 min
    SQL Temporary Tables - Extra Features
    7 min
    SQL Temporary Tables - Extra Features - Exercise Read now
    1 min

Topics

SQLRelational DatabasesProgrammingdata analysis

Tools & Technologies

sql

Course Requirements

  • Highly recommended to take the SQL course first
  • You will need to install MySQL Workbench

Who Should Take This Course?

Level of difficulty: Beginner

  • Aspiring data analysts, data scientists, data engineers who want to improve their job prospects
  • Existing data analysts, data scientists, data engineers who want to become proficient in SQL and learn advanced SQL skills
  • Data professionals who strive for SQL proficiency

Exams and Certification

A 365 Data Science Course Certificate is an excellent addition to your LinkedIn profile—demonstrating your expertise and willingness to go the extra mile to accomplish your goals.

Exams and certification

Meet Your Instructor

Martin Ganchev

Martin Ganchev

Worked at

15 Courses

36281 Reviews

534128 Students

Martin began working with 365 in 2016 as the company’s second employee. Martin’s resilience, hard-working attitude, attention to detail, and excellent teaching style played an instrumental role in 365’s early days. He authored some of the firm’s most successful courses. And besides teaching, Martin dreams about becoming an actor. In September 2021, he enrolled in an acting school in Paris, France.

See More

What Our Learners Say

Omar El Awad
Omar El Awad
25.12.2024

365 Data Science Is Featured at

Our top-rated courses are trusted by business worldwide.

Recommended Courses

Introduction to Tableau

Introduction to Tableau

with Ned Krastev
4.8/5
(1,720)
3 hours of content
Introduction to R Programming

Introduction to R Programming

with Simona Dobreva, Iliya Valchanov
4.8/5
(798)
6 hours of content
Data Preprocessing with NumPy

Data Preprocessing with NumPy

with Viktor Mehandzhiyski
4.8/5
(1,041)
8 hours of content
Introduction to Data and Data Science
popular

Introduction to Data and Data Science

with Martin Ganchev, Iliya Valchanov
4.8/5
(15,966)
2 hours of content
Data Cleaning and Preprocessing with pandas

Data Cleaning and Preprocessing with pandas

with Martin Ganchev
4.7/5
(1,688)
3 hours of content
Introduction to Business Analytics

Introduction to Business Analytics

with Randy Rosseel
4.8/5
(1,107)
6 hours of content
Data Analysis with Excel Pivot Tables

Data Analysis with Excel Pivot Tables

with Ned Krastev
4.8/5
(4,058)
2 hours of content
Credit Risk Modeling in Python
bestseller

Credit Risk Modeling in Python

with Nikolay Georgiev
4.9/5
(395)
8 hours of content
SQL + Tableau + Python

SQL + Tableau + Python

with Martin Ganchev
4.8/5
(445)
5 hours of content
Statistics
popular

Statistics

with Iliya Valchanov
4.8/5
(5,344)
5 hours of content
Introduction to Excel

Introduction to Excel

with Ned Krastev
4.8/5
(9,971)
6 hours of content
Starting a Career in Data Science: Project Portfolio, Resume, and Interview Process

Starting a Career in Data Science: Project Portfolio, Resume, and Interview Process

with Ken Jee
4.8/5
(790)
4 hours of content
SQL + Tableau

SQL + Tableau

with Martin Ganchev
4.8/5
(741)
5 hours of content
Time Series Analysis with Python

Time Series Analysis with Python

with Viktor Mehandzhiyski
4.8/5
(516)
7 hours of content
Power BI

Power BI

with Dimitar Shutev
4.8/5
(2,949)
8 hours of content
Customer Analytics in Python

Customer Analytics in Python

with Nikolay Georgiev, Elitsa Kaloyanova
4.9/5
(378)
10 hours of content
Python for Finance

Python for Finance

with Martin Ganchev, Ned Krastev
4.8/5
(421)
6 hours of content
Machine Learning in Python

Machine Learning in Python

with Iliya Valchanov
4.8/5
(1,518)
7 hours of content
Data Strategy
popular

Data Strategy

with Bernard Marr
4.8/5
(3,187)
6 hours of content
Fashion Analytics with Tableau

Fashion Analytics with Tableau

with Elitsa Kaloyanova
4.8/5
(245)
3 hours of content
Data Literacy

Data Literacy

with Olivier Maugain
4.8/5
(1,902)
5 hours of content
AI Applications for Business Success

AI Applications for Business Success

with Horia Mărgărit
4.7/5
(355)
2 hours of content
Linear Algebra and Feature Selection

Linear Algebra and Feature Selection

with Aleksandar Samsiev, Ivan Manov
4.7/5
(355)
3 hours of content
Machine Learning in Excel
top-rated

Machine Learning in Excel

with Ivan Kitov
4.9/5
(537)
7 hours of content
Data-Driven Business Growth

Data-Driven Business Growth

with Davis Balaba, Tina Huang
4.7/5
(350)
4 hours of content
Customer Churn Analysis with SQL and Tableau

Customer Churn Analysis with SQL and Tableau

with Elitsa Kaloyanova
4.8/5
(248)
3 hours of content
Customer Engagement Analysis with SQL and Tableau
top-rated

Customer Engagement Analysis with SQL and Tableau

with Hristina Hristova
4.9/5
(135)
5 hours of content
Mastering Key Performance Indicators (KPIs)

Mastering Key Performance Indicators (KPIs)

with Bernard Marr
4.8/5
(502)
3 hours of content
Sign-Up Flow Optimization Analysis with SQL and Tableau

Sign-Up Flow Optimization Analysis with SQL and Tableau

with Ivan Manov
4.9/5
(84)
4 hours of content
ChatGPT for Data Science

ChatGPT for Data Science

with Elitsa Kaloyanova
4.8/5
(239)
2 hours of content
Growth Analysis with SQL, Python, and Tableau

Growth Analysis with SQL, Python, and Tableau

with Nikola Pulev
4.9/5
(55)
4 hours of content
Statistical Tests in Sales and Marketing

Statistical Tests in Sales and Marketing

with Olivier Maugain, Aastik Malhotra, Ivan Manov
4.9/5
(110)
3 hours of content