Advanced SQL for Data Engineering

with Shashank Kalanithi
4.8/5
(279)

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

2 hours of content 3123 students
Start for free

What you get:

  • 2 hours of content
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

Advanced SQL for Data Engineering

Start for free

What you get:

  • 2 hours of content
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement
Start for free

What you get:

  • 2 hours of content
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

What You Learn

  • Learn data engineering fundamentals that will help you impress hiring managers
  • Benefit from the knowledge of an experienced data engineer
  • Gain expertise in sophisticated SQL techniques for data storage, manipulation, and retrieval to handle data efficiently
  • Learn to work with advanced data types such as Array and JSON to manage and query non-traditional data
  • Develop a solid understanding of database schemas and structures to optimize database performance
  • Acquire key technical data engineering skills and approach data engineering interview questions with confidence

Top Choice of Leading Companies Worldwide

Industry leaders and professionals globally rely on this top-rated course to enhance their skills.

Course Description

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.

Learn for Free

Introduction to the course

1.1 Introduction to the course

1 min

Coure GitHub repository

1.2 Coure GitHub repository

1 min

Setting up the environment

1.3 Setting up the environment

3 min

An overview of relational databases

1.4 An overview of relational databases

3 min

DDL, DML, DQL, DCL

1.5 DDL, DML, DQL, DCL

3 min

SQL syntax

1.6 SQL syntax

3 min

Curriculum

  • 1. Setting up the environment and overview of relational databases
    6 Lessons 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
    1 min
    Coure GitHub repository Read now
    1 min
    Setting up the environment
    3 min
    An overview of relational databases
    3 min
    DDL, DML, DQL, DCL
    3 min
    SQL syntax
    3 min
  • 2. 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
    1 min
    CREATE
    5 min
    ALTER
    2 min
    INSERT
    2 min
    UPDATE
    1 min
    DELETE
    2 min
    MERGE
    4 min
    DROP
    1 min
  • 3. 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
    5 min
    Different DateTime types
    2 min
    Timezones
    6 min
    Intervals
    1 min
  • 4. 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
    6 min
    ARRAYs
    4 min
    RANGE
    3 min
    Nested data
    5 min
  • 5. 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
    9 min
    CROSS JOIN
    1 min
    LATERAL JOIN
    4 min
    CROSS JOIN LATERAL
    3 min
    COALESCE
    4 min
    CASE
    3 min
    CONCAT
    2 min
    Recursive CTE
    2 min
    Recursive CTE - second part
    4 min
  • 6. 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)
    3 min
    Data normatlization (2/3)
    2 min
    Data normatlization (3/3)
    2 min
    STAR schema Snowflake
    2 min
  • 7. 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)
    4 min
    Stored procedures and UDFs (2/3)
    2 min
    Stored procedures and UDFs (3/3)
    1 min
    Temp table
    3 min
    Materialized view
    3 min
    Transactions
    6 min
    SQL structures
    7 min
  • 8. 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
    2 min
    Question 2
    5 min
    Question 3
    1 min
    Question 4
    3 min

Topics

SQL

Tools & Technologies

sql

Course Requirements

  • Highly recommended to take the SQL and Intro to Data Engineering courses first

Who Should Take This Course?

Level of difficulty: Advanced

  • Aspiring data engineers
  • People who want to work in data engineering, data analysis, data science or a related field

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.

Exams and certification

Meet Your Instructor

Shashank Kalanithi

Shashank Kalanithi

Data Engineer at

2 Courses

415 Reviews

5435 Students

Shashank Kalanithi is data engineer at Meta. His previous experience includes being a senior data analyst at the fashion retailer Nordstrom, where he worked on ML solutions to help augment the data team’s capabilities. He designed tools and dashboards that optimize the workflow and gather valuable data on the company’s numerous locations. Shashank also runs his own data analyst service where he helps companies organize, study, and extract insights to increase in-house efficiency and profitability. His YouTube channel, which he started in 2020, has accumulated over 149K subscribers.

What Our Learners Say

365 Data Science Is Featured at

Our top-rated courses are trusted by business worldwide.