SQL is often described as a single language, but in practice it is a family of related sublanguages, each with a different job. Data Definition Language (DDL) is the part of SQL used to create and shape the structures that hold your data: tables, columns, data types, constraints, indexes, views, and schemas. Commands such as CREATE, ALTER, DROP, and TRUNCATE belong to DDL, and together they define what a database can store and what rules the stored data must obey.
This distinction matters in COP4708 because almost everything else you do depends on it. Queries written with SELECT (DQL) and data changes made with INSERT, UPDATE, and DELETE (DML) can only work within the structure that DDL has already established. Permissions (DCL) and transaction control (TCL) round out the picture. Getting comfortable naming these categories now will make the rest of the module, where you write real CREATE TABLE and ALTER TABLE statements, much easier to follow.
As you watch the videos below, keep a running list of which commands fall into which sublanguage, and notice how often DDL decisions, such as choosing a data type or adding a constraint, are decisions about data integrity rather than just syntax. Also pay attention to the commands that permanently change or remove structures, since those are the ones with the most serious consequences in a live database.
This video surveys all five categories of SQL commands: DDL, DQL, DML, DCL, and TCL. Based on its title and description, it presents each category's purpose along with syntax and short examples of the commands that belong to it. Expect a quick, structured tour rather than deep practice on any one command.
It directly addresses the "DDL vs. other SQL sublanguages" subtopic by placing DDL side by side with the other four categories, which is exactly the classification skill this topic asks you to build.
A longer, practice-oriented walkthrough of the core DDL commands from KnowHow Academy. The description indicates it explains the essential Data Definition Language commands and how to use them, so expect demonstrations of statements such as CREATE, ALTER, DROP, and TRUNCATE applied to database objects. The extra length allows for more worked examples than a short overview can offer.
It focuses specifically on DDL rather than SQL in general, giving you a concrete look at the database objects DDL defines and previewing the hands-on CREATE and ALTER work later in this module.
A fast-paced beginner crash course covering SQL fundamentals in about ten minutes. Its description promises the essential basics, which typically includes how tables and columns are structured, the common command families, and simple query syntax. It serves as general context rather than a DDL-specific lesson.
With over half a million views it is a well-tested orientation video, useful for situating DDL within SQL as a whole and for reviewing foundational vocabulary before the module's detailed DDL work.
Together these videos build the conceptual foundation the module outcomes rest on. The PyBrain overview supports MO1 most directly by sorting SQL commands into DDL, DQL, DML, DCL, and TCL according to purpose, while the Learn with Whiteboard crash course reinforces the surrounding SQL vocabulary. The KnowHow Academy DDL walkthrough previews the practical skills assessed in MO2 through MO5, showing CREATE, ALTER, and object-removal commands in action so that when you later write CREATE TABLE statements, apply PRIMARY KEY and FOREIGN KEY constraints, alter existing tables, and choose among DROP, TRUNCATE, and DELETE, the syntax and its consequences are already familiar.
These videos were chosen from YouTube on October 2, 2026. Each has captions; the player turns them on. Videos on YouTube can be changed or removed — if one no longer plays, tell your instructor. If a player does not appear, use its Watch on YouTube link.