Table of Contents
Relational Model (defn)
Query Languages: Overview
Basic Relational Algebra Operators
Basic Relational Algebra Operators
Basic Relational Algebra Operations
SQL Queries: The Basic From
SQL Queries: Aliases
SQL Queries: Nesting
SQL Queries: Aggregation and Grouping
SQL:Union, Intersection, Difference
Nested Queries: Existential and Universal Quantification
Nested Queries: Set Comparison
PPT Slide
SQL Grouping: Conditions that Apply on Groups
PPT Slide
…and a Few “Dirty” Points
PPT Slide
SQL as a Data Manipulation Language: Updates and Deletions
|
Author: Yannis Papakonstantinou
|