SQL Tutorial


    1. Introduction
    2. Database Structure


    3. Create
    4. Select
    5. Insert
    6. Update
    7. Delete
    8. Drop


    9. Joining Tables


    10. Terms
    11. Credits

SQL Database Structure

The SQL database structure consists of one or more tables. Each table is contained in a file. Tables are defined by rows and columns.

Column 1Column 2Column 3Column 4
Row 1
  • row- record - Information about a specific object such as a person.
  • column -field - category of information
  • key - A unique value in a table that is used to identify that particular object/