Best relational databases books according to Reddit

Reddit mentions of The Art of SQL

Sentiment score: 4
Reddit mentions: 10

We found 10 Reddit mentions of The Art of SQL. Here are the top ones.

The Art of SQL #2
    Features:
  • ISBN13: 9780596008949
  • Condition: New
  • Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!
Specs:
Height9.19 Inches
Length7 Inches
Number of items1
Release dateMarch 2006
Weight1.27 Pounds
Width0.86 Inches
#1 of 20

idea-bulb Interested in what Redditors like? Check out our Shuffle feature

Shuffle: random products popular on Reddit

Found 10 comments on The Art of SQL:

u/tweaqslug · 4 pointsr/Database

Do you expect more than a few thousand people will access this system. If not then definitely stick with an RDBMS. NoSQL is generally only appropriate if you need blindlingly fast reads, tolerably slow writes, and scalability with commodity hardware. RDBMSes give you balance of read and write throughput for a less-than-crazy number of users, and they make it far easier to maintain data integrity.

Working with relational data is as much art as skill. Even for something as simple as an inventory system (the 'Hello World' of databases) there are a number of choices to make and peculiarities to troubleshoot.

In addition to whatever database specific books you may need, I would suggest you pick up
The Art of SQL. It teaches how think about data and relationships declaratively and to understand complex data systems from the outside in.

u/qtuner · 3 pointsr/programming

If you want to be good at sql, you have to think in sets. Also you need to pic a platform to learn on because even tho SQL is a standard, the sql will look different on different platforms.

  1. documentation of sql implementation. (ie books online for sql server)

  2. http://www.amazon.com/Database-Depth-Relational-Theory-Practitioners/dp/0596100124/ref=sr_1_fkmr0_1?ie=UTF8&qid=1269299550&sr=1-1-fkmr0

  3. http://www.amazon.com/Art-SQL-Stephane-Faroult/dp/0596008945/ref=sr_1_5?ie=UTF8&s=books&qid=1269299574&sr=1-5

    these books balance each other out. Start with Date first. Celko can get you into trouble in places.

    edit: i just realized that the author wanted to learn sql, not how start out designing databases. Whoops. Syntax can be learned anywhere. The previous books will discuss how to build properly built databases. However poorly built databases will stress you SQL-fu
u/matthra · 3 pointsr/SQLServer

If it's something you might want to learn more on (as back end dev work can be very lucrative), I'd recommend a book, "The art of SQL". It's more than a simple text book or cookbook, it teaches you how to think about sql problems in the context of real world applications.

https://www.amazon.com/Art-SQL-Stephane-Faroult/dp/0596008945

edit Also pinal dave of SQL authority is a life saver, check out his blog at:
https://blog.sqlauthority.com/

u/rbatra · 2 pointsr/SQL
u/abattle · 2 pointsr/programming

A well-thumbed book sitting on my desk. Yet, the post in question wasn't addressing optimization as such. It was more of an overview of models and design with optimization considerations.

(Another favorite of mine is The art of SQL.)

u/Snaketruck · 1 pointr/learnprogramming

If you're talking about a publicly available dataset, it will probably be in a delimited format, like .csv or .tsv. Go get MySQL or even the Microsoft SQL Server free version and then you'll just import your dataset into your server and then you can start querying. It's been a while since I've looked, but you might still be able to pick up a free copy of AdventureWorks here, which is a nice starter database w/ several tables so you can figure out how joins work. As for books, I like the Murach books. A nice one for conceptual stuff (first few chapters) is The Art of SQL

u/datadude · 1 pointr/SQL

I wouldn't go that far, but the book has little practical value. Date is very knowledgeable, but he writes like an academic - he can take any piece of prose and suck the life out of it.
The Art of SQL is a much better book.

u/[deleted] · 0 pointsr/mysql

The Oracle training is outdated and irrelavant. The Percona training is up to date and very good. But both are aimed at DBA's, sysadmins, and application developers.

For your needs, you need to learn SQL, and learn to get useful information out of alien data sets.

Start with the basics:

u/theBlackDragon · 0 pointsr/java

I'd personally add
The Art of SQL

Not really suitable as a reference work though, but the information contained herein should be taught in school (but as evidenced by most developers' SQL skills, obviously isn't)