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

Next course starts Feb 28, 14:00 UK Time

£ 1699 GBP

What you will learn

Get familiar with the Snowflake database environment

Learn how to query data using SQL

Automate data processing from many data sources

Enroll now
Only
6 spots
remaining 🔥
Client headshotClient headshotClient headshot
51 successful customers.
Read testimonials

Foundational course

Beginner

14 Hours

Program Highlights

187

187 professionals completed the course

Custom designed to prepare you for an analyst, strategy, and product manager role

4.7

4.7 out of 5 average rating from previous students

Designed by experts from top tech companies that worked in both business and analytics roles

6:1 Student-Faculty Ratio

Weekly 2-hour live online classes

Weekly Exercises

Business Cases

Final Test and Certification

What you'll learn

Follow up from SQL Course for Zero to Hero course

Expand your knowledge to multiple joins, WITH statements and subqueries

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

Works like it should

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.

1

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.

2
3

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.

Short courseS TO APPLY YOUR SKILLS

Our recommended short courses

FOUNDATIONAL COURSE

Python for Data Analysis

Looking to learn your next programming language, but little to no coding background? We teach the power of python through real-life cases to automate data prep, run simulations and visualise data to extract insights.

Learn More
FOUNDATIONAL COURSE

Foundations of data analytics with SQL and Tableau

Data analytics and visualisation go hand-in-hand if you want to obtain insights from data.

This course teaches you the broad perspective of databases, data preparation and visualisation in Tableau to deliver value from data.

Learn More
FOUNDATIONAL COURSE

Build dashboards in CRM Analytics

The course introduces you to working in a database, how to query data from the database, and how to use this data to build dashboards in CRM Analytics

Learn More