Reddit Reddit reviews SQL in 10 Minutes, Sams Teach Yourself (4th Edition)

We found 20 Reddit comments about SQL in 10 Minutes, Sams Teach Yourself (4th Edition). Here are the top ones, ranked by their Reddit score.

Computers & Technology
Books
SQL
Databases & Big Data
SQL in 10 Minutes, Sams Teach Yourself (4th Edition)
Sams Publishing
Check price on Amazon

20 Reddit comments about SQL in 10 Minutes, Sams Teach Yourself (4th Edition):

u/coffeecoffeecoffeee · 20 pointsr/statistics

You absolutely will need R and/or SAS to do any work beyond basic statistics. You'll have to know how to do data munging and how to reshape your data to get it in the right form. It's 2018. You have to know how to clean your own data. Additionally, you'll be asked to repeat complicated analyses, or questions like "How did you calculate this number in this analysis from six months ago?" A point-and-click interface doesn't give you a record that makes it easy to do these things. In a programming language, you can rerun complex procedures in the press of a button. Programming can be a little scary at first, but once you get the hang of it, you'll wonder how you lived without it.

Fear not though! There are a ton of fantastic resources to learn how to code. If you've never programmed before, my recommendation would be to go through the Codecademy intro Python tutorial. Even if you never want to use Python after this, you'll learn about variables, conditions, loops, data types, functions, and language-specific features. These are ideas that exist in every programming language (well SAS has macros, not functions, but you get my point.)

I also recommend using R for all of your statistics homework, even if the professor doesn't require it. That's how I learned R. It'll put you in a position where you have to learn how the language works and where the functions you want to use are. Once you have the basics of R down, check out R for Data Science. It's a very modern book on R that encourages you to use user-friendly packages to do data analysis. As for SAS, it's a terrible language that's losing market share to R and is popular because it's popular. It can help to know the basics, but it's a language I leave off my resume and LinkedIn because I never want to touch it again.

I'd also recommend learning SQL at some point. Most datasets will be in databases you'll have to query for the data you want. My favorite book for this is SQL in 10 Minutes, which is a book of 10-minute lessons, where each one is on a SQL concept. Don't worry about the specific SQL dialect since they're virtually all the same. Once you're comfortable with basic queries and joins you're in good shape.

u/BadassRipley · 12 pointsr/librarians

>With that said, are there any languages that you think would be particularly good for me to know?

SQL, and then Python if you're interested in working with databases. HTML and CSS might also be good if you're interested in working in an academic or public library in the future.

>Which language(s) would be most helpful to learn first?

Whichever really, HTML was easier for me to understand at first since I wanted to see how websites worked before trying to do my own thing.

>Lastly, are there any specific coding resources you would recommend?

Two great websites are General Assembly or codeacademy which have individual lessons and show you the code right alongside the instructions.

W3schools has a bunch of tutorials on the basics.

For SQL, you can't go wrong with Ben Forta's Teach Yourself SQL in 10 Minutes

Feel free to PM me if you have any more questions!

u/Bored2001 · 9 pointsr/consulting

SQL is insanely easy. Like, learn enough of it in a week to do real work easy. Everyone used to recommend this book But you can probably find better sources these days on youtube or something.

For python, you can find tons of resources online.

R is like SAS. It's a programming language geared specifically for doing statistics/data analysis.

u/halifaxdatageek · 8 pointsr/SQL

Take an afternoon, read this book.

Read this blog post.

Get a copy of the Chinook database, start querying random shit to see what comes up.

That should get you 80% of the way there.

u/AustinCodingAcademy · 7 pointsr/learnprogramming
u/theguywithballs · 4 pointsr/SQL

I would be useful to find out which specific DBMS they use but in the meantime I would recommend getting SQL in 10 Minutes, Sams Teach Yourself.

The book teaches ASNI (American National Standards Institute) SQL - all the general main concepts like SELECT, UPDATE that all DBMS share.

It has 22 chapters that each take 10 mins to read (but you should spend more time after each chapter practicing examples). It was incredibly helpful for me when I started learning as i knew 0 about SQL. There's a reason that books it #1 Best Seller. Once you find out what database they use you can learn DBMS-specific functions in addition.

u/CharBram · 3 pointsr/excel

To learn SQL, start with this book:
http://www.amazon.com/Sams-Teach-Yourself-Minutes-Edition/dp/0672336073/ref=sr_1_1?ie=UTF8&qid=1407993921&sr=8-1&keywords=sql+in+10+minutes

Then once you need more ideas with SQL, go to this book:
http://www.amazon.com/gp/product/0596009763/ref=oh_aui_detailpage_o05_s00?ie=UTF8&psc=1

For Python, I would start with this book:
http://www.amazon.com/Python-Programming-Introduction-Computer-Science/dp/1590282418/ref=sr_1_1?s=books&ie=UTF8&qid=1407994104&sr=1-1&keywords=python+programming

