Data Preparation with SQL

Data doesn't have to be just for technically minded analysts. These courses teach you all the non-technical principles of understanding and working with data in your company.

Learn the key principles of data preparation in order to format your data in a consistent manner, ready for analysis. You'll gain a solid understanding of this critical process, ensuring that your insights are built on solid foundations.

Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.

This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.

This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.

Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.

In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.