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.

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.

• Course Overview 1min
• SQL Querying Techniques for Data Engineers 13mins
• SQL Query Optimization 15mins
• Data Workflows for Data Engineering 10mins
• SQL Meets Big Data 11mins