SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights
Product ID: 403166360
Desertcart purchases this item on your behalf and handles shipping, customs, and support to Congo.
With the explosion of data, computing power, and cloud data warehouses, SQL has become an even more indispensable tool for the savvy analyst or data scientist. This practical book reveals new and hidden ways to improve your SQL skills, solve problems, and make the most of SQL as part of your workflow. You'll learn how to use both common and exotic SQL functions such as joins, window functions, subqueries, and regular expressions in new, innovative ways--as well as how to combine SQL techniques to accomplish your goals faster, with understandable code. If you work with SQL databases, this is a must-have reference. Learn the key steps for preparing your data for analysis Perform time series analysis using SQL's date and time manipulations Use cohort analysis to investigate how groups change over time Use SQL's powerful functions and operators for text analysis Detect outliers in your data and replace them with alternate values Establish causality using experiment analysis, also known as A/B testing Review: Effective concise lessons - The topics are explained very well with relevant code, results of the code and explanation of the code making it easy to retain the lesson and apply when needed. Review: Great book - Great book
| Best Sellers Rank | 48,307 in Books ( See Top 100 in Books ) 2 in SQL Databases 3 in Database Management Systems (Books) 11 in Data Mining (Books) |
| Customer Reviews | 4.7 out of 5 stars 216 Reviews |
D**P
Effective concise lessons
The topics are explained very well with relevant code, results of the code and explanation of the code making it easy to retain the lesson and apply when needed.
H**M
Great book
Great book
B**R
A useful primer
This is a good book as an introduction to this useful skill
A**L
Great reference
Fantastic overview of a simple language, return to this regularly to check things. Be warned, every sql version is different so this will miss things and not apply to others. General principles are sensible. Most important concept is execution order of sql statements.
P**R
quality of print
The contents of the book seem fine, but given the price tag for a paperback, the quality of the print is unacceptable. The book has glue and ink residue, bent pages and a tear on the front page due to glue residue sticking pages together.
V**A
Buen libro
Aún no lo termino de leer.
B**R
Great book
This SQL data analytical book is a game-changer! It breaks down complex concepts into easy-to-understand lessons, perfect for beginners and experienced users alike. The step-by-step tutorials make learning SQL a breeze, and the practical examples provide real-world application. I particularly appreciate the emphasis on data analysis techniques, which have helped me uncover valuable insights in my projects. The book covers a wide range of topics, from basic queries to advanced analytics, making it a comprehensive resource. Whether you're a data enthusiast or a professional analyst, this book is a must-have for mastering SQL and unleashing the power of data analytics
S**Y
Good for Analysts
It's nice to see a SQL book that's meant for Data Analytics. This book does not teach you SQL, it expects that you at least have a baseline competency and can write queries already. What this book does do is provide you with techniques to use data analytics methods specifically with SQL and it also covers when SQL is strong and when it is not. For non-developers who use SQL for data extraction and analysis, you can bring your skills to a whole new level here.
G**S
Good guide to ride the possibilities of SQL
Good guide to understand SQL and all its possibilities, mostly when nowadays Python and R hog all data analysis studies. However the scope of this book doesn't go beyond RDBS, so streaming (like KafkaSql) or text engines (like ElasticSearch using sql) are not mentioned.
T**A
Very useful
Started a new Data Analyst job which uses mostly SQL. This book has helped enormously in learning the ins and outs of DA with SQL and I suspect will be useful as a reference text going forward.
Trustpilot
2 weeks ago
1 month ago