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.
Author Name: Gerald Britton
Author Description:
Gerald Britton is a Pluralsight author and expert on Python programming practices and Microsoft SQL Server development and administration. 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).