Basic Database Operations (SQL SELECT)

Active learning works for Basic Database Operations because students need hands-on practice to see how small changes in SQL queries produce different results. When they write and execute real queries, they connect syntax to outcomes, which helps them remember rules and spot errors faster.

• JC 1
• Computing
• 4 activities
• 25 min–50 min

Learning Objectives

1. Construct SQL SELECT statements to retrieve specific columns from a single database table.
2. Apply WHERE clauses with comparison operators (=, >, <, >=, <=) to filter rows based on specified criteria.
3. Utilize the LIKE operator with wildcards (%) to perform pattern matching for string data retrieval.
4. Explain the purpose and benefit of filtering data to obtain precise results from a database.

Project-Based Learning

⏱ 30 min·Pairs

Pair Query Relay: Student Database Challenges

Pairs share a laptop with a sample students table containing name, age, grade data. One partner writes a SELECT query for a given condition, like age > 16, then the other executes and explains results before switching roles. Rotate challenges every 5 minutes to cover filtering and column selection.

Prepare & details

How can you ask a database to show you only certain information?

Facilitation Tip: In Pair Query Relay, circulate to listen for students explaining their query logic to each other before executing it.

Setup: Flexible workspace with access to materials and technology

Materials: Project brief with driving question, Planning template and timeline, Rubric with milestones, Presentation materials

• Apply
• Analyze
• Evaluate
• Create
• Self-Management
• Relationship Skills
• Decision-Making

Project-Based Learning

⏱ 45 min·Small Groups

Small Groups: Mystery Solver Queries

Provide groups with a crime scene database table of suspects, alibis, locations. Groups write 3-4 SELECT queries to identify the culprit by filtering matching criteria. Share and verify solutions class-wide.

Prepare & details

Write a simple SQL query to find all students named 'John' from a student table.

Facilitation Tip: During Mystery Solver Queries, ask groups to justify their final query by tracing how each clause narrows the results.

Setup: Flexible workspace with access to materials and technology

Materials: Project brief with driving question, Planning template and timeline, Rubric with milestones, Presentation materials

• Apply
• Analyze
• Evaluate
• Create
• Self-Management
• Relationship Skills
• Decision-Making

Project-Based Learning

⏱ 50 min·Whole Class

Whole Class: Build and Query Class Roster

Collect class data into a shared table live via Google Forms. Teacher demonstrates basic SELECT, then class suggests and votes on queries to display subsets like birthdays in a month. Follow with individual practice.

Prepare & details

Why is it useful to be able to filter data when querying a database?

Facilitation Tip: For Build and Query Class Roster, prepare a shared document where students paste their queries and results for whole-class review.

Setup: Flexible workspace with access to materials and technology

Materials: Project brief with driving question, Planning template and timeline, Rubric with milestones, Presentation materials

• Apply
• Analyze
• Evaluate
• Create
• Self-Management
• Relationship Skills
• Decision-Making

Project-Based Learning

⏱ 25 min·Individual

Individual: SQL Playground Experiments

Students use an online SQL editor with a books table. Independently write and test 5 queries varying columns and WHERE clauses from prompts. Submit screenshots of successful outputs.

Prepare & details

How can you ask a database to show you only certain information?

Facilitation Tip: In SQL Playground Experiments, remind students to document their process, including failed attempts and fixes.

Setup: Flexible workspace with access to materials and technology

Materials: Project brief with driving question, Planning template and timeline, Rubric with milestones, Presentation materials

• Apply
• Analyze
• Evaluate
• Create
• Self-Management
• Relationship Skills
• Decision-Making

Teaching This Topic

Teach this topic by modeling how to break down a request into SQL parts, such as identifying which columns to select and what conditions to apply. Avoid rushing through syntax rules—instead, let students discover them through trial and error. Research shows that debugging their own queries builds stronger retention than passive instruction.

What to Expect

Successful learning looks like students writing accurate SELECT statements with correct column lists and WHERE clauses, explaining why they chose specific filters, and correcting mistakes when results don’t match expectations. They should also discuss efficiency, comparing full-table results to filtered outputs.

Watch Out for These Misconceptions

Common Misconception

During Pair Query Relay, watch for students assuming WHERE is required in every query.

What to Teach Instead

Have pairs run the same query twice: once without WHERE and once with a simple condition like WHERE age > 18. Then ask them to compare the outputs and explain when WHERE is necessary.

Common Misconception

During SQL Playground Experiments, watch for students treating SQL as flexible English phrasing.

What to Teach Instead

Before executing any query, have students read their statement aloud as a group and identify where commas and semicolons must appear, correcting syntax errors collaboratively.

Common Misconception

During Build and Query Class Roster, watch for students thinking SELECT always returns every row.

What to Teach Instead

After the activity, display two queries side by side: one with SELECT * and one with a column list and WHERE clause. Ask students to time how long each takes to run and discuss why customization matters.

Assessment Ideas

Quick Check

After Pair Query Relay, give students a new table with columns like 'ProductID', 'Name', 'Price', and 'Category'. Ask them to write a query to retrieve all products priced above 50 where the category is 'Electronics'. Collect queries to check for correct syntax and logic.

Exit Ticket

During Mystery Solver Queries, ask each group to submit one query they wrote to solve the mystery, along with a brief explanation of how the WHERE clause helped narrow the results.

Discussion Prompt

After Build and Query Class Roster, pose this scenario: 'If you wanted to find students who joined the school after 2022, what columns would you need, and what conditions would you apply? Discuss your answer with a partner, then share with the class.'

Extensions & Scaffolding

• Challenge students to write a query that uses both a WHERE clause and a LIKE operator to find names starting with a specific letter in the Students table.
• Scaffolding: Provide a partially completed query for students to finish, highlighting the WHERE clause or column list they need to adjust.
• Deeper exploration: Ask students to compare the performance of SELECT * FROM students versus SELECT name, age FROM students WHERE major = 'Computer Science' using a large dataset, then explain the difference in execution time.

Key Vocabulary

SELECT	The SQL keyword used to specify which columns to retrieve from a database table.
FROM	The SQL keyword used to indicate the table from which to retrieve data.
WHERE	The SQL keyword used to filter records, specifying conditions that must be met for a row to be included in the result.
LIKE	An SQL operator used in the WHERE clause to search for a specified pattern in a column, often with wildcard characters.
Wildcard (%)	A special character used with the LIKE operator to represent zero, one, or multiple characters in a string search.