SQL Tutorial


      Basics

    1. Introduction
    2. Database Structure

      Commands

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

      Operations

    9. Joining Tables

      Appendices

    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/