Quiz: Say “Hello” to the Table
Explore the foundational SQL command SELECT * by taking a quiz that reinforces how to retrieve complete data from tables. This lesson helps you validate your understanding of reading full tables and prepares you to apply these skills to new tables and real projects.
We'll cover the following...
In the last lesson, you wrote your very first SQL query! You learned how to use SELECT * FROM to retrieve all rows and columns from a table; in this case, the people table. You also learned that SQL is case-insensitive and that * is a wildcard that means “everything.”
Let’s check your understanding with a quick quiz.
What does the SQL query SELECT * FROM people do?
Adds a new person to the people table
Displays all rows and columns from the people table
Selects only the ID column from the people table
Well done! You’ve just learned one of the most fundamental SQL commands: SELECT *. Now you can read full tables with just a single line of code.
What’s next?
Now it’s time to put your skills into practice with a hands-on project! In this, you’ll:
Query a second table called
pets.Use the
SELECT * FROM petscommand to display all rows and columns.View details like pet names, types, and ages.
Let’s see what data your next table holds!