SQL and Relational Theory Master Class (How to Write Accurate SQL Code) by C.J. Date

What is SQL? SQL is referred to as Structured Query Language, is a database computer language designed for managing data in relational database management systems (RDBMS), and originally based upon relational algebra. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.
SQL is ubiquitous, but it's also complicated, difficult, and error prone.
"C.J. Date's SQL and Relational Theory Master Class" How to Write Accurate SQL Code by C. J. Date is the excellent video(16 hours), We will learn the world's best-known relational advocate and how to write SQL code that's logically correct, how to avoid various SQL traps and pitfalls, and, more generally, how to use SQL as if it were a true relational language.

Table of Contents
- Setting the Scene Part 1 - 2
- Types and domains Part 1 - 3
- Tuples and Relations, Rows and Tables Part 1 - 2
- No Duplicates, No Nulls Part 1 - 2
- Base Relvars, Base Tables Part 1 - 3
- SQL and Relational Algebra I: The Original Operators Part 1 - 2
- SQL and Relational Algebra II: Additional Operators Part 1 - 2
- SQL and Constraints Part 1 - 2
- SQL and Views Part 1 - 2
- SQL and logic I: Relational Calculus Part 1 - 4
- SQL and Logic II: Using Logic to Write SQL Code Part 1 - 2
- The Relational Model
- Database Design Theory Part 1 - 2

When... We need to write accurate SQL Code, I recommend this Videos (C.J. Date's SQL and Relational Theory Master Class: How to Write Accurate SQL Code) and (SQL and Relational Theory book). This will helpful our thought about SQL.
We will start about SQL relationally theory, learn the difference between relation values and relation variables, a detailed examination of the original relational operators (join, etc.) and logic in the relational model.

Some Sample:
- Types and domains Part 1 - 3
We will learn relations and basic understanding of elementary type theory is a prerequisite to understanding everything that follows.
- Tuples and Relations, Rows and Tables Part 1 - 2
We will learn tuples and relations (rows and tables, in SQL terms) the fundamental building blocks of the relational model.
- No Duplicates, No Nulls Part 1 - 2
We will learn duplicates and nulls, they are two of the most obvious SQL departures from the relational model. This session explains in detail some of the problems those departures cause, and why duplicates and nulls should be avoided.
- The Relational Model
This session is the first of three appendixes to the main body of the seminar. Among other things, it offers a precise definition of the relational model, and it offers strong evidence to support the contention that the relational model will stand the test of time.
- Database Design Theory Part 1 - 2
We will learn logical design theory... Essentially normalization and denormalization.
...more

Christopher J. Date attended High Wycombe Royal Grammar School (U.K.) from 1951 to 1958 and received his B.A. in Mathematics from Cambridge University (U.K.) in 1962. He entered the computer business as a mathematical programmer at Leo Computers Ltd. (London), where he quickly moved into education and training. In 1966, he earned his Master's degree at Cambridge, and, in 1967, he joined IBM Hursley (U.K) as a programming instructor. Between 1969 and 1974, he was a principal instructor in IBM's European education program.