Projection
Selection
Cross Product and Natural Join
Practice exercises
SQL Revision History
Slides |
Paper
Aggregate operaters
Arithmetic expressions
Division
Except
Exists clause
GROUP BY functionality
Nested queries
Nested queries with correlation
NULL values
Search queries with strings
SELECT DISTINCT
Set comparison operators
Unions
Where Not Exists
Projection
Selection
Cross Product and Natural Join
Combining Operations
In Class Example
Aggregation
Entity vs attribute
ISA relationships
Participation and cardinality
Weak entity sets
Converting Entities
Converting Relationships
Converting Weak Entities
Ensuring Entity Integrity
Ensuring Referential Integrity
Creating a view at CSU
Updateable views
BCNF
Closure sets and Armstrong's Axioms
Decomposition into BCNF
Finding the candidate keys
Functional dependencies
Identifying Normal Formas
Lossless join and dependency preserving
Multivalued dependencies
Normal forms
Recognizing normal forms
Stanford Quizzes
Tree Indexing
Hashing
Extendible Hashing
Linear Hashing
Serializable Schedules
Locking
Aborts
Concurrency Examples
Lock Manager
Validation protocols
Multiversion timestamp example
Aries example - Analysis phase
Aries example - Redo phase
Aries example - Undo phase
Additional ARIES Examples
CLR records
Recovery