SQL COMMANDS & STATEMENTS
SQL goes far beyond the simple SELECT statement. It provides a complete set of tools to define structures, manipulate data, and control access within a database.
The Three Core SQL Command Types Every Data Analyst Must Learn
1. DDL — Data Definition Language
Defines, creates, and modifies the structure of database objects (tables, schemas, and indexes).
2. DML — Data Manipulation Language
Works with the data itself — inserting, updating, and deleting records.
3. DQL — Data Query Language
Focuses on retrieving and querying data.
Get kehinde abdul-azeez’s stories in your inbox
Join Medium for free to get updates from this writer.
SQL Command vs SQL Statement — What’s the difference?
SQL Command → The category (DDL, DML, DQL, etc.).
SQL Statement → The specific complete instruction written by the user.
Example: DDL is the command type, while CREATE TABLE customers (…) is a statement.
Revisiting these concepts through ID Analytics provided a valuable refresher and reinforced best practices in SQL usage.
Fellow Data Analysts, what other SQL command types would you add to this list (maybe DCL or TCL)? Drop your examples in the comments