SQL may come almost naturally to you. For me at least, the basics of SQL came rather easily. With Python, expect to be a little lost, not with the programming concepts but with setting up your computer and getting Python packages installed, etc... Once you get all that done though, you will be golden.



u/dangoodspeed · 2 pointsr/SQL

A little off-topic, but I just got the Teach Yourself SQL in 10 Minutes book (where each chapter is supposed to be 10 minutes). I just started learning SQL and this $20 book is pretty handy.

u/masterprtzl · 2 pointsr/todayilearned

Relational databases are definitely a lot better and scalable in the long run than excel spread sheets. I would recommend the book "Teach yourself SQL in 10 minutes" as a great way to familiarize yourself with the basics.

http://www.amazon.com/Sams-Teach-Yourself-Minutes-Edition/dp/0672336073

u/beaverteeth92 · 2 pointsr/statistics

If they're that big, you might want to look at PortgreSQL. Especially if you aren't doing anything too complicated. To learn SQL, I highly recommend Sam's Teach Yourself SQL in Ten Minutes.

u/youlleatitandlikeit · 2 pointsr/webdev

Mastering Regular Expressions is a joy to read and makes you a better user of this powerful (and misunderstood) tool.

SQL in 10 Minutes is easily the best introduction to the most common SQL you'll need to use unless you're actually planning on being a full DBA. Anyone who ever needs to step outside of an ORM should have a basic understanding of SQL and this book is it. Short, understandable, and to the point.

A lot of the books that really helped me as a developer back in the late 90s and early 00s just aren't as relevant anymore:

  • JavaScript, the Definitive Guide by David Flanagan (just use online resources)
  • The ColdFusion Web Application Construction Kit — I don't do much ColdFusion development anymore, Ben Forta's book is way out-of-date, and again most of the info you need is now online.

    Then there are books about programming. These books still remain fairly relevant even as technologies change.

  • Code Complete & Rapid Development, both by Steve McConnel
  • Head First Design Patterns
  • Don't Make Me Think (more about interface design; an essential read for people who touch the front end)
u/pikatruuu · 1 pointr/SQL

Is this the cover?

u/UnexceptionableHobby · 1 pointr/SQL

You don't need to have formal coursework or a certification.


Learn however much you need to so that you feel comfortable honestly putting it on your resume in some way. Even if this means that your resume includes something along the lines of 'light SQL experience'. If you get into an interview make sure you set the right expectation about any skills listed on your resume like this. From the mouth of a VP - "I know this job won't require (insert random skill here). I put that on there so that I have an HR friendly reason to reject any candidate."


All that being said, check out this book:


https://www.amazon.com/SQL-Minutes-Sams-Teach-Yourself/dp/0672336073


It should get you a good enough understanding to be able to talk about SQL in an interview (assuming you level set with them correctly) to demonstrate that you took the job seriously enough to start learning. It's not a lot by any means, but it can give you an opportunity to convince the person interviewing you that you can learn it if needed.

u/JeramieH · 1 pointr/IWantToLearn

May I recommend for SQL and Java

u/jemlibrarian · 1 pointr/Random_Acts_Of_Amazon

Something totally utilitarian: Learning Python the Hard Way

Oh hell, who am I kidding. I only do utilitarian

u/JustJeezy · 1 pointr/datascience

SQL in 10 Minutes

This was the book used in an introductory course I took. It did a pretty good job of explaining everything and was pretty easy to follow.

u/eveningsand · 1 pointr/healthIT

Go get yourself this book:



SQL in 10 Minutes, Sams Teach Yourself (4th Edition)


​

You can and will teach yourself practically most if not everything you'll ever need to know about SQL. You won't become a database engineer, but you'll know how to help yourself much more than you can today.

u/anevilpotatoe · 1 pointr/sysadmin

Let me clarify a little. It's helpful to find books that I can digest from the ground up on and compare with current standards or use creatively. Simple put I enjoy doing the homework on a book. What I am look to accomplish is to write SQL Queries for corporate finances and manufacturing. Working in the environment I am in currently allows me the opportunity to learn and practice it.


Here are a few I looked into:

https://www.amazon.com/SQL-Minutes-Sams-Teach-Yourself/dp/0672336073/ref=sr_1_4?ie=UTF8&qid=1519240184&sr=8-4&keywords=beginning+SQL

https://www.amazon.com/SQL-Beginners-Learning-Programming-Course/dp/1532716958/ref=sr_1_14?ie=UTF8&qid=1519240184&sr=8-14&keywords=beginning+SQL


https://www.amazon.com/SQL-Practice-Problems-learn-doing/dp/1520807635/ref=sr_1_7?ie=UTF8&qid=1519239367&sr=8-7&keywords=beginning+SQL