Advanced SQL

with Martin Ganchev and Vladimir Saev

4.9/5
(7)

Learn and apply MySQL window functions, common table expressions, and temporary tables to gain a competitive advantage over analysts using SQL.

20 lessons 2h
Start course

Course Overview

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.

20 High Quality Lessons
14 Practical Tasks
2 Hours of Video
Certificate of Achievement

Skills you will gain

data analysisProgrammingRelational DatabasesSQL

What You'll Learn

MySQL window functions, common table expressions, and temporary tables are highly sought-after tools in the arsenal of every database administrator, data scientist, or data analyst. By completing this course—packed with real-world scenarios and practical problems—you’ll understand and master the mechanics behind each one of these tools, and more precisely:

Get acquainted with and explore such window functions as ROW_NUMBER(), RANK(), DENSE_RANK(), LAG(), and LEAD()
Learn how to use MySQL aggregate functions in the context of window functions
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

Curriculum

Student feedback

4.9/5

7 ratings
5 stars
6 (86%)
4 stars
1 (14%)
3 stars
0 (0%)
2 stars
0 (0%)
1 star
0 (0%)
Filter by rating
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
Sort
  • Newest
  • Oldest
25.01.2023
I has been an enjoyable course that brings me the confidence to better manage my Sustainability Projects requiring knowledge of SQL. It is timely!
24.01.2023
Thank you for creating this Advanced SQL class.

“Unlike programming languages like Python or R, SQL doesn’t have a vast library of ready-made tools that allow you to retrieve the desired data by simply executing a short line of code. Mastering SQL requires a comprehensive understanding of the functionality of each of its tools and how to combine them to retrieve specific information from your database. And that’s precisely the challenge we present through the highly practical configuration of this course.”

Advanced SQL

with Martin Ganchev and Vladimir Saev

Start Course