Tables

Database is organized with the tables. hold related data about a particular subject.

tables are organized into rows and columns

table rows and columns are referred to as records and fields.

fields are set at database creation; no limit to the number of records.

Data

• data inside the database

• number, text, or a date

• Different types of data are stored differently and take up different amounts of storage space

• Some operations only apply to certain data types

  • all one data types: field

    

  Varchar flexible and popular string data type in SQL

  

  INT: flexible and popular integer data type in SQL

  

  

  Introducing Queries

Spreadsheet

Keywords are reserved words for operations

select, from

SELECT name
FROM patron;

SQL flavors

• oracle database
• microsoft sql
• relational database