Reddit mentions: The best databases books

We found 17 Reddit comments discussing the best databases books. We ran sentiment analysis on each of these comments to determine how redditors feel about different products. We found 4 products and ranked them based on the amount of positive reactions they received. Here are the top 20.

1. Head First SQL: Your Brain on SQL -- A Learner's Guide

    Features:
  • O Reilly Media
Head First SQL: Your Brain on SQL -- A Learner's Guide
Specs:
Height9.25 Inches
Length8 Inches
Number of items1
Weight2.45 Pounds
Width1.23 Inches
▼ Read Reddit mentions

2. Learning SQL: Master SQL Fundamentals

    Features:
  • O Reilly Media
Learning SQL: Master SQL Fundamentals
Specs:
Height9.19 Inches
Length7 Inches
Number of items1
Weight1.19270083742 Pounds
Width0.9 Inches
▼ Read Reddit mentions

3. Sql in a Nutshell (In a Nutshell (O'Reilly))

Sql in a Nutshell (In a Nutshell (O'Reilly))
Specs:
Height9 Inches
Length6 Inches
Number of items1
Release dateDecember 2008
Weight1.77031196386 Pounds
Width1.2 Inches
▼ Read Reddit mentions

4. Simply SQL: The Fun and Easy Way to Learn Best-Practice SQL

Used Book in Good Condition
Simply SQL: The Fun and Easy Way to Learn Best-Practice SQL
Specs:
Height9 Inches
Length7 Inches
Number of items1
Weight1.13097140406 Pounds
Width0.69 Inches
▼ Read Reddit mentions

🎓 Reddit experts on databases books

The comments and opinions expressed on this page are written exclusively by redditors. To provide you with the most relevant data, we sourced opinions from the most knowledgeable Reddit users based the total number of upvotes and downvotes received across comments on subreddits where databases books are discussed. For your reference and for the sake of transparency, here are the specialists whose opinions mattered the most in our ranking.
Total score: 4
Number of comments: 2
Relevant subreddits: 1
Total score: 4
Number of comments: 2
Relevant subreddits: 1
Total score: 3
Number of comments: 1
Relevant subreddits: 1
Total score: 2
Number of comments: 1
Relevant subreddits: 1
Total score: 2
Number of comments: 1
Relevant subreddits: 1
Total score: 2
Number of comments: 1
Relevant subreddits: 1
Total score: 1
Number of comments: 1
Relevant subreddits: 1
Total score: 1
Number of comments: 1
Relevant subreddits: 1
Total score: 0
Number of comments: 1
Relevant subreddits: 1
Total score: 0
Number of comments: 1
Relevant subreddits: 1

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

Shuffle: random products popular on Reddit

Top Reddit comments about Other Databases:

u/CodeTamarin · 2 pointsr/computerscience

The Stanford Algorithm book is complete overkill in my opinion do NOT read that book. That's insane. Read it when you've been doing programming for a while and have a grasp of how it even applies.

Here's my list, it's a "wanna be a decent junior" list:

  • Computer Science Distilled
  • Java/ C# / PHP/ JS (pick one)
  • Do some Programming Challenges
  • SQL
  • Maybe build a small web app. Don't worry about structure so much, just build something simple.
  • Applying UML: and Patterns: An Introduction to Object Oriented Anaysis and Design Iterative Development
  • Head First Design Patterns
  • Clean Architecture
  • Refactoring: Improving the Design of Existing Code
  • If you're interested in Web
  • Soft Skills: Power of Habit , A Mind for Numbers , Productivity Project

    ​

    Reasoning: So, the first book is to give you a sense of all that's out there. It's short and sweet and primes you for what's ahead. It helps you understand most of the basic industry buzz words and whatnot. It answers a lot of unknown unknowns for a newbie.

    Next is just a list languages off the top of my head. But you can pick anything, seriously it's not a big deal. I did put Java first because that's the most popular and you'll like find a mountain of resources.

    Then after some focused practice, I suggest grabbing some SQL. You don't need to be an expert but you gotta know about DBs to some degree.

    Then I put an analysis book that's OOP focused. The nifty thing about that book, is it breaks into design patterns nicely with some very simple design patters to introduce you to design patterns and GRASP.

    Then I put in a legit Design Patterns book that explains and explores design patterns and principles associated with many of them.

    Now that you know how code is structured, you're ready for a conversation about Architecture. Clean architecture is a simple primer on the topic. Nothing too crazy, just preps you for the idea of architecture and dealing with it.

    Finally, refactoring is great for working devs. Often your early work will be focused on working with legacy code. Then knowing how to deal with those problems can be helpful.

    FINAL NOTE: Read the soft skills books first.

    The reason for reading the soft skills books first is it helps develop a mental framework for learning all the stuff.

    Good luck! I get this isn't strictly computer science and it's likely focused more toward Software Development. But I hope it helps. If it doesn't. My apologies.
u/letseatlunch · 2 pointsr/actuary

software developer here. I use sql every day and its an integral part of the majority of the software i work on. That said i would NOT recommend w3schools for sql. w3schools is a great "reference" site for html,css, and sometimes javascript. Meaning it has a lot of information but isn't the best place to learn sql but a good resource once you know it. also w3schools has slowly but surely fallen behind its former glory.

I'd recomend picking up one or more books off amazon. With sql its important to have a database set up to help you learn. if you already do i'd go with: http://www.amazon.com/SQL-Nutshell-OReilly-Kevin-Kline/dp/0596518846/ref=sr_1_16?ie=UTF8&qid=1318654308&sr=8-16. O'reilly makes a large number of computer language related books and its going to take you step by step through learning sql. If you don't have a database set up already and are not sure where to begin then go with: http://www.amazon.com/Language-SQL-Access-Relational-Databases/dp/143545751X/ref=sr_1_12?ie=UTF8&qid=1318654308&sr=8-12. the first chapter(s) are devoted to installing and setting up either Microsoft Sql Server or MySql (and maybe oracle sql developer too) the three most popular database systems used. then its going to walk you threw, step by step, the one you choose.

I'll add im not an actuary so i cant make to many assumptions on what you already know and what you don't but as a software developer find some hands on resources to teach you is definitely what i'd recommend, and there are lots of good and cheep books on amazon to help you do that.

Lastly you may want to post this question on r/programming or r/sql or something like that explaining your situation and they might have even better recommendations.

u/MercurialNerd · 2 pointsr/mysql

I've studied for the 5.0 Developer cert, and the 5.6 Developer cert, and I've also mentored about 100 students through these exams. Most/all of the students were new to database development, so I had to teach them from zero to Oracle Certified in the space of about 10 weeks.

To echo what /u/justintxdave said, the 5.6 Developer exam is tough. A lot of the questions are deliberately obtuse in my opinion and seem designed to catch you out. Plus they have questions on Java talking to MySQL, PHP talking to MySQL and Microsoft .NET talking to MySQL. This seems a little unfair to me - if you're a PHP developer, you're unlikely to know .NET and vice-versa.

The 5.0 Certification Study Guide is still a good resource, but you need to be careful to identify those things that have changed from 5.0 to 5.6 - e.g. DATETIME, TIMESTAMP, SQL MODES, and there are topics in the new Developer exam that were in the old DBA exam - transactions, foreign key constraints etc. The sample questions on the DVD of 5.0 book are a good practice tool.

Here's the list of topics I studied for the 5.6 exam, and what books/resources I used.

Study Guide refers to the 5.0 Certification Study Guide , and the relevant chapter numbers.

Head First SQL is a very basic beginners guide to SQL that you probably don't need.

I also used Paul du Bois's MySQL Developer's Library to fill in some blanks.

There is was a real need for an official 5.6 Certification book, but at this stage an 8.0 cert is probably just around the corner. I always had a notion I might write a 5.6 book, but life got in the way :)

Best of luck with the exam!

u/jackmaney · 2 pointsr/datascience

Besides Python, I'd also recommend getting proficient in SQL. It's often quicker to perform aggregations and other calculations in the database. If you're already familiar with a programming language (especially C++), then SQL should be no trouble. While there's plenty of stuff online, I've found Head First SQL to be a good introductory book for folks who have never seen SQL or touched a database before (it may or may not be too elementary for someone that can already program, however...).

Data scientists don't have to know as much programming as the average software engineer, but you should be comfortable enough to adapt or wrap code around existing libraries. For example:

  • Clustering a dataset via k-means for several different values of k (using a built-in library such as scikit-learn), and then using the average silhouette coefficient to find the best value of k.

  • Combining cross-validation with reservoir sampling.

  • Implementing an algorithm that isn't yet implemented in a third party library.

    In general, don't be comfortable with just using software as a "black box" for statistical and scientific computing. Have at least some idea of what's going on "under the hood" when that black box is used. That will put you far ahead of the game.
u/RangerPretzel · 1 pointr/csharp

I found the HeadFirst series on SQL helpful: https://www.amazon.com/Head-First-SQL-Brain-Learners/dp/0596526849

The stock photo of the person on the cover is silly, but if you can get past the cover, the book itself is quite good.

As a bonus, I found that after I got used to writing SQL queries, my LINQ queries got a lot better, too.

u/guy_incognito784 · 1 pointr/vba

I personally used John Walkenbach's books on VBA to learn over 10 years ago. They were tremendously helpful and good for the intermediate to advance VBA programmer so I'd recommend his VBA books (he also writes general books on advanced Excel techniques but for purposes of this discussion, I'd opt for his books that relate to solely VBA).

Knowing SQL also helps when pulling raw data from databases for use in custom reports and models. I used this to help me out with SQL, http://www.amazon.com/Learning-SQL-Alan-Beaulieu/dp/0596520832/ref=sr_1_3?s=books&ie=UTF8&qid=1426696057&sr=1-3&keywords=SQL

Hope this helps.

u/[deleted] · 1 pointr/SQL

I thought the book Head First SQL was extremely useful. It did a great job of explaining the concepts and getting me comfortable using SQL.

u/bpgoldsb · 0 pointsr/sysadmin

I highly, highly recommend Learning SQL by O'Reilly. Good for newbies to learn the basics, and more intermediate people to learn advanced things like joins.

I've given this book to new IT folks, experienced, and even non-IT people who wanted to learn how to query a database.

Edit: It's written to be agnostic. MSSQL, MySQL, Oracle, or Postgres.

http://www.amazon.com/Learning-SQL-Alan-Beaulieu/dp/0596520832

u/jtreminio · 3 pointsr/PHP

Intro to PHP/MySQL: http://www.amazon.com/Head-First-MySQL-Lynn-Beighley/dp/0596006306

More advanced SQL knowledge: http://www.amazon.com/Head-First-SQL-Brain-Learners/dp/0596526849

More advanced PHP knowledge: http://www.amazon.com/PHP-Object-Oriented-Solutions-David-Powers/dp/1430210117

Go in that order, you'll be very comfortable in a few months.

u/c64guy · 0 pointsr/learnprogramming

Take a look at Head First SQL. I have not read this book specifically but have completed other Head first books on programming.

The Head First series provides in interactive way to learn with practice exercises and examples. Oh, and it can even be fun.

u/jabwork · 1 pointr/Python

What is it you actually want to learn?

If you just want to learn how to SELECT and INSERT data the DB API 2 documentation should be sufficient. You'll need a MySQL python driver. I'd suggest either "MySQLdb" (old, lots of old web pages referencing it) or "oursql" (strongly pushed by the people in #python the last time I visited, which was admittedly a while ago)

If you want to learn generic SQL and how to use Python with SQL, and the MySQL part is just because it's free/easy, I'd recommend Head First SQL. It doesn't cover python at all, but the DB API 2 driver is extremely straightforward

If you want to learn something else .... what is it you want to learn?

u/power_walker · 2 pointsr/SQL

I really enjoyed and was able to build a strong foundation with Head First SQL

http://www.amazon.com/Head-First-SQL-Brain-Learners/dp/0596526849/ref=sr_1_1?ie=UTF8&qid=1416913925&sr=8-1&keywords=head+first+sql&pebp=1416913929647

Orielly used to publish the first chapter online but I can't find t on their site right now.