Data analytics certificate

Live Instructor Led - Advanced SQL for Analysts

£1,699

8 hours

In this course, you will:

Work with messy and unstructured data by using functions, RegEx, and conditional fields

Combine multiple data sources and develop hierarchical queries

Design and build datasets that can be used for business analysis, dashboards, or data science

Next course starts May 10, 09:30 UK time
Enroll now

Live Instructor Led - Advanced SQL for Analysts

Next course starts
May 10 09:30 UK Time

8 hours

£1,699

After this course, you will able to:

Work with messy and unstructured data by using functions, RegEx, and conditional fields.

Combine multiple data sources and develop hierarchical queries

Design and build datasets that can be used for business analysis, dashboards, or data science

Join a unique SQL course

6:1 Student-Faculty Ratio

Weekly 2-hour live online classes

Weekly Exercises

Business Cases

Final Test and Certification

Curriculum

Do you know the basics of SQL and you want to take your SQL to the next level and advance in an analytical or strategic role? Then you are at the right place.

WORKING WITH SINGLE TABLES
(1.5 WEEKS)

In the first 1.5 weeks, we start from the basics and teach you everything you need to learn about pulling and manipulating data from one table.

We will discuss how to filter, aggregate, and order the rows and columns that you need to answer your business question.

Learn More
WORKING WITH MULTIPLE TABLES
(1.5 WEEKS)

After setting up your foundation of SQL knowledge, you will learn how to combine data that comes from multiple tables. This is critical since data is never stored in a single table in any business.

We will discuss methods on how to combine multiple tables by using joins, union and subqueries. Finally, these weeks teach you how to simplify complex queries by breaking up the query using WITH statements.

Learn More
BUSINESS CASES (1 WEEK)

Practice is key when you are learning how to write SQL. Because of that, we will test your SQL knowledge through a business case.

This will train you to become more comfortable in translating business questions into data-driven answers while testing your SQL knowledge. You will receive the certificate of completion after passing the business case.

Learn More
Working WITH MESSY AND UNSTRUCTERD DATA
(2 weeks)

Unfortunately, not all data sources you will work with are clean and easy to use.

Because of that, we will discuss concepts (e.g. RegEx, coalesce, and string functions) to clean unstructured data and correctly extract insights from data.

WORKING WITH HIERARCHICAL QUERIES USING MULTIPLE DATA SOURCES TO CREATE DATASETS
(2 weeks)

In the next 1.5 weeks, we will focus on writing complex queries that combine many data sources and how to simplify them.

We will use this knowledge to teach out how to create hierarchical queries that can be used to build datasets for business analysis, dashboard views, or data science modelling.

Business case
(1 week)

In the last week, we will go through a real-life business case that combines all the theories discussed in the previous weeks.

This will allow you to become more comfortable in applying these skills in an actual business environment.

You will receive the certificate of completion after passing the business case.