SQL Statements

Contact Us or call 1-877-932-8228
SQL Statements

SQL Statements

Note: you will learn what all these SQL statements mean as you go through the course, so don't worry about knowing what they mean for now.

Database Manipulation Language (DML)

DML statements are used to work with data in an existing database. The most common DML statements are:

  • SELECT
  • INSERT
  • UPDATE
  • DELETE

Database Definition Language (DDL)

DDL statements are used to structure objects in a database. The most common DDL statements are:

  • CREATE
  • ALTER
  • DROP

Database Control Language (DCL)

DCL statements are used for database administration. The most common DCL statements are:

  • GRANT
  • DENY (SQL Server Only)
  • REVOKE
Next