Data analytics certificate

Live Instructor Led -Intermediate SQL for Analysts🔥

£899,-

8 hours

In this course, you will:

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

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

Data analytics certificate

Live Instructor Led - Intermediate SQL for Analysts

Next course starts
May 10 09:30 UK Time

8 hours

£899

After this course, you will able to:

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

After this course, you will able to:

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

Did you take the SQL Zero to Hero course at Google or any of our other clients? Want to build on your SQL skills and get more intense learning in a small classroom setting? Then this course is built just for you.

WORKING WITH MULTIPLE TABLES
(1 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
CREATING TEMPORARY TABLES USING WITH AND SUBQUERIES
(1.5 WEEKS)

Being able to work with temporary tables in crucial in more complex business environments where messy data and many tables are needed to be used.

Temporary tables allow you tackle complex business problems while keeping your queries simple, an important skill to have

Learn More
BUSINESS CASES (1.5 WEEKS)

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 multiple tables
(1 week)

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 and unions.

CREATING tEMPORARY TABLES USING WITH AND SUBQUERIES
(1.5 week)

Being able to work with temporary tables in crucial in more complex business environments where messy data and many tables are needed to be used. Temporary tables allow you tackle complex business problems while keeping your queries simple, an important skill to have

Business caseS
(1.5 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.