If data is the new oil, then these analytical tools empower citizen data analysts to process that oil into a wide variety of useful products. In order to access that data in its rawest form, there’s no substitute for learning SQL.
Learn the fundamentals of SQL from the basics of relational databases to the core knowledge required for effective queries, such as select statements, joins and where clauses.
1. Understanding SQL Databases
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2. Selecting and Filtering Data with SQL
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.
Joining and Aggregating Data
Learn how to join data from multiple sources and aggregate data to a different degree of granularity.
1. Joining Data with SQL
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.
2. Aggregating Data with SQL
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.
Advanced SQL Functions
Learn advanced SQL functionality such as manipulating data types and performing conditional functions.
1. Data Manipulation with SQL
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2. Conditional Functions in SQL
In this course, we learn how to use conditional functions in SQL. These enable us to modify the output of our results based on whether they meet certain criteria. To this we’ll cover the case, coalesce and nullif functions.