Table of Contents

  1. Introduction to SQL
    1. Activity 1.1
    2. Relational Databases
    3. Activity 1.2
    4. Activity 1.3
    5. Activity 1.4
    6. Relationships
    7. Data Model: Pets 1
    8. Data Model: Pets 2
  2. Structured Query Language (SQL)
    1. SQL*Plus (Interactive SQL)
    2. SQL*Plus Editing Commands
    3. Use of SQL *Plus Editor
    4. SQL *Plus Notepad
    5. SQL *Plus Editor After Notepad
    6. Try It Out
  3. Data Definition Language (DDL)
    1. CREATE TABLE
    2. Table Components
    3. Foreign Key Constraint
    4. Using the Create Table Command
    5. Data Types
    6. Data Type Hints
  4. Creating the Employee Table
    1. Activity 1.5A
    2. Activity 1.5B
    3. Activity 1.5C
    4. Drop Table
    5. Alter Table
    6. Renaming Tables
    7. Synonyms
    8. View Table Structures
    9. Activity 1.6
    10. Activity 1.7
  5. Data Manipulation Language: Part 1
    1. DML: Insert Statement
    2. Insert Statement: Format 1
    3. Insert Statement: Format 2
    4. NULL Values Explained
    5. Commit and Rollback
    6. The Select Statement
    7. Activity 1.8
  6. SQL *Plus Command Files
    1. Using Command Files
    2. Other Useful SQL *Plus Commands
    3. Example LO1 Assessment
    4. Section 1 Checklist
    5. Section 1 Crossword
    6. Summary of this section