Please Sign Up to Request This Product

C.J. Date's SQL and Relational Theory Master Class

How to Write Accurate SQL Code

You need to be an approved reviewer to request a product. Please sign up to request access or login to your account.

If you've already signed up and you haven't heard from us yet please email reviewers@oreilly.com and we will check on your request.

Description

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. You'll also learn relational theory, how SQL departs from the theory, and how to avoid the problems that can cause.

Reviews

On Sep 27 Ionut Artarisi wrote: The best way to meet C. J. Date
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. Full Review  >

Rating: StarStarStarStarStar4.0

On Jan 24 Chetankumar Akarte wrote: Review – C.J. Date’s SQL and Relational Theory Master Class
Review – C.J. Date’s SQL and Relational Theory Master Class- How to Write Accurate SQL Code Simple and Clean presentation. 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.… Full Review  >

Rating: StarStarStarStarStar5.0

On Dec 30 Lee Sheppard wrote: SQL Master Class
If you are using Wordpress, then learning SQL is a must if you are coding your own templates. This video masterclass is quite an impressive resource for those interested in further developing their knowledge in SQL. Full Review  >

Rating: StarStarStarStarStar4.0

On Dec 16 John Pertell wrote: SQL and Relational Theory Master Class by C.J. Date
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… Full Review  >

Rating: StarStarStarStarStar5.0

On Nov 30 Surachart Opun wrote: 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… Full Review  >

Rating: StarStarStarStarStar5.0

Receive free ebooks and videos in exchange for your reviews.

Join the O'Reilly Reader Review Program

Learn more >

Returning?

Top Reviewers

Michal Konrad Owsiak, 94 Reviews

Surachart Opun, 58 Reviews

Santosh Shanbhag, 58 Reviews

Doron Katz, 57 Reviews

Shawn Day, 55 Reviews

See More Reviewers >

Featured Review

Introducing Regular Expressions

Doron Katz wrote:
Great primer and reference in one book
An essential skill as a programmer, regardless of language, is to understand at least the… Full Review >

Rating: StarStarStarStarStar4.0