Computer Science · Class 12

Active learning ideas

Executing SQL DQL Queries and Fetching Results in Python

Active learning helps students grasp SQL-Python integration by solving real coding problems. Writing and executing queries in pairs or small groups builds muscle memory for cursor methods and connection handling. Direct experimentation reduces abstract confusion about data retrieval structures.

• CBSE Learning Outcomes
• CBSE: Database Management - Interface Python with SQL - Class 12

• 25–40 min
• Pairs → Whole Class
• 4 activities

Activity 01

• Experiential Learning
• 30 min · Pairs

Pair Programming: Query Builder Challenge

Pairs connect to a sample student database using sqlite3, write a function to execute a SELECT query for marks above 80, and use fetchall() to display results in a formatted table. They test with different conditions and note execution time. Switch roles midway to ensure both contribute.

Explain how to execute SQL SELECT statements and retrieve results in Python.

Facilitation Tip

During Pair Programming, have students swap roles every 5 minutes to keep both partners engaged with query design and execution.

What to look for

Provide students with a small SQLite database containing a 'students' table. Ask them to write a Python snippet to fetch and print the name and marks of a single student using `fetchone()`. Then, ask them to fetch and print all students who scored above 75% using `fetchall()`.

• Apply
• Analyze
• Evaluate
• Self-Awareness
• Self-Management
• Social Awareness

Activity 02

• Experiential Learning
• 40 min · Small Groups

Small Groups: Fetch Methods Comparison

Groups create a database with employee records, execute the same query using fetchone() in a loop and fetchall(), then compare output formats and efficiency. They present findings on a class chart. Extend by handling zero results with if checks.

Construct a Python function to fetch all records from a table and display them.

Facilitation Tip

In Fetch Methods Comparison, provide a printed checklist so groups systematically test both methods on the same query.

What to look for

On an exit ticket, ask students to write a Python function that takes a table name as an argument and returns all rows from that table using `fetchall()`. Include a brief explanation of why `fetchall()` is preferred over `fetchone()` for this specific task.

• Apply
• Analyze
• Evaluate
• Self-Awareness
• Self-Management
• Social Awareness

Activity 03

• Experiential Learning
• 25 min · Whole Class

Whole Class: Error Hunt Relay

Project buggy code snippets with common SQL-Python errors like unclosed cursors or syntax mistakes. Teams take turns fixing one error, run the code, and pass to the next. Discuss solutions as a class.

Differentiate between `fetchone()` and `fetchall()` methods for result retrieval.

Facilitation Tip

In Error Hunt Relay, display error messages on a slide as teams race to fix them, then discuss common pitfalls together.

What to look for

Facilitate a class discussion: 'Imagine you are building a library management system. When would you use `fetchone()` to retrieve data, and when would `fetchall()` be more appropriate? Provide specific examples for each scenario.'

• Apply
• Analyze
• Evaluate
• Self-Awareness
• Self-Management
• Social Awareness

Activity 04

• Experiential Learning
• 35 min · Individual

Individual: Custom Query Function

Each student builds a reusable function to query any table by name, fetch results, and print summaries. Test on provided databases, then share one unique query with the class for peer review.

Explain how to execute SQL SELECT statements and retrieve results in Python.

Facilitation Tip

For Custom Query Function, remind students to include error handling with try-except blocks to catch connection or query issues.

What to look for

Provide students with a small SQLite database containing a 'students' table. Ask them to write a Python snippet to fetch and print the name and marks of a single student using `fetchone()`. Then, ask them to fetch and print all students who scored above 75% using `fetchall()`.

• Apply
• Analyze
• Evaluate
• Self-Awareness
• Self-Management
• Social Awareness

A few notes on teaching this unit

Start with a live demo of connecting to a database and fetching one row, then expand to multiple rows. Use think-alouds to model troubleshooting steps like checking cursor existence or query syntax. Avoid rushing through setup steps; students need time to internalise the full query cycle before moving to complex queries.

Students should confidently connect to a database, execute SELECT queries, and fetch results using fetchone() and fetchall(). They should explain when each fetch method is appropriate and debug common errors independently. Code should run without syntax or logical mistakes in class activities.

---

Watch Out for These Misconceptions

• During Pair Programming: Query Builder Challenge, some students may assume fetchall() always returns a list of lists instead of tuples.

  Encourage pairs to immediately print the type of a fetched result, such as print(type(rows[0])), to confirm the structure and discuss why tuples are used for efficiency.

• During Error Hunt Relay, students might forget that cursor.execute() must be called before any fetch method.

  Have teams add print statements after execute() and before fetch() to visually verify the query was run, turning abstract steps into tangible checks.

• During Fetch Methods Comparison, students may write SQL strings without proper quotes or escape special characters.

  Provide a reference sheet of correctly quoted strings and request groups to debug each other’s snippets before running them, reinforcing syntax accuracy.

---

Methods used in this brief

• Experiential Learning