Kubicle Path

Data Preparation with SQL

Learn how to use SQL to extract and manipulate valuable Business data. You'll learn about database structures data and how SQL queries can help you answer wide range of questions.

10.5 HOURS
10 CPE / CPD Credits
1
Data Literacy

Introduction to Data and Databases

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.
Course
90 MINS
1 CPE / CPD Credits
2
Data Literacy

Introduction to Data Preparation

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.
Course
60 MINS
1 CPE / CPD Credits
3
SQL

Understanding SQL Databases

Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
Course
120 MINS
1.5 CPE / CPD Credits
4
SQL

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.
Course
90 MINS
1.5 CPE / CPD Credits
5
SQL

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.
Course
90 MINS
2 CPE / CPD Credits
6
SQL

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.
Course
90 MINS
1.5 CPE / CPD Credits
7
SQL

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.
Course
90 MINS
1.5 CPE / CPD Credits
Kubicle Certified Diploma:

Data Preparation with SQL

10.5 HOURS
10 CPE / CPD Credits

Get Started Today

Learning paths offer a guided experience, with relevant content selected by our content experts.
Kubicle Certified Diploma
Comprehensive Courses
Hands-on Projects