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