Computer Science · Class 12

Active learning ideas

Connecting Python to MySQL/SQLite

This topic works best with active learning because students need to experience real errors to understand database connections deeply. Writing and debugging scripts helps them grasp why parameters matter and how to handle failures.

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

• 15–30 min
• Pairs → Whole Class
• 4 activities

Activity 01

• Project-Based Learning
• 20 min · Individual

Hands-on Connection Script

Students write a Python script to connect to SQLite and print a success message. They test it and note any errors. Extend to MySQL if lab setup allows.

Explain the steps involved in connecting a Python application to a SQL database.

Facilitation Tip

During Hands-on Connection Script, circulate and ask students to explain why their connection parameters differ between MySQL and SQLite.

What to look for

Ask students to write down the Python import statement for both MySQL and SQLite. Then, have them list the essential parameters needed to establish a connection for each.

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

Activity 02

• Project-Based Learning
• 25 min · Pairs

Pairwise Error Hunt

Pairs exchange scripts with deliberate connection errors. They identify and fix issues like wrong passwords or missing imports. Discuss fixes as a class.

Construct a Python script to establish a database connection and handle potential errors.

Facilitation Tip

For Pairwise Error Hunt, remind pairs to document each error they find and the fix they applied.

What to look for

Provide students with a scenario: 'Your Python script failed to connect to the database because the password was incorrect.' Ask them to write a `try-except` block in Python that would catch this specific type of error and print a user-friendly message.

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

Activity 03

• Project-Based Learning
• 30 min · Small Groups

Group Database Setup

Small groups install SQLite, create a sample database, and connect via Python. They share setup tips with the class.

Analyze the security implications of storing database credentials directly in code.

Facilitation Tip

In Group Database Setup, assign roles so every student practices both creating tables and writing insert queries.

What to look for

Pose this question: 'Why is it a bad idea to store your database username and password directly in your Python script? What are two alternative, more secure methods for managing these credentials?'

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

Activity 04

• Project-Based Learning
• 15 min · Individual

Security Check Challenge

Individuals modify a given script to use secure credential handling. They compare methods and vote on the best approach.

Explain the steps involved in connecting a Python application to a SQL database.

What to look for

Ask students to write down the Python import statement for both MySQL and SQLite. Then, have them list the essential parameters needed to establish a connection for each.

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

A few notes on teaching this unit

Teach this topic by having students first write a working script, then intentionally break it to learn debugging. Avoid showing solutions upfront; instead, encourage peer discussion when errors occur. Research shows hands-on failure leads to stronger retention than pre-written correct code.

Successful learning looks like students confidently writing connection scripts, identifying errors quickly, and explaining why proper security practices matter. They should also justify when to use MySQL versus SQLite.

---

Watch Out for These Misconceptions

• During Hands-on Connection Script, watch for students assuming the same import statement and parameters work for both MySQL and SQLite.

  Redirect them by asking them to compare the mysql.connector and sqlite3 import statements and connection parameters on their screens.

• During Security Check Challenge, watch for students hardcoding passwords in their scripts without realizing the risk.

  Have them open the config file alternatives you provided and edit their scripts to use environment variables or config files instead.

• During Hands-on Connection Script, watch for students closing only the cursor or only the connection.

  Ask them to trace the flow of their script and label where each close() method is called, ensuring both cursor and connection are closed.

---

Methods used in this brief

• Project-Based Learning