Relational Theory for Computer Professionals
A Hands-On Video Workshop
Publisher: O'Reilly Media
Final Release Date: May 2013
Run time: 9 hours 57 minutes

All of today’s mainstream database products support the SQL language, and relational theory is what SQL is supposed to be based on. But are those products truly relational? Sadly, the answer is no. In this video, Chris Date—author, lecturer, researcher, and consultant, specializing in relational database technology—shows you what a real relational product would be like, and how and why it would be so much better than what’s currently available.

With this video, you will:

  • Learn how to see database systems as programming systems
  • Get a careful, precise, and detailed definition of the relational model
  • Explore a detailed analysis of SQL from a relational point of view

There are literally hundreds of resources on relational theory or the SQL language or both. But this video is different. First, nobody is more qualified than Chris Date to deliver this material. He and Ted Codd, inventor of the relational model, were colleagues for many years, and Chris’s involvement with the technology goes back to the time of Codd’s first papers in 1969 and 1970. Second, most books try to use SQL as a vehicle for teaching relational theory, but this Chris Date deliberately takes the opposite approach in this video. His primary aim is to teach relational theory as such. Then he uses that theory as a vehicle for teaching SQL, showing in particular how that theory can help with the practical problem of using SQL correctly and productively.

Any computer professional who wants to understand what relational systems are all about can benefit from this video. No prior knowledge of databases is assumed.

Table of Contents
Product Details
About the Author
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyRelational Theory for Computer Professionals
 
3.8

(based on 4 reviews)

Ratings Distribution

  • 5 Stars

     

    (2)

  • 4 Stars

     

    (1)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (1)

75%

of respondents would recommend this to a friend.

Pros

    Cons

      Best Uses

      • Student (3)

      Reviewed by 4 customers

      Sort by

      Displaying reviews 1-4

      Back to top

      (1 of 2 customers found this review helpful)

       
      1.0

      If Boredom had a full name...

      By Riccardo Audano

      from Chiavari (GE)

      About Me Developer, Educator

      Verified Reviewer

      Pros

        Cons

        • Astoundingly Boring
        • Too basic
        • Useless
        • Waste Of Time

        Best Uses

        • Alter To Death Punishment
        • Death By Boredom
        • Inflict Punishment
        • To Put Anyone To Sleep

        Comments about oreilly Relational Theory for Computer Professionals:

        ..it would be C.J.Date.
        Given Date's reputation I approached this "video workshop" with the best of hopes, but I was sorely, severely disappointed.
        First, it's not a workshop: one guy blabbering for hours and giving a few theoretical exercises once in a while is not a workshop. Not by any means. Date himself calls this "a seminar". I guess he's too snob to call it a class or a tutorial.
        As if this was not enough, his tone and attitude are unbearable. He patronizingly and pompously goes from obvious to irrelevant with an air of revealing you the deepest secrets of the universe...
        Second, it's totally useless: Date goes on and on endlessly finnicking about the most irrelevant details of the relational model and whining about how the database world and industry isn't doing everything he likes. Well, at least they are getting something done! To top it all, Date inflicts on his unfortunate listeners a full tutorial on Tutorial D, and alternative language to SQL that of course exist and is implemented only in his mind and in one obscure open source project. You will come out of this "seminar" with zero, I repeat ZERO useful knowledge,since Date takes ages to explain even the most basic concepts like what a key or a join is. And if you have no database experience please do not run away screaming from the field. It's an interesting , fascinating subject that luckily has left Date behind with all his finnicking...
        Finally, please note that this review doesn't come from a "only practical man". I have a MS in astrophysics, I love learning, I love theory, but I can tell interesting theory that adds to your understanding from boring blabbering about nothing...

        (1 of 2 customers found this review helpful)

         
        5.0

        Learn relational database degign right

        By jaype

        from Kenosha, WI

        About Me Database Administrator

        Verified Reviewer

        Pros

        • Accurate

        Cons

          Best Uses

          • Novice
          • Student

          Comments about oreilly Relational Theory for Computer Professionals:

          This is a good set of videos for anyone who has no experience with database design. Here you will learn the proper theory first, which is useful in whatever database you're working with.

          The quality of the videos is excellent. I like that they are downloadable, though you can watch online if you wish. They are short, none much over 30 minutes, so there are natural breaks.

          If you've seen C.J.Dates other videos or read his books you can skip this, there's nothing new. But it is still a great resource.

          (0 of 1 customers found this review helpful)

           
          4.0

          Excellent tutorial to relational theory

          By teak

          from Jyväskylä, Finland

          About Me Designer, Developer

          Verified Reviewer

          Pros

          • Accurate
          • Easy to understand
          • Helpful examples
          • Well-written

          Cons

            Best Uses

            • Novice
            • Student

            Comments about oreilly Relational Theory for Computer Professionals:

            This is my first review of video by O'Reilly. I received this video also free through blogger review program for review purposes.

            The lecture series goes through mathematical basis of relational theory and how bad SQL is in implementing the relational model and how can you force SQL being relational (this was news to me). Within this 10 hours you also get basics of good database design. Check the table of content of how time is spent in different topics, and don't forget to check the description from there too (it is spot-on).

            Don't forget to check the preview video. The style of presentation doesn't change so from this preview. Personally I like the minimalist style of slides and the style used by the lecturer. The lecturer was also good speaker and I did not have any problems in understanding the talk. The lecturer also repeats most of the questions presented to him so those are also clearly audible.

            Before this I did have some basic knowledge on how to use databases and MySQL, but without any real knowledge on what relational model is. Now I know that there is a solid mathematical basis and one can use this basis in design of the databases.

            There is only one caveat in whole video and it is in the description. You need to know basics of mathematical set theory in order to understand most of the stuff presented, this was not stressed enough in my opinion and in a product costing almost 100$ it should be. The need for understanding basic computer programming is given in the title. I would really love to give 5/5 for this product but I feel forced to take a single point away due to this minor issue in marketing of the product.

            4/5 (the actual video is 5/5, issue is in the description) with recommending to buy and watch if you have the money and you are interested in databases.

            (0 of 1 customers found this review helpful)

             
            5.0

            Useful to learn relational systems

            By surachart

            from Bangkok, Thailand

            About Me DBA, Educator, Sys Admin

            Pros

            • Concise
            • Helpful examples

            Cons

              Best Uses

              • Expert
              • Intermediate
              • Student

              Comments about oreilly Relational Theory for Computer Professionals:

              Useful too much to help us understand each topic for "what relational systems are all about" easily. You will enjoy with watching and practices, you will learn from questions and answers after finishing each topic, that will help you repeat idea and understand more.

              If you have a "Relational Theory for Computer Professionals" book, you should have this video as well. If you don't have a book. You should start with this video before.

              Displaying reviews 1-4

              Back to top

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