Activity 1: Learn the SELECT Command
Workshop Resources
Mission 1: Save the Planet of Fun from Boredom!
Your first mission is to go to the Planet of Fun and save them from boredom! You are sent a database about the planet and you need to learn how to use SQL commands to help save the Planet of Fun!
Task 1: Take a peek at the information on the Planet of Fun
You are given information about the Galaxy and want to look for the Planet of Fun. To do this,
the Galactic Federation has given you your first SQL command: SELECT.
What the command does:
The SELECT command allows you to choose what data to show from a database.
Example:
Now use what you learned!
Drag the blocks into the terminal and rearrange them to answer the question below!
Question: What command will display all the columns in the database called “galaxy”?
ERROR INVALID INPUT
You found the correct command to display the entire database! This is handy when you want to see all the information at the tip of your fingers!
✓
You've completed the task! Continue to the next mission!