Lesson Plan

Resources → Subject Notes → Information Technology IT → Notes
Lesson Plan
Grade: Date: 03/03/2026
Subject: Information Technology IT
Lesson Topic: Perform database query operations (create, update, delete)
Learning Objective/s:
  • Describe the purpose of DDL and DML commands in SQL.
  • Write CREATE TABLE statements with appropriate data types and constraints.
  • Execute INSERT, UPDATE, and DELETE statements correctly using WHERE clauses.
  • Apply transaction control (BEGIN, COMMIT, ROLLBACK) to ensure data integrity.
  • Identify and correct common SQL syntax and constraint errors.
Materials Needed:
  • Computer lab with SQL‑capable DBMS (e.g., MySQL, SQLite).
  • Projector and screen for live coding demos.
  • Printed worksheet with practice exercises and sample data.
  • Student handout summarising SQL syntax and constraints.
  • Whiteboard and markers.
 Introduction:
Begin with a quick poll: Who has previously written an SQL query? Review key concepts of DDL vs DML, then outline today’s success criteria: students will create a table, manipulate records, and use transactions safely.
Lesson Structure:
  1. Do‑Now (5') – Students answer a short quiz on SQL terminology on the board.
  2. Mini‑lecture (10') – Demonstrate CREATE TABLE and constraint syntax using the Students example.
  3. Guided practice (15') – Students follow along to write INSERT, UPDATE, DELETE statements for a Products table; teacher circulates for checks.
  4. Transaction activity (10') – Model a BEGIN…COMMIT sequence; learners complete a worksheet task adding an order and adjusting stock.
  5. Consolidation (5') – Whole‑class review of common errors; exit ticket where each student writes one correct UPDATE statement.
Conclusion:
Recap the four core operations and why transactions protect data. Collect exit tickets and address any lingering misconceptions. Assign homework: complete the remaining practice exercises on creating and modifying tables.