Reddit reviews The Art of SQL
We found 10 Reddit comments about The Art of SQL. Here are the top ones, ranked by their Reddit score.
ISBN13: 9780596008949Condition: NewNotes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!
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.
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.
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
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/
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.)
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
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.
http://www.amazon.com/SQL-Antipatterns-Programming-Pragmatic-Programmers/dp/1934356557/ref=pd_sim_b_3
http://www.amazon.com/Joe-Celkos-SQL-Smarties-Programming/dp/1558605762
http://www.amazon.com/Art-SQL-Stephane-Faroult/dp/0596008945/ref=pd_sim_b_4
http://www.amazon.com/SQL-Relational-Theory-Write-Accurate/dp/0596523068/ref=pd_sim_b_7
And then read a book on whichever dialect of SQL you're using, because they're pretty different.
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:
You Can download some example databases:
I suggest you buy a book called 'The Art of SQL':
SQL is essentially math and programming. Having a good book for reference is highly recommended.
MySQL workbench is a pretty handy tool. If you are going to connect to multiple databases (Oracle, MySQL, MS SQL, DB2 etc) then maybe look at a Navicat or RazorSQL license.
For when you are feeling more confident with SQL, either look at learning VBA in Excel or Python and the PyData Libraries:
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)