Advanced SQL

Name: Advanced SQL Course
Price: 36 USD

4.8/5

(540)

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 12780 students

Start for Free

What you get:

7 hours of content
23 Interactive exercises
22 Coding 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

Start for Free

What you get:

7 hours of content
23 Interactive exercises
22 Coding 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

Start for Free

What you get:

7 hours of content
23 Interactive exercises
22 Coding 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.

Learn for Free

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

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
7 min
SQL Aggregate Functions and Window Functions - Part II - Exercise Read now
2 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 AnalysisData EngineeringData PreprocessingProgramming

Tools & Technologies

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.

Meet Your Instructor

Martin Ganchev

Worked at

15 Courses

37488 Reviews

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