DDL: Intro

Structured Query Language (SQL) is an easy-to-learn, albeit, high level language that you’ll find being used pretty much wherever you come across relational databases. It is used in essentially two ways: building databases and retrieving data from these databases.

That is, we can divide the language into two broad categories:

• Data Definition Language (DDL)
• Data Manipulation Language (DML)

Data Manipulation Language

Data Manipulation Language is what we use when are working with the data itself. For example, this could mean :

• returning data with SELECT
• populating a table with INSERT
• changing data with UPDATE
• removing data with DELETE