Lesson Plan: Common SQL Commands ICT
This lesson plan includes the objectives, prerequisites, and exclusions of the lesson teaching students how to perform the most important SQL operations on a database using SQL queries.
Objectives
Students will be able to
- identify the most common categories of SQL commands,
- outline the basic structure of SQL queries and statements,
- describe how to use conditions,
- differentiate between the following common SQL commands: SELECT, INSERT INTO, UPDATE, and DELETE FROM,
- write simple SQL statements and queries,
- recognize that SQL commands can be accessed using different languages.
Prerequisites
Students should already be familiar with
- the concept of SQL, SQL commands, statements, and queries,
- the concept of databases.
Exclusions
Students will not cover
- advanced SQL command categories and commands.