Table of Contents

  1. Data Manipulation Language: Part 2
    1. Select Statement
    2. SELECT Statement: the FROM
    3. SELECT Statement: the WHERE clause
    4. SELECT Statement: Where Examples
    5. SELECT Statement: the ORDER BY clause
    6. Activity 2.1
    7. Activity 2.2A
    8. Activity 2.2B
    9. Activity 2.2C
    10. Activity 2.2D
    11. Activity 2.2E
  2. Further Selection of Rows
    1. BETWEEN Operators
    2. LIKE Operators
    3. IS NULL (IS NOT NULL) Operators
    4. Activity 2.3A
    5. Activity 2.3B
    6. Activity 2.3C
  3. Calculations
    1. GROUP BY clause
    2. HAVING clause
    3. UPPER and LOWER clause
    4. UPPER and LOWER Expanded
    5. Column Headings
  4. Combining Functions
    1. More Functions Combined
    2. Activity 2.4A
    3. Activity 2.4B
    4. Activity 2.4C
    5. Activity 2.4D
  5. Multiple Tables
    1. Relationships
    2. Data Model
    3. Linking Tables
    4. Linking Tables Example
    5. Extending Links
    6. Activity 2.5
  6. A Complex Example
    1. UPDATE Statement
    2. DELETE Statement
    3. Activity 2.6
    4. SAQ 2.1
    5. Section 2 Crossword
    6. Summary of this Section