8.3 Data Definition Language (DDL) and Data Manipulation Language (DML)

Understand that the DBMS carries out all creation and modification of the database structure using its Data Definition Language (DDL).

Taught in: Two jobs, one language: DDL and DML · 4 questions

Understand that the DBMS carries out all queries and maintenance of data using its Data Manipulation Language (DML).

Taught in: Two jobs, one language: DDL and DML · 3 questions

Understand that Structured Query Language (SQL) is the industry standard for both DDL and DML.

Understand a given SQL statement.

Taught in: Two jobs, one language: DDL and DML · 2 questions

Understand given SQL (DDL) statements, and write simple SQL (DDL) statements using a sub-set of statements.

Create a database (CREATE DATABASE). Create a table definition (CREATE TABLE), including creating attributes with appropriate data types: CHARACTER, VARCHAR(n), BOOLEAN, INTEGER, REAL, DATE, TIME. Change a table definition (ALTER TABLE). Add a primary key to a table (PRIMARY KEY (field)). Add a foreign key to a table (FOREIGN KEY (field) REFERENCES Table (Field)).

Taught in: Changing a table and linking tables: ALTER TABLE and foreign keys, Building a table: CREATE TABLE and data types · 12 questions

Write an SQL script to query or modify data (DML) stored in at most two database tables.

Queries including SELECT ... FROM, WHERE, ORDER BY, GROUP BY, INNER JOIN, SUM, COUNT and AVG. Data maintenance including INSERT INTO, DELETE FROM and UPDATE.

Taught in: Joining two tables: INNER JOIN, Changing the data: INSERT, UPDATE and DELETE, Asking questions: SELECT, WHERE, ORDER BY and GROUP BY · 18 questions