Computing · JC 1

Active learning ideas

Structured Query Language (SQL)

Active learning works well for SQL because students often see databases as abstract concepts rather than practical tools. By writing and debugging queries together, they see immediate feedback on how SQL solves real data problems, which builds confidence and retention. Collaboration also mirrors the teamwork required in professional data analysis roles.

• MOE Syllabus Outcomes
• 9569 4.3.1 Write SQL statements to create and modify tables
• 9569 4.3.2 Write SQL queries using SELECT, WHERE, ORDER BY, and JOIN

• 30–50 min
• Pairs → Whole Class
• 3 activities

Activity 01

• Inquiry Circle
• 50 min · Small Groups

Inquiry Circle: The SQL Detective

Students are given a database of a fictional crime scene (e.g., flight logs, phone records). They must write increasingly complex SQL queries to filter through the data and identify the 'suspect' based on a set of clues.

How do we retrieve specific data using the SELECT statement?

Facilitation Tip

During The SQL Detective, give students five minutes to discuss their findings in pairs before sharing with the class, ensuring everyone contributes.

What to look for

Pose the scenario: 'Imagine you are managing a school's student records using only individual text files for each student. What problems would you encounter when trying to find all students living in a specific postal code or list all students taking a particular subject?' Facilitate a class discussion comparing these issues to the benefits of a database.

• Analyze
• Evaluate
• Create
• Self-Management
• Self-Awareness

Activity 02

• Peer Teaching
• 35 min · Pairs

Peer Teaching: Query Optimization

Pairs are given a slow, inefficient query (e.g., using multiple nested subqueries). They must work together to rewrite it using JOINs and then explain to another pair why their version is more efficient for the database engine.

How can we join multiple tables in a single query?

Facilitation Tip

For Query Optimization, provide a deliberately slow query and challenge students to rewrite it in half the steps within a time limit.

What to look for

Provide students with a simple scenario, e.g., managing a small collection of books. Ask them to draw a simple table structure for a flat-file database and then a relational database structure (e.g., one table for books, one for authors). Have them identify at least two fields and two records for each structure.

• Understand
• Apply
• Analyze
• Create
• Self-Management
• Relationship Skills

Activity 03

• Simulation Game
• 30 min · Small Groups

Simulation Game: SQL Injection Role Play

One student acts as a 'Web Form' and another as a 'Database.' A third student (the 'Hacker') tries to pass a 'malicious' string that tricks the Database into revealing secret data. This demonstrates the need for input validation.

What is the difference between DDL and DML commands?

Facilitation Tip

In SQL Injection Role Play, assign each student a role (hacker, developer, database admin) to act out the scenario before discussing prevention strategies.

What to look for

On a slip of paper, ask students to write: 1. One reason why a relational database is better than a flat-file database for managing student information. 2. The role of a DBMS in ensuring data is accurate and accessible.

• Apply
• Analyze
• Evaluate
• Create
• Social Awareness
• Decision-Making

A few notes on teaching this unit

Teach SQL by starting with concrete problems students care about, like managing a library or school records. Avoid teaching syntax in isolation; instead, tie each clause to a real-world task. Research shows students learn SQL best when they debug broken queries and explain why they fail, so plan for intentional errors in examples. Emphasize that SQL is not just for reading data but for shaping it into useful information.

Successful learning looks like students confidently writing SELECT, INSERT, and JOIN queries that produce accurate results. They should explain why syntax order matters and how to optimize queries for performance. Peer discussions should reveal a growing understanding of relational database structures and SQL’s role in managing data integrity.

---

Watch Out for These Misconceptions

• During The SQL Detective, watch for students who assume SQL is only for searching. Redirect them by asking them to identify any INSERT, UPDATE, or DELETE statements in the mystery data they investigate.

  Ask students to rewrite one of the SELECT queries to include a GROUP BY clause that calculates the total number of records for each category in their mystery data.

• During Peer Teaching: Query Optimization, watch for students who rearrange clauses incorrectly. Redirect by having them physically cut out query parts and reorder them on a worksheet with labeled sections for each clause.

  Provide a set of scrambled query parts and ask students to sort them into the correct order before writing the query in their notebooks.

---

Methods used in this brief

• Inquiry Circle
• Peer Teaching
• Simulation Game