BitWithBite
SQL Worksheet
🗃 Setting Up MySQL & First Queries
SCORE___ / 20
NameClassDate
After this worksheet you can
Create a database and tableRun your first SELECTEnd statements with semicolonsUse uppercase keywords by convention🧠 Section A · Concept Check ● BEGINNER 4 × 1 = 4
1Create a database with:
2Statements end with:
3Select everything from users:
4Choose the active database with:
🧮 Section B · Problem Solving ● INTERMEDIATE 2 + 3×3 = 11
5CREATE shop; makes a new database.
6SELECT * FROM users (ending symbol).
7Write the statement to create a database called school.
8Select all rows from a table named books.
9Why write keywords in UPPERCASE?
🚀 Section C · Challenge ● CHALLENGE 5
10What does SHOW TABLES; do?
💭 Reflection — the most useful thing I learned:
A ___/4 B ___/11 C ___/5 Total ___/20
Teacher's Signature
Parent's Signature
✂ answer key — fold or cut before handing out
1-B 2-B 3-A 4-B | 5 DATABASE 6 ; 7 = CREATE DATABASE school; 8 = SELECT * FROM books; 9 = Convention/readability - SQL itself is case-insensitive for keywords | 10 = Lists the tables in the current database