SQL for Data Analytics: Perform fast and efficient data analysis with the power of SQL

Very useful for beginners.

Hello,I got this book about a week ago and it seems to be a good book to learn SQL. I've been following the instruction in the book to load the data.dump file from a command line but this is not working for me. I don't know if there is something I wasn't doing right but any information or tip on how to do this will be much appreciated. Thanks.

I bought the book specifically because I was starting an SQL heavy job opportunity and had very little sql experience. The book is very well organized so you can use it as a reference or you can read through it cover-cover and get value both ways. Definitely a good text to have available because the writing isn’t dense and the examples are practical, highly recommend.

This is a decent book with good information however the exercises are explained with verbiage that assumes you know or understand, instead of assuming you don’t. As a learner, assume I don’t know and explain with the intent of teaching vs informing. This book is great at informing but lacks in depth of teaching.

I recently entered into a new job where our database was immensely more complicated than any others I've worked with. This book really helped me generate the necessary queries I needed to be able to properly grab, display and analyze the relevant data. It also has very useful section on the types of statistical analysis you can use on the data that you capture, which has been a rich resource for me. I would recommended this book to anyone wanting to learn SQL for data analytics/data science, but also as a great reference to the more experienced user.

Easily one of the best SQL books out there for helping you slice and dice your data into exactly the way you want it. Perfect for learning or simply as a convenient reference.

Very happy about this purchase, I purchased another SQL book and that one was super confusing. This one is incredibly great & easy to understand. The installation is even pretty easy too compared to other installations I’ve tried. Definitely recommend if you’re trying to learn SQL.

Frankly, this book is trash. I bought it to teach myself some extra SQL and data analytics with it but what I received was an introductory SQL text with very little data analytics.There are errors located everywhere in the book to the point where I'm sure you can find at least one every couple of pages. They range from simple typos, to typos in code you're supposed to copy, and to things that are just plain wrong.Along with the errors the figures in the book are a joke. There are multiple figures that take up almost an entire page when they have no right to. An example is in the first chapter they show a scatter plot with an upward trend to cover what correlating data looks like and it took up almost the entire page. It's a scatter plot with data that doesn't matter, you don't need an entire page just enough room for the reader to clearly see what's going on. It's something a student would do to pad their page count. Other reviews said their figures were blurry but thankfully the pictures in my copy are fine... just really big.The book was written by three different authors, and it really shows. You can definitely see a style change around halfway through the book. The first part of the book also focuses on using pgAdmin and the second half focuses purely on using a command prompt. Both are fine don't get me wrong, but the shift was sudden and seems like there wasn't much collaboration between the authors. The formatting of the queries you write is also all over the place and in my opinion teaches bad habits. The first author refuses to indent anything, the second writes queries in a better manner and the third writes entire queries on one line in the command prompt throwing legibility out the window.There's a section that introduces how to use SQL with python which was nice and I was looking forward to but the chapter is short and moves back to using the command prompt the next chapter. They also cover how to use JOINs twice for whatever reason. once towards the start and once towards the end.Maybe I'm misunderstand what data analytics is/contains but there isn't much besides basic concepts in this book. If you just want to count things, find the average, organize data then okay you will get that. Anything more advanced though is out of scope for the book and you are recommended to pick up another statistics book.I did learn some new things from this book, but they don’t spend to much time on some of the more advances subjects. I wouldn’t recommend this book to anyone, it seems like it was lazily put together by the authors and I’m sure you’d be better off with some other book.