Table of Contents

  1. Introduction to Structured Query Language (SQL)
  2. Data Definition Language
  3. CREATE TABLE
    1. Notes on Syntax
    2. Creating a Table
    3. DROP TABLE
    4. Activity 2.1
    5. Answer to Activity 2.1
    6. ALTER TABLE
  4. CREATE INDEX
    1. Syntax
    2. Activity 2.2
    3. Answer to Activity 2.2
  5. Calculated Fields
    1. Using Functions
    2. SELECT Command Syntax
    3. Activity 2.3
    4. Answer to Activity 2.3
    5. INSERT Command
    6. Notes on INSERT
    7. UPDATE Command
    8. DELETE Command
    9. Activity 2.4
    10. Answer to Activity 2.4
  6. Populating the Tables