C.J. Date's SQL and Relational Theory Master Class
How to Write Accurate SQL Code
Publisher: O'Reilly Media
Released: April 2010
Run time: 16 hours 32 minutes

SQL is ubiquitous, but it's also complicated, difficult, and error prone. In this video, C.J. Date -- the world's best-known relational advocate -- shows you 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.

What makes SQL so complicated? Duplicate rows and nulls provide two obvious examples, but they're not the only ones. With C.J. Date's clear and concise instruction, you'll learn relational theory, how SQL departs from the theory, and how to avoid the problems that can cause.

You should have at least an elementary familiarity with database concepts in general and the SQL language in particular before watching the video. After viewing the video, you will:

  • Have a solid understanding of relational theory
  • Appreciate how that theory provides SQL's logical underpinnings
  • Understand the breadth and depth of that theory
  • Know how to formulate complex SQL code with confidence that it's correct
  • Generally, be able to use SQL relationally

By using the relational model as an organizing principle, and learning various features of the model in depth, you'll discover the best ways to implement SQL. And you'll enjoy the benefits of working with a truly relational system.

Table of Contents
Product Details
About the Author
Recommended for You
Companion Products
SQL and Relational Theory
By C.J. Date
January 2009
Ebook:  $31.99
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
O'Reilly MediaC.J. Date's SQL and Relational Theory Master Class
 
4.8

(based on 8 reviews)

Ratings Distribution

  • 5 Stars

     

    (6)

  • 4 Stars

     

    (2)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

100%

of respondents would recommend this to a friend.

Pros

  • Easy to understand (4)
  • Accurate (3)
  • Helpful examples (3)

