1.4 SQL Basic - DML

Dependencies

Refer to the following markdown file for the respective sections of the class:

• Self Studies
• Lesson
• Assignment
• Quiz
• Reference

Lesson Objectives

Learners will understand:

• SQL Data Manipulation Language (DML) statements
• Operators and functions
• Filters and sorting
• Aggregate functions and group by
• Advanced operators and functions

Learners will be able to:

• Run SQL DML statements to query and manipulate data in a database
• Use operators and functions
• Use filters and sorting
• Use aggregate functions and group by
• Use advanced operators and functions

Lesson Plan

Duration	What	How or Why
- 5mins	Start zoom session	So that learners can join early and start class on time.
30 mins	Activity	Recap on self-study and prework materials.
30 mins	Code-along	Introduction to DML statements and basic query.
	1 HR MARK
45 mins	Code-along	Use operators and functions. Add filters and sorting to query.
15 mins	Break
	2 HR MARK
45 mins	Code-along	Use aggregate functions and group by to summarise data. Add logic and conditions to query.
15 mins	Briefing / Q&A	Brief on references, assignment, quiz and Q&A.
	END CLASS 3 HR MARK