Advanced SQL for Data Engineering

with Shashank Kalanithi
4.8/5
(204)

This advanced SQL course is ideal for data engineer experts, database administrators, data scientists, analysts, software developers, and IT professionals who wish to enhance their data management and analysis skills. The only requirement is to have foundational SQL knowledge.

2 hours 46 lessons
Start course
46 High Quality Lessons
0 Practical Tasks
2 Hours of Content
Certificate of Achievement

Course Overview

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.

Topics covered

SQL

What You'll Learn

This Advanced SQL for Data Engineering course will ensure you’re well-equipped to tackle complex data challenges and become a valuable asset in any data-centric role. Master advanced SQL techniques and sought-after skills for data engineer experts.

Data storage, manipulation, and retrieval
Timestamp formats, functions, and applications
Advanced SQL data types, such as Array and JSON
Database schemas and structures
Advanced SQL functions

Curriculum

  • Setting up the environment and overview of relational databases Free
    6 Lessons 13 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
  • Manipulating databases: Mastering essential SQL statements
    8 Lessons 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
    CREATE
    ALTER
    INSERT
    UPDATE
    DELETE
    MERGE
    DROP
  • Timing is everything: managing and manipulating DateTime in SQL
    4 Lessons 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
    Different DateTime types
    Timezones
    Intervals
  • Complex data types: ENUMs, ARRAYs, Ranges, and Nested data in SQL
    4 Lessons 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
    ARRAYs
    RANGE
    Nested data
  • Advanced query techniques: exploring OVER, JOINS, CASE and more in SQL
    9 Lessons 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
    CROSS JOIN
    LATERAL JOIN
    CROSS JOIN LATERAL
    COALESCE
    CASE
    CONCAT
    Recursive CTE
    Recursive CTE - second part
  • Optimizing data structures: The art and science of data normalization in SQL
    4 Lessons 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)
    Data normatlization (2/3)
    Data normatlization (3/3)
    STAR schema Snowflake
  • Performance and control: Mastering stored procedures, temporary tables, and control structures in SQL
    7 Lessons 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)
    Stored procedures and UDFs (2/3)
    Stored procedures and UDFs (3/3)
    Temp table
    Materialized view
    Transactions
    SQL structures
  • Practical tasks
    4 Lessons 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
    Question 2
    Question 3
    Question 4

Student feedback

4.8/5

204 ratings
5 stars
169 (83%)
4 stars
22 (11%)
3 stars
12 (6%)
2 stars
1 (0%)
1 star
0 (0%)
Filter by rating
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
Sort
  • Newest
  • Oldest
05.06.2023
Good as an overview of each topic, but doesn't go into great detail on use cases or further explanations on how to apply them in a real world situation.
09.11.2023
Covered some new concepts of SQL such as loops, transaction, procedure, function etc. which can be really handy and useful while working on SQL.
04.06.2023
Simply awesome! The teacher explains all the concepts, from basic to advanced ones really well, and makes the course enjoyable.
18.03.2024
The complex topics are thought such an effective manner so that I can understand it easily and grasp it quickly
12.07.2023
the speaker talks fast, and most of the time I can't follow. had to do replays just to understand the course.
  • 1
  • 2
  • 3
  • 4
  • ...
  • 6
Shashank Kalanithi

“By taking this course, you'll not only improve your database management and querying capabilities, you'll also gain a strong foundation for pursuing more advanced topics in SQL and database design.”

Shashank Kalanithi

Data Engineer at Meta

Courses You May Like

Advanced SQL for Data Engineering

with Shashank Kalanithi

Start Course