Skip to content
Deadline to Die

04. DDL, DML & Constraints

Overview

This module focuses on Data Definition Language (DDL) to manage the schema and Data Manipulation Language (DML) for working with table records.

Topics Covered

  • DDL Operations: CREATE, ALTER, and DROP for tables and other objects.
  • Data Integrity & Constraints: Primary Keys, Foreign Keys, Unique, Check, and Default constraints.
  • DML Operations: INSERT, UPDATE, and DELETE (and the TRUNCATE command).
  • Identity Columns: Auto-incrementing primary keys in SQL Server.