DATABASE SYSTEMS

1. JOINS

1.1. INNER JOIN

1.1.1. NATURAL JOIN

1.1.2. CROSS JOIN

1.2. OUTER JOIN

1.2.1. LEFT OUTER JOIN

1.2.2. RIGHT OUTER JOIN

1.2.3. FULL OUTER JOIN

2. VIEWS

2.1. READ ONLY

2.2. MATERIALIZED VIEW

3. FUNCTIONS & SET OPERATIONS

3.1. SETS

3.1.1. UNION

3.1.2. INTERSECTION

3.1.3. MINUS

3.2. AGGREGATE FUNCTIONS

3.2.1. SUM

3.2.2. COUNT

3.2.3. AVG

3.2.4. MIN

3.2.5. MAX

4. TABLES

4.1. ROWS

4.2. COLUMNS

4.3. CONSTRAINTS

4.3.1. PRIMARY KEY

4.3.2. FOREIGN KEY

4.3.3. UNIQUE

4.3.4. CHECK

5. CLUSES

5.1. SELECT

5.2. FROM

5.3. WHERE

5.4. GROUP BY

5.5. ORDER BY

5.6. HAVING

6. LANGUAGES

6.1. DML

6.1.1. SELECT

6.1.2. INSERT

6.1.3. UPDATE

6.2. DCL

6.2.1. GRANT

6.3. DDL

6.3.1. CREATE

6.3.2. ALTER

6.3.3. DROP

6.3.4. TRUNCATE

6.4. TCL

6.4.1. COMMIT

6.4.2. ROLLBACK