Workshop · Rome, Italy
SQL and Relational Theory 2011
Computers - General · Information Technology
Key numbers
- Editions on record
- 3first in 2010
About SQL and Relational Theory
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
From our listing of this edition. Details may have changed since.
Editions
| Year | Dates | Where | Exhibitors | Visitors |
|---|---|---|---|---|
| 2012 | 29–31 Oct 2012 | Visconti Palace Hotel Rome, Italy | — | — |
| 2011 | 7–9 Nov 2011 | Visconti Palace Rome, Italy | — | — |
| 2010 | 8–10 Oct 2010 | Residenza di Ripetta Rome, Italy | — | — |
Past editions from the bvents archive (2008–2019) and organiser figures where they were published.