SQL for Data Analysis

Do you want to expand your career options?

The demand for data analysis skills is projected to grow at over four times the rate of the overall labour market. Expand your career options and earning potential by improving your knowledge and skills in this area.

This course builds on the previous two within this Data Analysis for Business ExpertTrack to round off your knowledge and prepare you to use these skills in a professional environment.

Filter and aggregate data with basic SQL queries

Expand your SQL knowledge to group and modify functions that appear within your database.

Understanding these queries will allow you to hone in on specific parts of your data set and carry out deeper interrogation of your business analytics.

Differentiate between correlation and causation

It’s impossible to deduce a causal relationship between two variables purely based on the association.

On this course, you’ll learn the difference between correlation and causation, and the potential pitfalls in making assumptions in this area. You will then explore ways to draw firmer conclusions from your data.

Calculate correlation using Pearson’s coefficient

You’ll explore techniques to measure relationships between items within your datasets, including Pearson’s coefficient which measures linear correlation between two data variables.

This course is for professionals who require data analytics skills in the workplace including:

• 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.

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.

We recommend you use a computer to access this course.

• Introduction to SQL
• Introduction to the course
• Fundamentals of databases
• Working with SQLite
• Wrap-up
• Querying and manipulating data in SQL
• Introduction to querying and manipulating data in SQL
• Creating tables in SQLite
• Querying a database
• Wrap-up
• Table joins in SQL
• Introduction to table joins in SQL
• Joining tables in SQL
• How to implement joins in SQLite
• Wrap-up
• Diagnostic analytics
• Introduction to diagnostic analytics
• Diagnostic analysis techniques
• Causation and correlation in data analysis
• Wrap-up