Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

SQL for Data Engineers

Level up your skills for using SQL with relational databases and big data systems with techniques for analysis, query optimization, workflow integration, and advanced technologies like streaming, data lakes, and data meshes.

Gerald Britton - Pluralsight course - SQL for Data Engineers
by Gerald Britton

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

About the author

Gerald Britton - Pluralsight course - SQL for Data Engineers
Gerald Britton

Gerald is a multiple-year of the Microsoft MVP award, Gerald has led introductory classes in Python and SQL for industry-sponsored events at Ryerson University, Toronto and the University of Toronto (his alma mater). 

More Courses by Gerald