Just because you work with SQL Server does not make you a master at it. But by taking the time and learning SQL's underlying theory, you have the best guarantee that your SQL code will be correct and that your system will be robust and maintainable. In SQL And Relational Theory Master Class, you will learn how to apply relational theory directly to the your use of SQL.
With the use of video training, SQL And Relational Theory Master Class goes beyond the book; through the use of many examples, Chris Date (evangelist to his mentor E.F. "Ted" Codd, the inventor of the relational model for database management) will show how to really understand relational theory so you can become a master.
Normally, this class is taught by the instructor over the course of three days. This video is divided in to 31 separate sections of reasonable length to take in one at a time and it runs 16 hours in total. I have broken this material down into 14 topic areas that are covered.
1. "Setting the Scene" reviews relational model basics and looks at the important properties of relations. It also introduces a crucial logical difference between relation values and relation variables.
2. "Types and Domains" shows that relations are defined over types (also known as domains) and so a basic understanding of elementary type theory is a prerequisite to understanding SQL theory.
3. "Tuples and Relations, Rows and Tables" takes a careful look at tuples and relations (what are referred to as rows and tables, in SQL parlance) which are the fundamental building blocks of the relational model.
4. "No Duplicates, No Nulls" are two of the most obvious SQL departures from the relational model. That is, based off of Codd's model, duplicate records were not allowed. Duplicate entries are a product of database committees and DBMS developers. This session explains in detail what some of the problems those departures have caused, and why duplicates and nulls should be avoided.
Article comments