SQL Commands

Table of Contents

SQL Commands

Review

Relational Algebra Operations

Relational Calculus

SQL

SQL Uses

SELECT

SELECT Conditions

Relational Algebra Selection using SELECT

Relational Algebra Projection using SELECT

Relational Algebra Join using SELECT

Aggregate Functions

Using Aggregate functions

Using an Aggregate Function

Create Table

Access Data Types

Access Numeric types

Oracle Data Types

Creating a new table from existing tables

Alter Table

INSERT

DELETE

UPDATE

DROP Table

CREATE INDEX

Assignment 3

Email: ray@sherlock.berkeley.edu

Home Page: http://sims.berkeley.edu/~ray

Download presentation source