COMP282

SQL

As a declarative language

Command Categories

Using SQL

Naming Conventions

Command Structure

Command Template Example

Table Creation

Table Creation and Deletion

Data Types

More Types

Time Types

Inserting New Data

Deleting Data

Modifying Data

Retrieving Data

Table Joins

Set Operations