Relational Databases and SQL

Entities and Relations

Structured Query Language

Structured Query Language

Data types

VARCHAR2(size)

NUMBER(p,s)

CHAR(size)

BLOB

FLOAT(b) & INTEGER

The NULL value

Tables

Adding rows to a table

Adding rows to a table

Simple selection (1)

Simple selection (2)

Simple selection (3)

Simple selection (4)

Simple selection (5)

Deleting rows from a table

Changing values in rows

Joining tables