SQL

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.

Categories

  • SQL Essentials
  • Joining and Aggregating Data
  • Advanced SQL Functions

Courses

SQL Essentials

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.

01 understandingsqldatabases

1. Understanding SQL Databases

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

12 Lessons
0 minutes
Created with Sketch. Beginner
CPD Credits
02 selecting and filtering datawithsql

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.

Coming Soon
Created with Sketch. Beginner
CPD Credits

Work smarter with full access to our full library of courses

Joining and Aggregating Data

Learn how to join data from multiple sources and aggregate data to a different degree of granularity.

03 joiningdatawithsql

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.

Coming Soon
Created with Sketch. Intermediate
CPD Credits
Sql coming soon

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.

Coming Soon
Created with Sketch. Intermediate
CPD Credits

Advanced SQL Functions

Learn advanced SQL functionality such as manipulating data types and performing conditional functions.

Sql coming soon

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.

Coming Soon
Created with Sketch. Advanced
CPD Credits
Sql coming soon

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.

Coming Soon
Created with Sketch. Advanced
CPD Credits

Work smarter with full access to our full library of courses