1.3 SQL Basic - DDL

Dependencies

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

• Pre-Class
• Lesson
• Post-Class
• 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