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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- free client database management software
- nonprofit database management software
- database management best practices
- database management system textbook pdf
- database management system book pdf
- client database management free
- free school database management software
- database management system pdf books
- common database management systems
- access database management system
- database management pdf
- database management systems list