SQL and Relational Theory 2011

SQL is ubiquitous. But SQL is complicated, difficult, and error prone (much more so than SQL advocates would have you believe), and testing can never be exhaustive. So to have any hope of writing correct SQL, you must follow some discipline. What discipline? Answer: The discipline of using SQL relationally.

What you will learn
-How relational principles provide SQL's logical underpinnings
-The breadth and depth of those principles
-How to formulate complex SQL code with confidence that it's correct
-Generally, be able to use SQL relationally

Main Topics
-Setting the scene
-Types and domains
-Tuples and relations, rows and tables
-No duplicates, no nulls
-Base relvars, base tables
-SQL and relational algebra I: The original operators
-SQL and relational algebra II: Additional operators
-SQL and constraints
-SQL and views
-SQL and logic I: Relational calculus
-SQL and logic II: Using logic to write SQL code
-Further SQL topics
-The relational model
-Database design theory