Cons

    Best Uses

    • Intermediate (5)
    • Expert (4)
      • Reviewer Profile:
      • Developer (3)

    Reviewed by 8 customers

    Sort by

    Displaying reviews 1-8

    Back to top

     
    5.0

    Most valuable tech training there is

    By kenzo

    from San Francisco Bay Area

    About Me Everyday Reader

    Verified Reviewer

    Pros

    • Deserves Multiple Readings
    • Easy To Understand
    • Exciting
    • Informative
    • Relevant
    • Well Written

    Cons

      Best Uses

        Comments about O'Reilly Media C.J. Date's SQL and Relational Theory Master Class:

        There is virtually no business process or work environment that doesn't rely on data exchange, data capture, and recording of data onto computers.

        Mr. Date is considered by many to be the world's top expert on how to work with data (I agree).

        Watching these videos offers a huge opportunity to super-charge your IT career due to the historical neglect of most IT practitioners to make the (small) effort neccessary to master these concepts. So if YOU make the effort, you WILL be a standout in your work environment. I guarantee it!

        Even for folks who will never be database designers or programmers, unless you plan on retiring soon to a South Sea island and living off coconuts this training is pretty much the best preparation there is for working in the 21st century.

        It should be a required course of study in high schools - and will be I believe in the not too distant future...

        Regarding the videos production, the quality is great. Audio and video quality is very high, and Mr. Date is an eloquent and engaging presenter- not to mention brilliant teacher.

        (2 of 2 customers found this review helpful)

         
        4.0

        The best introduction to C. J. Date

        By mapleoin

        from Czech Republic

        About Me Everyday Reader

        Verified Reviewer

        Pros

        • Clear
        • Deserves Multiple Readings
        • Easy To Understand
        • Informative
        • Relevant
        • Well Written

        Cons

        • Lack of dynamism

        Best Uses

          Comments about O'Reilly Media C.J. Date's SQL and Relational Theory Master Class:

          This video course is perhaps the best way to meet the famous C. J. Date and his astonishingly comprehensive style. The lectures are a great introduction to database theory while at the same time they lay a very solid foundation for any database practitioners or theorists. The author introduces some very useful theoretical notions that are essential to grasping the more subtle concepts of database design and he does so in a high-class fashion.

          C. J. Date's style of explaining and teaching, which can also be seen in his books, is didactic and very thorough while at the same time astonishingly clear. Many times while reading the book that these videos are based on and even afterward while watching the videos, I had to stop in order to reflect at the great volume of information that I had absorbed in a surprisingly simple manner. These videos are full of very deep notions about databases and can really benefit from reviewing at a later time, just to cement the knowledge or reflect on certain topics which come up during everyday practice.

          C. J. Date sets out to demolish SQL as a language fit for relational theory and databases in general. While going through all the database theory concepts he presents the ideal case and an ideal query language (actually not ideal, but as he demonstrates, the correct ones) contrasting them to generic SQL. He also posits and sets out to prove, in a very interesting argument, that relational databases are the only way to store data and all other data models will not endure.

          These are the days of NOSQL databases, but I think that the information contained in these lectures will be useful for a lot more time and in a lot more settings than just conventional SQL databases that are used in the majority of current systems. I oftentimes find myself thinking in relational terms even while designing the redis data model that I'm currently working on.

          Rating these videos 4 stars is just nit-picking, but I did feel sometimes that the lectures were a bit dull. It is also possible that I got this impression because I was watching too many without interruption :). While the content of the lectures is excellent, the presentation could be improved. Often times I felt that the audience present in the classroom could have done more to improve the dynamism of the lectures. It seemed that the only reason why they were there was so that the presenter wouldn't feel alone. I would have enjoyed more challenging questions and especially some skeptical comments from industry veterans perhaps. I'm sure those would have led to very interesting debates considering the high class of the lecturer and presumably, the attendants.

          (1 of 1 customers found this review helpful)

           
          5.0

          Simple and Clean presentation.

          By Chetankumar Akarte

          from Navi Mumbai, India

          About Me Developer

          Verified Reviewer

          Pros

          • Accurate
          • Easy to understand
          • Helpful examples

          Cons

            Best Uses

            • Intermediate

            Comments about O'Reilly Media C.J. Date's SQL and Relational Theory Master Class:

            I really appreciate the way he has used to introduce complex sql logic in the simpler way. To start with this video you must have the basic understanding of SQL. In this tutorial we start from the ground and moves towards the excel our logic to design a robust and maintainable database.
            This is not a simple tutorial series; it's a session and feels like you're attending the class in person. C.J. Date is a master in the SQL world and you can feel it while going through the session.

            Wanna dig deep in the world of SQL. Then why not learn from an expert? "C.J. Date's SQL and Relational Theory Master Class" is a very good series to start learning SQL.

             
            4.0

            Great Master Class

            By Lee the SQL slayer

            from Sydney, AU

            About Me Designer, Developer

            Verified Reviewer

            Pros

              Cons

                Best Uses

                • Expert
                • Intermediate

                Comments about O'Reilly Media C.J. Date's SQL and Relational Theory Master Class:

                This is quite an impressive resource for those interested in further developing their knowledge in SQL. It better suits if you have prior knowledge of SQL and how to design or structure databases otherwise it may not be worth your investment at this time as some topics can come across confusingly. CJ is an excellent instructor and you should find comfort in these videos. Just be mindful that this really is for those wanting to master the art of SQL and not simply starting out to learn it.

                The advantage to these videos is that it takes the level of learning further than if you were to teach yourself from the book (also a great addition). The masterclass has been produced during in/an actual class environment and is interspersed with shots of CJ at the head of the room talking to students but more importantly the majority of learning is visual presentations/images with a voice over of the presentation.

                Be prepared for a little bandwidth to be consumed if you take the plunge. The total size of the collection is over 4GB to download, enough video to fill a DVD full and a whopping 16 hours in length. The price at first glance is quite high for a video tutorial but given the expense of attending a 3 day class or conference, it is quite a reasonable purchase at a substantial savings in comparison.

                (1 of 1 customers found this review helpful)

                 
                5.0

                Great resource

                By jaype

                from Chicago IL

                Comments about O'Reilly Media C.J. Date's SQL and Relational Theory Master Class:

                I recently had a chance to review C.J. Date's video, Relational Theory Master Class. This is an excellent resource and I highly recommend it for anyone who wishes to better understand the theory behind relational database design. But be prepared; this is not a beginner's class. You should have a basic understanding of SQL and database design before viewing this video. And while the content is expensive at [$] I feel it's worth it. It's still cheaper than attending a similar seminar in person, and you can review it whenever you like.The video is a companion to Date's book, SQL and Relational Theory, but it's not required to read or purchase the book too. There's 16 hours of video content, and I feel the class does a better job of describing relational theory. One of the features of the video I like is that it's not static; that is, the camera focus is not always on the speaker or a slide deck. Moving between the speaker, the audience, and the content keeps the viewer's interest. And you can hear the questions asked; it's almost like you're attending the class in person. The content is excellent. It's not centered on any specific platform. The methods you learn here help you to better understand why your table joins work the way they do, regardless if your database is Oracle or SQL Server. Once you better understand relation theory your code will make more sense. You can find SQL and Relational Theory Master Class at O'Reilly Books

                (1 of 1 customers found this review helpful)

                 
                5.0

                Excellent SQL Stuff

                By surachart

                from Bangkok, Thailand

                About Me DBA, Sys Admin

                Verified Reviewer

                Pros

                • Accurate
                • Helpful examples
                • Well-written

                Cons

                  Best Uses

                  • Expert
                  • Intermediate
                  • Novice
                  • Student

                  Comments about O'Reilly Media C.J. Date's SQL and Relational Theory Master Class:

                  When we need to write accurate SQL Code and improve SQL knowledge, I recommend this C.J. Date's SQL and Relational Theory Master Class: How to Write Accurate SQL Code Video. 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.

                   
                  5.0

                  SQL and Relational Theory Master Class

                  By surachart

                  from Bangkok, Thailand

                  About Me DBA, Sys Admin

                  Pros

                  • Sql

                  Cons

                    Best Uses

                    • Expert
                    • Intermediate
                    • Novice
                    • Student

                    Comments about O'Reilly Media C.J. Date's SQL and Relational Theory Master Class:

                    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.

                    (3 of 3 customers found this review helpful)

                     
                    5.0

                    Excelent wisdom

                    By Kaveh Mousavi

                    from Malaysia

                    About Me Developer

                    Verified Reviewer

                    Pros

                    • Accurate
                    • Concise
                    • Easy to understand
                    • Helpful examples

                    Cons

                      Best Uses

                      • Expert
                      • Intermediate

                      Comments about O'Reilly Media C.J. Date's SQL and Relational Theory Master Class:

                      I like the video more,

                      It explains the content of the related book thoroughly, with some more details that cannot be included in the books.

                      Displaying reviews 1-8

                      Back to top

                       
                      Buy 2 Get 1 Free Free Shipping Guarantee
                      Buying Options
                      Immediate Access - Go Digital what's this?
                      Video: $299.99
                      (Streaming, Downloadable)