4 ms·

What's the canonical reference book one should go to regarding SQL? (ie K&R is the book you go to for C) I understand there are differences between DB vendors,

What's the canonical reference book one should go to regarding SQL? (ie K&R is the book you go to for C) I understand there are differences between DB vendors, but my question is about general patterns and best practices.

sauce71 10y ago
Joe Celko's "SQL for Smarties" ... and then the other SQL books by Celko
- matwood 10y ago
  Great book! Also, go read jOOQs blog: https://blog.jooq.org/ https://blog.jooq.org/
stevecalifornia 10y ago
SQL Pocket Guide. Thin, small book. No fluff. Just syntax and solutions for all the major vendors. If I could only have one book while developing it would be this one. https://www.amazon.com/SQL-Pocket-Guide-Jonathan-Gennick/dp/1449394094/ref=sr_1_1?ie=UTF8&qid=1468271993&sr=8-1&keywords=SQL+pocket+guide https://www.amazon.com/SQL-Pocket-Guide-Jonathan-Gennick/dp/...
hackits 10y ago
I found that basic courses on relational algebra more useful than most text books. They seem to introduce the mathematics in a more clear concise way than most SQL books.
crdb 10y ago
Chris Date's Introduction to SQL [1], or Edgar Codd's last book [2]. Actually both are worth reading to discuss differences in philosophy (e.g. "no NULLs" vs 4-valued logic including "unknown" and "not applicable" NULLs). [1] https://www.amazon.com/Introduction-SQL-Mastering-Relational-Database/dp/0321305965 https://www.amazon.com/Introduction-SQL-Mastering-Relational... [2] https://www.amazon.com/Relational-Model-Database-Management-Version/dp/0201141922/ref=sr_1_1 https://www.amazon.com/Relational-Model-Database-Management-...
- qilo 10y ago
  First book [1] is not by C. J. Date. So, is this the book you recommend and just mixed up the author's name, or... ?
  - crdb 10y ago
    Good catch. Too late to edit the comment. Yes, I meant C.J. Date's "Introduction to SQL". I was trying to get a link to the latest edition which appeared to be the 2nd link on an Amazon search for "Date introduction to SQL"... anyway, it is continuously edited so it's worth seeking the latest version which has twice as many pages as some of the earlier ones.
    - qilo 10y ago
      The thing is, and I probably should have pointed it out in the first comment, sorry about that: I can't find such a book by Cris Date. My guess is you meant "Introduction to Database Systems".
      - crdb 10y ago
        Yes, you are right. Database Systems.
combatentropy 10y ago
> What's the canonical reference book > one should go to regarding SQL? > (ie K&R is the book you go to for C) > > I understand there are differences between DB vendors, > but my question is about general patterns and best practices. For 10 years I've looked and never found one. I find Chris Date pedantic. The rest are a mish-mash of cookbooks, vendor-specific ones, and some that try to be the general guide you're looking for but collapse beneath the weight of hundreds of pages of prose that seems to have been written by a committee of robots.
a-saleh 10y ago
As far as I know, you are probably looking for Jeffrey D. Ullman [1]? I think my lecturer at my local university basically stole [2] when he taught our course :) Just be aware that he is an academic, so I might compare him more to A.S.Tanenbaum than K&R :-) [1] http://infolab.stanford.edu/~ullman/ http://infolab.stanford.edu/~ullman/ [2] http://infolab.stanford.edu/~ullman/dscb.html#slides http://infolab.stanford.edu/~ullman/dscb.html#slides
plasticsyntax 10y ago
I found SQL Antipatterns by Bill Karwin to be a great book on the topic of patterns and best practices with SQL. As a bonus, it's relatively platform agnostic if I recall correctly.
sn9 10y ago
Not a book, but Stanford's Intro to Databases by Jennifer Widom is offered for free online and I've heard nothing but great things about it. https://lagunita.stanford.edu/courses/DB/2014/SelfPaced/about https://lagunita.stanford.edu/courses/DB/2014/SelfPaced/abou...

sauce71 10y ago

Joe Celko's "SQL for Smarties" ... and then the other SQL books by Celko

matwood 10y ago
Great book! Also, go read jOOQs blog: https://blog.jooq.org/ https://blog.jooq.org/

stevecalifornia 10y ago

SQL Pocket Guide. Thin, small book. No fluff. Just syntax and solutions for all the major vendors. If I could only have one book while developing it would be this one. https://www.amazon.com/SQL-Pocket-Guide-Jonathan-Gennick/dp/1449394094/ref=sr_1_1?ie=UTF8&qid=1468271993&sr=8-1&keywords=SQL+pocket+guide https://www.amazon.com/SQL-Pocket-Guide-Jonathan-Gennick/dp/...

hackits 10y ago

I found that basic courses on relational algebra more useful than most text books. They seem to introduce the mathematics in a more clear concise way than most SQL books.

crdb 10y ago

Chris Date's Introduction to SQL [1], or Edgar Codd's last book [2]. Actually both are worth reading to discuss differences in philosophy (e.g. "no NULLs" vs 4-valued logic including "unknown" and "not applicable" NULLs). [1] https://www.amazon.com/Introduction-SQL-Mastering-Relational-Database/dp/0321305965 https://www.amazon.com/Introduction-SQL-Mastering-Relational... [2] https://www.amazon.com/Relational-Model-Database-Management-Version/dp/0201141922/ref=sr_1_1 https://www.amazon.com/Relational-Model-Database-Management-...

qilo 10y ago
First book [1] is not by C. J. Date. So, is this the book you recommend and just mixed up the author's name, or... ?
- crdb 10y ago
  Good catch. Too late to edit the comment. Yes, I meant C.J. Date's "Introduction to SQL". I was trying to get a link to the latest edition which appeared to be the 2nd link on an Amazon search for "Date introduction to SQL"... anyway, it is continuously edited so it's worth seeking the latest version which has twice as many pages as some of the earlier ones.
  - qilo 10y ago
    The thing is, and I probably should have pointed it out in the first comment, sorry about that: I can't find such a book by Cris Date. My guess is you meant "Introduction to Database Systems".
    - crdb 10y ago
      Yes, you are right. Database Systems.

combatentropy 10y ago

> What's the canonical reference book > one should go to regarding SQL? > (ie K&R is the book you go to for C) > > I understand there are differences between DB vendors, > but my question is about general patterns and best practices. For 10 years I've looked and never found one. I find Chris Date pedantic. The rest are a mish-mash of cookbooks, vendor-specific ones, and some that try to be the general guide you're looking for but collapse beneath the weight of hundreds of pages of prose that seems to have been written by a committee of robots.

a-saleh 10y ago

As far as I know, you are probably looking for Jeffrey D. Ullman [1]? I think my lecturer at my local university basically stole [2] when he taught our course :) Just be aware that he is an academic, so I might compare him more to A.S.Tanenbaum than K&R :-) [1] http://infolab.stanford.edu/~ullman/ http://infolab.stanford.edu/~ullman/ [2] http://infolab.stanford.edu/~ullman/dscb.html#slides http://infolab.stanford.edu/~ullman/dscb.html#slides

plasticsyntax 10y ago

I found SQL Antipatterns by Bill Karwin to be a great book on the topic of patterns and best practices with SQL. As a bonus, it's relatively platform agnostic if I recall correctly.

sn9 10y ago

Not a book, but Stanford's Intro to Databases by Jennifer Widom is offered for free online and I've heard nothing but great things about it. https://lagunita.stanford.edu/courses/DB/2014/SelfPaced/about https://lagunita.stanford.edu/courses/DB/2014/SelfPaced/abou...