Alien Defense — Mission 1: Build the Base Database
Learn database fundamentals through hands-on SQLite construction
INCOMING TRANSMISSION
Commander, Earth's intelligence network is down. The alien strike obliterated our orbital database. Without this data, our radar systems are blind and field teams cannot coordinate.
Your mission: rebuild earth_base.db from scratch. You'll need to architect two critical tables, populate them with intel, and bring our early warning system back online.
Time
15 min
Difficulty
⭐⭐☆☆☆
Reward
Vault Code
📚 Database Fundamentals
What IS a Database?
Think of a database like a super-organized filing cabinet:
📁 Tables
Filing drawers
📄 Rows
Individual files
📝 Columns
Specific details
✅ Database initialized! Your connection is ready.
💻 Understanding Tables and Schema
🛡️ Table 1: Agents
Stores field operatives info
- agent_id - Unique number
- codename - Secret identity
- clearance_level - Rating 1-10
- location - Where stationed
- status - active/standby/compromised
🎯 Table 2: Alien_Sightings
Logs alien contact events
- sighting_id - Event number
- timestamp - When it happened
- location - Where it happened
- threat_level - Danger 1-5
- description - What was seen
- verified_by - Which agent
🛡️ Build the Agents Table
🎯 Your Mission
Write the SQL to create the Agents table below. When ready, click Run SQL to build your table.
✅ Success!
| ID | Codename | Clearance | Location | Status |
|---|
🎯 Build Alien Sightings Table
🎯 Your Mission
Write the SQL to create the Alien_Sightings table below. When ready, click Run SQL to build your table.
✅ Threat Intelligence Logged!
| ID | Location | Threat | Description | Agent |
|---|