C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class
Publisher: O'Reilly Media
Final Release Date: April 2012
Run time: 10 hours 9 minutes

If you want to build databases that are robust, flexible, and accurate, you have to come to grips with design theory. But this theory is riddled with difficult terms and concepts that don’t seem to have much to do with design in practice. In this two-day master class, renowned expert C.J. Date bridges the gap by introducing design theory in ways practitioners can understand.

This painless introduction to design theory is for database professionals familiar with the relational model. Prior attendance at the C.J. Date Master Class SQL and Relational Theory: How to Write Accurate SQL Code is highly recommended. Classroom exercises are an integral part of the seminar, and attendee discussion and interaction are encouraged. You’ll receive a workbook containing copies of C.J. Date’s course slides.

Once you complete of this course, you will:

  • Understand, and be able to apply, the scientific principles of normalization and orthogonality that underlie design practice
  • Know which normal forms are important, how they differ from one another, and how to achieve them
  • Understand dependencies and the concepts of dependency inference and dependency preservation
  • Generally, understand the contributions (and the limitations) of design theory

Along the way, you’ll review aspects of design you should already be familiar with—although perhaps from unfamiliar perspective—and then explore in depth aspects you’re probably not familiar with. You’ll receive clear and accurate explanations and definitions of all pertinent concepts, without spending a lot of time on well-known material such as 2NF and 3NF.

About the speaker:

C.J. Date has a stature that’s unique in the database industry. Best known for his bestselling textbook, An Introduction to Database Systems (Addison-Wesley), he has been working with relational database theory since 1970. He enjoys a well-deserved reputation for his ability to explain complex technical issues in a clear and understandable fashion.

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

REVIEW SNAPSHOT®

by PowerReviews
oreillyC.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class
 
5.0

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (3)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

100%

of respondents would recommend this to a friend.

Pros

  • Accurate (3)

Cons

    Best Uses

      Reviewed by 3 customers

      Sort by

      Displaying reviews 1-3

      Back to top

      (2 of 2 customers found this review helpful)

       
      5.0

      Definitely worth the attention

      By mko

      from Poland

      About Me Developer

      Verified Reviewer

      Pros

      • Accurate
      • Concise

      Cons

      • Difficult to understand

      Best Uses

      • Expert
      • Intermediate

      Comments about oreilly C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class:

      Database Design and Relation Theory is targeted on database professionals. It means that you have to have some database related background already. If you don't, start with something else before you get into this one - for sure! Otherwise you might get lost in definitions and all the concepts presented in the seminar.

      Video training is based on the book with the same title. So, you can choose either the book itself, or this companion material. By the way, together with the Video training you get all the slides as well. This way it is super easy to follow the seminar in case you want to focus on some particular slide. And you always have the possibility to refresh your memory quickly in case there are references to topics that have been already discussed.

      They way material is presented is very concise and formal. You actually take a part in an academic lecture discussing Database Design. It will require lots of attention from your side and your brain will have to do work here. There is no chance for getting an easy path through it, unless you are already familiar with all the topics. You need to poses basic mathematical skills in terms of algebra of sets, basic knowledge of logic, and you should be familiar (maybe more suitable here would be comfortable) with the mathematical approach to proving theorems. It doesn't mean you will have to do this. But if you know what is it all about, it will be easier for you to follow the contents of the material.

      As for the time. Don't assume you will spent the same amount of time as specified in the description. I'd easily multiply it by two. The point here is that you will definitely need to go through the slides carefully (from time to time) to get the concepts fully understood. Sometimes you will probably jump back to what you have already seen just to recall some concepts and to make sure you are on the right track with you way of thinking.

      Even though this one is not an easy go, I'd definitely suggest it to people who are involved in database design. You might get surprised with some examples that are really counterintuitive. And (I must admit here) I was told some ideas in the past that were wrong by definition. Here, I got them explained once again - this time, the correct way.

      When it comes to the price, I must admit this one is quite costly. So, depending on your needs you might rather subscribe to safari books online instead. On the other hand, if you buy the video itself, you can transfer it to your iPad or Nexus with ease.

       
      5.0

      Learn Database Design from the best

      By Jaype

      from Kenosha, WI

      About Me Database Administrator

      Pros

      • Accurate
      • Well-written

      Cons

      • Not for beginners

      Best Uses

        Comments about oreilly C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class:

        This is a great video for anyone who wants to learn database design theory, or even for those who are already familiar. The content is not for beginners so don't buy it without first knowing something about database normalization. If you don't want to spend the money for the video buy the book (not needed for the video) instead, it has the same content.

        (2 of 2 customers found this review helpful)

         
        5.0

        Don't miss to get this stuff

        By surachart

        from Bangkok, Thailand

        About Me DBA, Educator, Sys Admin

        Pros

        • Accurate
        • Concise
        • Helpful examples

        Cons

          Best Uses

          • Expert
          • Intermediate
          • Novice
          • Student

          Comments about oreilly C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class:

          Nice... good stuff for Normal Forms. The Video quality is great.

          Some Idea for this video, It's easy, you can choose each topic you need to learn. In videos, You will learn a lot of idea. It's helpful to understand easy. Because you will be able to learn from examples in video and you can rewind again and again. Wow! that nice. Anyway, You can upload them to iPad/iPhone or etc. You can watch them while you are on the bus.

          If you are students? In Database course for College or University, I believe this video will help students for understand about Normalization and Relational concept... blah blah

          I don't see the reason what makes this video is useless. If you work in database career, or you are studying about Database Design ,Relational Theory or Normal Forms... and you are thinking to get some stuff about them, you should determine for this stuff.

          *** This video might be quite difficult to understand. But You can rewind again and again. ***

          Displaying reviews 1-3

          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)