SQL for Data Analysis

Course Cover
compare button icon
Offer Percent Icon

1 Coupon Available

Login To View All

Course Features

icon

Duration

4 weeks

icon

Delivery Method

Online

icon

Available on

Lifetime Access

icon

Accessibility

Mobile, Desktop

icon

Language

English

icon

Subtitles

English

icon

Level

Beginner

icon

Effort

4 hours per week

icon

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

projects-img

Alumni Network

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

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 Instructors

Author Image

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.
Course Cover
Offer Percent Icon

1 Coupon Available
Get upto 30% Discount