£899,-
8 hours
Go from Zero to Hero on coding with SQL
Use JOINs & UNIONs to consolidate reporting and data
Apply your skills to solve the “Help the CMO” case study
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.
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.
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.
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.
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.
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.
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.
