8.3 DDL and DML

8.3 DLL and DML

• Data definition language (DDL)

• Data manipulation language (DML)

• SQL script

Fill in the Blanks

What is the language used to create, modify, and remove the data structures that form a database?

Fill in the Blanks

What is a list of SQL commands that perform a given task, often stored in a file for reuse?

Fill in the Blanks

What language is used to add, modify, delete, and retrieve data stored in a relational database?

8.3.2 SQL (DDL) commands and scripts

SQL data types

Example of a creation of a database

Activity

8.3.3 SQL (DML) commands and scripts

8.3.3 SQL (DML) commands and scripts