1.3 SQL Basic - DDL

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 Definition Language (DDL) statements
• Databases, schemas, tables, keys, indexes, constraints
• Tables (materialized) vs views (virtual)

Learners will be able to:

• Connect to a database and execute SQL statements
• Create databases, schemas and tables
• Create indexes, constraints, primary and foreign keys
• Alter and drop tables
• Create views
• Insert data into a table
• Updating data in a table
• Import and export data to/from a database

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	Create database, connect to database and create schema and tables.
	1 HR MARK
45 mins	Code-along	Create indexes, constraints, primary & foreign keys, alter tables, drop tables, insert data.
15 mins	Break
	2 HR MARK
45 mins	Code-along	Tables vs views, updating data, import data into and export data from database.
15 mins	Briefing / Q&A	Brief on references, assignment, quiz and Q&A.
	END CLASS 3 HR MARK