Project Overview
Welcome to the SQL Survival Challenge: Last City on Earth! In this adventure-themed project, you will step into the shoes of a data analyst tasked with managing and analyzing the data of humanity’s final refuge—the Last City. As the world faces a cataclysmic event, effective data management becomes crucial to ensure the survival and prosperity of the city’s inhabitants.
Your mission is to navigate through various data scenarios, optimize resource allocations, respond to emerging threats, and maintain the city’s infrastructure. Through this hands-on experience, you’ll enhance your SQL skills while contributing to the Last City’s resilience.
Objective
By the end of this project, you will be able to:
- Design and Understand Complex Database Schemas: Grasp the relationships between different entities essential for city management.
- Execute Advanced SQL Queries: Perform data manipulation and analysis to solve real-world problems.
- Optimize Resource Allocation: Ensure efficient distribution of limited resources to various city facilities.
- Respond to Dynamic Threats: Analyze and react to potential threats to maintain city safety.
- Predict Future Needs: Use data trends to forecast and prepare for upcoming challenges.
Watch your training video below:
Tasks
Embark on the following tasks to ensure the Last City’s survival. Each task is designed to guide you through critical data analysis scenarios using SQL. After completing each task, you can check your answers using the provided sample queries.
