User:Joelwilliamson/Collections/SQL

SQL

 * Structured Query Language
 * Create a simple Table
 * Handle Data
 * Example Database Structure
 * Example Database Data
 * SELECT: Fundamentals
 * COMMIT and ROLLBACK
 * INSERT 1
 * UPDATE 1
 * DELETE 1
 * SELECT: Join Operation
 * SELECT: Grouping
 * SELECT: IS NULL Predicate
 * SELECT: Predefined Functions
 * SELECT: Set Operations
 * SELECT: Case Expression
 * SELECT: Subquery
 * Views
 * INSERT 2
 * UPDATE 2
 * MERGE
 * DELETE 2
 * TRUNCATE
 * Create Table
 * Data Types
 * Foreign Key
 * Alter Table
 * Drop Table
 * Temporary Table
 * Managing Indexes
 * Managing Rights
 * Like Predicate
 * Quantified Comparision
 * Rollup Cube
 * Recursions
 * NULLs and the Three Valued Logic
 * Transactions
 * Glossary