IS 441 Database Management



IS 441 Database Management

SQL Repertoire

SINGLE TABLE QUERIES (SQL Play List 1)

- SELECT Clause

All, Selected Fields, Calculated Fields, Alias

- WHERE Clause with Simple Conditions

EQUAL, NOT EQUAL, BETWEEN, IN, LIKE

- WHERE Clause with Complex Conditions

AND, OR, NOT

- ORDER BY Clause

Single Column, Multiple Columns, DESCENDING

SINGLE TABLE OPERATIONS (SQL Play List 2)

- Create New Table from an Existing Table (Partitioning) with SELECT-INTO

- Create New Table with CREATE TABLE Statement

- ALTER TABLE: Set CONSTRAINT Primary Key

- ALTER TABLE: ADD / DROP Columns

- Populate Table: INSERT New Row

- UPDATE Table: SET New Information in Row

TABLE SET UP (SQL Play List 3)

- Set Autonumber (Sequence/Counter)

- CREATE Index

- ALTER TABLE: Set CONSTRAINT Foreign Key and Referential Integrity

- Create Recursive Relationship

- Set Data Constraints in CREATE TABLE

- ALTER TABLE: Change Field Size, Type

- Create Calculated Column

- Set Condition on Calculated Field

- Create View and Reference to View

- Column Functions: MAX, MIN, SUM etc.

- Subquery: embedded SELECT clause

- GROUP BY Statement

- HAVING Statement

INNER JOIN (SQL Play List 4)

- INNER JOIN Two Tables

- INNER JOIN with Criteria

- INNER JOIN with Row Functions in SELECT Statement

- INNER JOIN Three Tables

- JOIN Tables and Views

OUTER JOIN & UNION (SQL Play List 5)

- LEFT OUTER JOIN

- RIGHT OUTER JOIN

- UNION

- SELF JOIN

- Embedded Queries in JOINing

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download