Enamul K. B.
After 365:
Accounting Manager | JFE Engineering Corporation
See all reviews
Online Course
free
Advanced SQL
with
Martin Ganchev
and
Vladimir Saev
Gain a competitive advantage over other analysts with advanced SQL. Learn how to work with window functions, common table expressions, and temporary tables
14590 students already have enrolled
Skill level:
Basic
Duration:
7 hours
-
Lessons (2 hours)
-
Practice exams (25 minutes)
-
Projects (5 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
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 preprocessing
Your instructor
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
Software Engineer | Database Design & SQL Expert
Track record
Bringing real-world expertise from leading global companies
Academic background
Master's degree, Computer Engineering
Course OVERVIEW
Description
CPE Credits: 3
Field of Study: Information Technology
Delivery Method: QAS Self Study
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
- 2. SQL Common Table Expressions (CTEs)27 MinThis 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 FreeSQL Common Table Expressions (CTEs) - Introduction FreeExercise FreeThe Same CTE Task - an Alternative Solution FreeThe Same CTE Task - an Alternative Solution - Exercise FreeCoding exercise FreeCoding exercise FreeA WITH Clause with Multiple Subclauses - Part I FreeA WITH Clause with Multiple Subclauses - Part II - Exercise FreeA WITH Clause with Multiple Subclauses - Part II FreeReferring to CTEs in a WITH Clause FreeExercise FreeCoding exercise FreeCoding exercise FreeCoding exercise Free
- 3. SQL Temporary Tables17 MinAs 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 FreeSQL Temporary Tables - Application FreeExercise FreeSQL Temporary Tables - Application - Exercise FreeSQL Temporary Tables - Extra Features FreeExercise FreeSQL Temporary Tables - Extra Features - Exercise FreePractice exam FreeStudent Streaks Analysis with SQL Project Free
- 4. Course exam25 Min
Free preview
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
9 in 10
of our graduates landed a new AI & data job
after enrollment
96%
of our students recommend
365 Data Science.
94%
of AI and data science graduates
successfully change
or advance their careers.
ACCREDITED certificates
Craft a resume and LinkedIn profile you’re proud of—featuring certificates recognized by leading global
institutions.
Earn CPE-accredited credentials that showcase your dedication, growth, and essential skills—the qualities
employers value most.
How it WORKS
Student REVIEWS
