sql (PDF)

Introduction to
SQL
Phil Spector

Introduction to SQL
Phil Spector

Statistical Computing Facility
University of California, Berkeley

Introduction to
SQL

Introduction to
SQL

What is SQL?

Introduction to
SQL

What is SQL?

I

Structured Query Language

Introduction to
SQL

What is SQL?

I

Structured Query Language

I

Usually “talk” to a database server

Introduction to
SQL

What is SQL?

I

Structured Query Language

I

Usually “talk” to a database server

I

Used as front end to many databases (mysql,
postgresql, oracle, sybase)

Introduction to
SQL

What is SQL?

I

Structured Query Language

I

Usually “talk” to a database server

I

Used as front end to many databases (mysql,
postgresql, oracle, sybase)

I

Three Subsystems: data description, data access and
privileges

Introduction to
SQL

What is SQL?

I

Structured Query Language

I

Usually “talk” to a database server

I

Used as front end to many databases (mysql,
postgresql, oracle, sybase)

I

Three Subsystems: data description, data access and
privileges

I

Optimized for certain data arrangements

Introduction to
SQL

What is SQL?

I

Structured Query Language

I

Usually “talk” to a database server

I

Used as front end to many databases (mysql,
postgresql, oracle, sybase)

I

Three Subsystems: data description, data access and
privileges

I

Optimized for certain data arrangements

I

The language is case-sensitive, but I use upper case
for keywords.