C.J. Date's SQL and Relational Theory Master Class
How to Write Accurate SQL Code
Publisher: O'Reilly Media
Final Release Date: 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
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyC.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

No Cons

Best Uses

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

Reviewed by 8 customers

Displaying reviews 1-8

Back to top

(1 of 1 customers found this review helpful)

 
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 oreilly 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 oreilly 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 oreilly 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 oreilly 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 oreilly 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 oreilly 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 oreilly 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 oreilly 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:  $499.99
                    (Streaming, Downloadable)