| Lesson Plan |
| Grade: |
Date: 25/02/2026 |
| Subject: Computer Science |
| Lesson Topic: Understand given SQL (DDL) statements and be able to write simple SQL (DDL) statements using a sub-set of statements |
Learning Objective/s:
- Interpret basic SQL DDL statements and identify the objects they create.
- Write simple SQL DDL statements using the defined subset of commands.
- Distinguish between DDL and DML and select the appropriate command type for a given task.
|
Materials Needed:
- Projector or interactive whiteboard
- Computer lab with an SQL IDE (e.g., MySQL Workbench)
- Printed worksheet with DDL examples and practice tasks
- Sample database schema handout
- Sticky notes for exit tickets
|
Introduction:
Begin with a quick recall of database concepts, asking students to name the difference between tables and data. Explain that today they will explore commands that shape the database structure. Success will be measured by their ability to read and write basic DDL statements.
|
Lesson Structure:
- Do‑Now (5') – Students list DDL vs DML commands on sticky notes.
- Mini‑lecture (10') – Define DDL and DML, present the subset of commands with simplified syntax.
- Guided walkthrough (15') – Analyse a sample CREATE TABLE statement; identify objects, primary key, constraints, and data types.
- Pair activity (15') – Write DDL statements for the “Course” table tasks; teacher circulates to provide feedback.
- Whole‑class review (10') – Volunteers share their statements; discuss common pitfalls such as accidental DROP or missing constraints.
- Quick quiz (5') – Exit ticket: classify a given statement as DDL or DML and justify the choice.
|
Conclusion:
Recap that DDL commands modify the database schema while DML commands manipulate the data within that schema. Ask students to note one pitfall they will watch for when writing DDL. For homework, have them design a small database schema using at least three DDL commands covered today.
|