Types of SQL Commands
The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration.
The main categories are
DDL (Data Definition Language)
DML(Data Manipulation Language)
DQL (Data Query Language)
DCL (Data Control Language)
Data administration commands
Transactional control commands
Defining Database Structures (DDL)
Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation ...
Get Sams Teach Yourself SQL in 24 Hours, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
