SQL for Data Engineers

What you'll learn

The SQL for Data Engineers course will help you become a better data engineer.

In this course, SQL for Data Engineers, you’ll gain the ability to use advanced SQL techniques for collecting, managing, and transforming raw data into usable information for data scientists and business analysts.

First, you’ll explore advanced SQL techniques, including using window functions, common table expressions, advanced join types, and dynamic SQL. Next, you’ll discover how to analyze and optimize SQL queries for performance by using execution plans and indexes, and using best practices for writing efficient, maintainable code and the roles played by query plan caching and cost-based optimization.

Then, you’ll learn how SQL can be used for data extraction, transformation, and loading into target systems and how data validation, cleanup, and aggregation can produce useful, conformant data. Finally, you’ll learn about big data environments and emerging technologies such as data lakes and data meshes.

When you’re finished with this course, you’ll have the skills and knowledge of SQL data engineering needed to find your place in this dynamic field.

Table of contents