Data analytics certificate

Live Instructor Led - SQL for Analysts Full Masterclass 🔥

£1,699

14 hours

In this course, you will:

Go from Zero to SuperHero on coding with SQL

Automate boring Excel work with SQL

Use JOINs & UNIONs to consolidate reporting and data

Apply your skills to solve the “Fraud” & “Help the CMO” case studies

Next course starts Jul 12, 14:00 UK time
Enroll now

Live Instructor Led -
Intro to Databases, SQL, and Dashboards in CRM Analytics

Next course starts
Jul 12 14:00 UK Time

14 hours

£1,699

After this course, you will able to:

Get familiar with the Snowflake database environment

Learn how to query data using SQL

Automate data processing from many data sources

Build dashboards using SAQL in CRM Analytics

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

The curriculum is designed to effectively prepare you how you will work with SQL in a business environment. It is based on our multi year experience as analysts in big tech companies. Based on the SQL knowledge, the course will cover how you can work with SAQL in CRM Analytics to build interactive dashboards for clients.

Working with single tables
(2 weeks)

In the first two 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.

Additionally, the first two weeks will teach you how to apply all this knowledge to automate repetitive tasks in Google Sheets.

Learn More
Working with multiple tables
(2 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, with statements and subqueries.

Learn More
Business cases (2 weeks)

Practice is key when you are learning how to write SQL. Because of that, we will put you in two different business cases in which you need to work with SQL to answer the business questions that are being asked from you in the next two weeks.

This will allow you to become more comfortable in translating business questions into data-driven answers, but this will also allow you practice the skills you have learned during the first four weeks.

Learn More
Exam (1 week)

To confirm you have successfully mastered the SQL skills from the course, the last week will include an exam. You will receive the certificate of completion after passing the exam.

Learn More
Introduction to Snowflake and sql
(2 weeks)

In the first two 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 navitage the Snowflake database and write queries based on tables stored in Snowflake.

Advanced querying in SQL
(2 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, with statements and subqueries.

transition sql into saql in CRM analytics
(2 weeks)

Once you are comfortable in SQL, we will transition to CRM Analytis and cover how you can use SQL to build dashboards in CRM Analytics using the derived language called SAQL.

We will cover all key skills needed to build interactive and dynamic dashboards taught by experts with >5 years of experience.

Exam (1 week)

To confirm you have successfully mastered the SQL & SAQL skills from the course, the last week will include an exam. You will receive the certificate of completion after passing the exam.