Advanced SQL

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 7508 students
Limited-Time Offer
20% off

$99.00

$79.00

Lifetime access

01 Days
:
18 Hours
:
49 Minutes
:
40 Seconds
Get 20% OFF
14-Day Money-Back Guarantee

What you get:

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

Advanced SQL

Limited-Time Offer
20% off

$99.00

$79.00

Lifetime access

01 Days
:
18 Hours
:
49 Minutes
:
40 Seconds
Get 20% OFF
14-Day Money-Back Guarantee

What you get:

  • 7 hours of content
  • 16 Downloadable resources
  • Interactive exercises
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement
Limited-Time Offer
20% off

$99.00

$79.00

Lifetime access

01 Days
:
18 Hours
:
49 Minutes
:
40 Seconds
Get 20% OFF
14-Day Money-Back Guarantee

What you get:

  • 7 hours of content
  • 16 Downloadable resources
  • Interactive exercises
  • 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.

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.4 Using Several Window Functions in a Query

3 min

SQL Window Functions Syntax

1.5 SQL Window Functions Syntax

4 min

PARTITION BY vs GROUP BY

1.6 PARTITION BY vs GROUP BY

6 min

Curriculum

  • 1. SQL Window Functions
    20 Lessons 72 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
    1 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
    1 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
    1 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
    1 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 - Exercise Read now
    1 min
    SQL Temporary Tables - Extra Features
    7 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 the European Commission

14 Courses

26797 Reviews

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

What Our Learners Say

03.10.2024
27.09.2024

365 Data Science Is Featured at

Our top-rated courses are trusted by business worldwide.

Recommended Courses