Online Course free
Advanced SQL for Data Engineering

Name: Advanced SQL for Data Engineering Course
Price: 36 USD

with Shashank Kalanithi

Master advanced SQL for data engineering skills by taking a masterclass from an industry expert

4.9

808 reviews on

Start for Free

4555 students already have enrolled

Skill level:

Advanced

Duration:

2 hours

Lessons (2 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

Accredited:

certificate

What You Learn

Learn data engineering fundamentals for career growth.
Gain expertise in advanced SQL for data storage, manipulation, and retrieval.
Work with data types like Array and JSON for complex data.
Understand database schemas and structures to optimize performance.
Acquire technical skills for data engineering interviews.

Topics & tools

SQLdata engineeringprogrammingdata preprocessing

Your instructor

Shashank Kalanithi

Data Engineer at Meta | YouTube Educator | Former Senior Data Analyst at Nordstrom

Track record

Bringing real-world expertise from leading global companies

Academic background

Associate's degree, Arts

Media and recognition

YouTube Content Creator
Recognized educator in SQL, Tableau, and Data Engineering
Creator of free and paid courses helping thousands transition into data careers

Ask Shashank a question

Course Overview

Accredited certificates

Course OVERVIEW

Description

CPE Credits: 3 Field of Study: Information Technology
Delivery Method: QAS Self Study

In this increasingly data-driven world, proficient SQL skills are highly valuable in numerous roles and industries. This Advanced SQL for Data Engineering course offers a unique blend of theory and practice to deepen your understanding of complex SQL concepts and database design topics. Master essential SQL skills for data engineering through hands-on exercises. Improve your database management, maintenance, modeling, and querying capabilities, and learn about timestamps, functions, advanced data types, etc.

Prerequisites

Any SQL environment (such as PostgreSQL, MySQL Workbench, SQLite, or an online SQL editor)
Strong understanding of SQL fundamentals, including joins, subqueries, and aggregations.
Familiarity with data engineering concepts (ETL, data pipelines) is helpful but not mandatory.

Advanced preparation

Curriculum

46 lessons 1 exam

1. Setting up the environment and overview of relational databases

14 Min

This section serves as both an introduction and foundation for the advanced SQL concepts you will encounter later in the course. It kicks off with a practical guide on setting up your SQL environment, providing you with step-by-step installation instructions to ensure you are well-prepared to start your SQL journey. The following lesson takes a step back to understand the fundamental framework of data storage and management: Relational Databases. We'll delve into how data is structured, related, and accessed within these systems, providing you with the context needed to understand more advanced topics. Next, we dive into the various subsets of SQL - Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL), and Data Control Language (DCL). Each of these categories plays a different but vital role in the management and manipulation of data, and understanding their roles and usage will be critical for your progression. Lastly, the section concludes with an in-depth look at SQL syntax. Good command of SQL syntax is crucial to write efficient and error-free SQL queries. This lesson will ensure you're well-versed in the language of SQL, providing a solid foundation upon which to build as the course progresses.

Introduction to the course Free

Coure GitHub repository Free

Setting up the environment Free

An overview of relational databases Free

DDL, DML, DQL, DCL Free

SQL syntax Free
2. Manipulating databases: Mastering essential SQL statements

18 Min

This part of the course equips you with the tools to manipulate databases using key SQL statements. Beginning with the creation of databases, we explore how to modify, add to, update, and delete data using various SQL commands. You'll learn how to combine operations using the MERGE statement and wrap up the section by learning how to safely remove data and tables with the DROP statement. This section will empower you to control your databases effectively.

Intro SQL statements Free

CREATE Free

ALTER Free

INSERT Free

UPDATE Free

DELETE Free

MERGE Free

DROP Free
3. Timing is everything: managing and manipulating DateTime in SQL

14 Min

It is time to delve into the world of DateTime in SQL. You'll understand the importance and varied types of DateTime data in SQL, how timezones affect data, and the use of intervals for calculations. By the end of this section, you'll be proficient in handling date and time-based data, a crucial aspect of any database management system.

DateTime intro Free

Different DateTime types Free

Timezones Free

Intervals Free
4. Complex data types: ENUMs, ARRAYs, Ranges, and Nested data in SQL

18 Min

We venture into the realm of complex data types in SQL. We'll start by learning about ENUMs and ARRAYs, and then move on to Ranges and Nested Data. This section will give you the knowledge and skills needed to handle a variety of data types, enhancing your database design and management capabilities.

ENUM Free

ARRAYs Free

RANGE Free

Nested data Free
5. Advanced query techniques: exploring OVER, JOINS, CASE and more in SQL

32 Min

Expand your querying capabilities by introducing advanced SQL techniques. You will explore the power of the OVER clause, dive deep into different types of JOINS, and learn to use CASE for conditional logic. With additional lessons on functions like COALESCE, CONCAT, and Recursive CTE, this section will elevate your SQL skills to a new level.

OVER Free

CROSS JOIN Free

LATERAL JOIN Free

CROSS JOIN LATERAL Free

COALESCE Free

CASE Free

CONCAT Free

Recursive CTE Free

Recursive CTE - second part Free
6. Optimizing data structures: The art and science of data normalization in SQL

9 Min

Focus on optimizing data structures through Data Normalization. You'll learn about the principles of data normalization and their importance in creating efficient, reliable databases. This section will equip you with the knowledge to design and implement database schemas effectively.

Data normatlization (1/3) Free

Data normatlization (2/3) Free

Data normatlization (3/3) Free

STAR schema Snowflake Free
7. Performance and control: Mastering stored procedures, temporary tables, and control structures in SQL

26 Min

Introduction to performance and control features in SQL. We'll learn about stored procedures and user-defined functions, temporary tables, and materialized views. Plus, we'll discuss SQL transactions and control structures. By the end of this section, you'll have a deeper understanding of database performance and control mechanisms in SQL.

Stored procedures and UDFs (1/3) Free

Stored procedures and UDFs (2/3) Free

Stored procedures and UDFs (3/3) Free

Temp table Free

Materialized view Free

Transactions Free

SQL structures Free
8. Practical tasks

11 Min

A series of practical tasks that will help you reinforce what you have learned in the Advanced SQL for Data Engineers course

Question 1 Free

Question 2 Free

Question 3 Free

Question 4 Free
9. Course exam

35 Min

Course exam Free

Free preview

1.1 Introduction to the course

1 min

1.2 Coure GitHub repository

1 min

1.3 Setting up the environment

3 min

1.4 An overview of relational databases

3 min

1.5 DDL, DML, DQL, DCL

3 min

1.6 SQL syntax

3 min

Start for free

Even after earning my master’s degree, I struggled with meeting the specific requirements companies sought in data roles. Enrolling in 365 Data Science and following the career paths helped me focus on high-demand topics like probability and advanced Python. These paths streamlined my preparation for interviews and boosted my skills for the job. With constantly updated content, 365 keeps me current in the field—I’ll keep using it as an essential career tool.

Vanessa V.

After 365: Analyst at Arctic Business Consulting

See all reviews

94%

of AI and data science graduates

successfully change

or advance their careers.

I joined 365 Data Science to learn Python, but it quickly became the foundation for a full transition into the data world. The engaging instructors, practical projects, and clear explanations helped me gain confidence and industry-standard skills. Within months, I was applying my new knowledge to my job, and within 18–20 months, I landed a role as a business analyst developer. 365 gave me both the skills and the confidence to grow in this fast-changing field.

Tomasz Z.

Before 365: Freelance research analyst

After 365: Business Analyst Developer | Lincoln Electric EMEA

See all reviews

9 in 10

people walk away career-ready

with practical data and AI skills.

I’ve been with 365 Data Science for about two years, starting with the Business Analyst course and now working on Data Engineering. My Excel skills improved so much they helped me land two promotions, and my coding knowledge—especially in Python—has grown dramatically. The courses go deeper, helping me understand the mechanisms behind technology. With a set schedule and commitment, the results are real. I highly recommend 365 and look forward to continuing my learning journey.