What You’ll Learn
Validate and clean a dataset
Assess and create datasets to answer your questions
Solve problems using SQL
Build a simple testing framework to touch on AB Testing
Skills You’ll Gain
Shareable Certificate
Earn a shareable certificate to add to your LinkedIn profile.
Develop Your Specialized Knowledge
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate
There are 4 modules in this course
After this module, you will be able to navigate the course environment and datasets, recall and apply key SQL concepts including joins, CTEs, and aggregation. You will be able to identify and resolve common SQL errors. You will also be able to apply structured approaches to SQL problem-solving and use diagnostic techniques to evaluate data quality. Finally, you'll be able to simplify queries using CTEs, subqueries, and pivot logic.
After this module, you will be able to describe how data flows to analysts in modern stacks. You will be able to write SQL queries on event and JSON-based data. You will be able to evaluate the trustworthiness of different data sources.
After this module, you’ll be able to design SQL queries to support reporting, metrics, and goal tracking. You'll be able to analyze data for executive dashboards, funnels, and retention. Finally, you'll be able to translate business questions into SQL-based investigations.
After this final module, you will be able to tackle open-ended SQL challenges with limited guidance. You'll be able to construct queries to support forecasting and recommendation systems. You'll also be able to communicate insights through effective SQL design and visualization prep.