Hands On Training

SQL for Data Analysis

Future Learn

Course Features

Duration

4 weeks

Delivery Method

Online

Available on

Lifetime Access

Accessibility

Mobile, Desktop

Language

English

Subtitles

English

Level

Beginner

Effort

4 hours per week

Teaching Type

Self Paced

Course Description

Data analysis skills are expected to increase at four times the rate that the overall labour market. This area can help you expand your career options and increase your earning potential.

This course expands on the Data Analysis for Business ExpertTrack courses to increase your knowledge and help you use these skills professionally.

To group and modify functions in your database, expand your SQL knowledge.

These queries will enable you to focus on particular parts of your data set, and allow for deeper analysis of your business analytics.

It is impossible to draw a causal relationship between two variables solely on the association.

This course will teach you the difference between causation and correlation, as well as the dangers of making assumptions in this area. The course will also help you draw more solid conclusions from your data.

You will explore methods to determine relationships between items in your data sets, including Pearson's coefficient, which measures linear correlation between two variables.

Course Overview

Alumni Network

International Faculty

Post Course Interactions

Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

During the course we’ll be using DB Browser for SQLite and Excel

If you don’t have Excel, you might find this online version useful

What You Will Learn

Identify the correct syntax for basics SQL queries (filter, aggregate)

Identify the correct join type to use

Calculate correlation using Pearson's coefficient

Differentiate between correlation and causation

Target Students

Early-stage or aspiring data or business analysts looking to boost their qualitative and quantitative data analysis skills

Business professionals working in a role that requires data analytics skills

Business or arts graduates looking to start their first professional role by adding required quantitative skills such as data analysis

Course Content

Expand all sections

Module 1: Introduction to using SQL

Module 2: More advanced SQL skills

Module 3: Diagnostic analytics and relationships in data

Module 4: Communicating findings of data analysis

Course Instructors

Jacques Haasbroek

Certified Data Analyst

As a certified Data Analyst and holder of a Chartered Global Management Accountant designation I provide a unique set of skills in the fields of data, analytics, finance, and accounting.