SQL

SQL HISTORY

Insert

Delete

Update

Quiz

General SQL Query Syntax

In algebra, we use attribute, relashtion and tuple. In SQL, we use column, table and row

Selection-Wildcard

Selection-Where Clause

Selection-Composite Where Clause

Project

Distinct

Natural Inner Join-Dot Notation

Quiz

Natural Inner Join-Aliases

R, s WILL BE tuple variables

Left outer join

String Matching

Sorting

Set operations-uion

Set operations - intersect

不用非得是同一个人

Set operations-Except

Built in Functions

Group by

Having-Condition on the group

Nested Queries-In/Not In

Nested Queries-Some/All

Nested Queries-correlated

quiz