Wondering how data professionals use SQL to solve business problems such as deduplicating data and creating rankings? Or calculating running totals or moving averages? If you're familiar with SQL, this course will teach you how to select, filter, join, join and group data. By the end of the course, you will be able write queries like a pro! You will learn how to use window functions, the SQL secret tool, to create queries for data engineering or analytics. It will be easy to learn how windows functions work and how flexible and efficient they can be used with flights data.