Bummer! This is just a preview. You need to be signed in with a Treehouse account to view the entire video.
Manipulating Schema and Data0:55 with Andrew Chalkley
There are two main components to the SQL language. One deals with how the data is structured, the other how you create, read, update and delete data.
[Deep Dive] [Database Foundations: Manipulating Schema and Data with Andrew Chalkley] [? music ?]
[Andrew Chalkley] When dealing with different database implementations
you will notice that the SQL can vary from
database implementation to database implementation.
You will find no matter what database you are using
the SQL syntax is split into 2 parts--DDL and DML.
DDL stands for data definition language
which deals with special keywords that create and modify tables
and create and modify databases.
In other words--DDL deals with schema.
DML stands for data manipulation language,
and that deals with the CRUD operations in a database--
creating, reading, updating, and deleting data.
These 2 terms are not that important to memorize,
but you should be aware when writing your SQL
that you could either be modifying the data or the schema.
You need to sign up for Treehouse in order to download course files.Sign up