Want to want the first lesson for free?

WeWe get it, we also prefer to date before we marry #redflag #GenzJoin
the first live lesson in our upcoming cohort for free on 17 jan 2023

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

I considered SQL intimidating prior to the Bootcamp with Cognitas. The program was incredibly effective with stellar facilitation by instructors. I felt directly supported and that the instructors met me at the pace that worked for me. Pulling me aside even to make sure that I understood the concepts and commands. I left the program with confidence and competency that I have been able to apply in leading large data based projects.

Odinakachi Anyanwu

Sep 14, 2022

Want to want the first lesson for free?

We get it, we also prefer to date before we marry #redflag #GenzJoin

The first live lesson in our upcoming cohort for free on
17 jan 2023

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

I considered SQL intimidating prior to the Bootcamp with Cognitas. The program was incredibly effective with stellar facilitation by instructors. I felt directly supported and that the instructors met me at the pace that worked for me. Pulling me aside even to make sure that I understood the concepts and commands. I left the program with confidence and competency that I have been able to apply in leading large data based projects.

Odinakachi Anyanwu

Sep 14, 2022

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.

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

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

Business case
(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.