DBA120

Download as PDF

Database Programming I

Objectives

Issue SQL commands to retrieve data based on criteria specified by the user.

Objectives

Issue SQL commands to join multiple tables and retrieve data from the joined tables.

Objectives

Perform calculations based on data contained within the database.

Objectives

Use sub-queries to retrieve data based on unknown conditions that exist within the database.

Objectives

Insert, update and delete data stored in database tables.

Objectives

Create, modify, and drop database tables.

Objectives

Enforce business rules through the use of table constraints.

Objectives

Create printable reports through various SQL commands.