Intermediate SQL Queries
Learning Outcomes
By the end of this tutorial, you will be able to:
- Use advanced filtering functions
- Understand and use the CASE WHEN function
- Write subqueries
- Use and apply Common Table Expressions
Quest Details
Introduction
Welcome to the next stage of your SQL journey! In this quest, we will expand upon your existing SQL knowledge and explore a variety of advanced SQL queries. Get ready to delve into new concepts like CASE WHEN statements, crafting subqueries, and harnessing the power of common table expressions (CTEs).
Throughout the tutorial, we will leverage the capabilities of MySQL Workbench to perform data queries and derive valuable insights from diverse data sources. By the end of this adventure, you'll have gained a deeper understanding of SQL and acquired the skills to handle more complex data scenarios with confidence.
Deliverables
This quest has 1 deliverable.
- A screenshot of your MySQL WorkBench after running a specific SQL query
This quest is part of a campaign so do check out other quests!
Find articles to support you through your journey or chat with our support team.
Help Center