SQL Basics - Definition & Concepts (Cont.)
-
SQL language has two major groups of commands:
-
DML – Data Manipulation Language – commands that were designed to
change the data in the DB.
Insert, update or delete records from the DB.
-
DDL – Data Definition Language – commands that were designed to alter the data structure
of the DB, the way we keep the records.
-
SQL databases can be case sensitive, kana sensitive, width sensitive etc.
|