Buy new:
$76.70
FREE delivery: Tuesday, April 30
Ships from: Amazon
Sold by: Tome Dealers
FREE Returns
FREE delivery Tuesday, April 30
Or fastest delivery Friday, April 26. Order within 12 hrs 31 mins
Only 6 left in stock - order soon.
$$76.70 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$76.70
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Amazon
Ships from
Amazon
Sold by
Tome Dealers
Sold by
Tome Dealers
Returns
Eligible for Return, Refund or Replacement within 30 days of receipt
Eligible for Return, Refund or Replacement within 30 days of receipt
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Returns
Eligible for Return, Refund or Replacement within 30 days of receipt
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Payment
Secure transaction
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Support
Product support included
What's Product Support?
In the event your product doesn't work as expected or you need help using it, Amazon offers free product support options such as live phone/chat with an Amazon associate, manufacturer contact information, step-by-step troubleshooting guides, and help videos. By solving product issues, we help the planet by extending the life of products. Availability of support options differ by product and country. Learn more
Support
Product support included
In the event your product doesn't work as expected or you need help using it, Amazon offers free product support options such as live phone/chat with an Amazon associate, manufacturer contact information, step-by-step troubleshooting guides, and help videos. By solving product issues, we help the planet by extending the life of products. Availability of support options differ by product and country. Learn more
FREE delivery Wednesday, May 1
Or fastest delivery Friday, April 26. Order within 12 hrs 31 mins
Used: Good | Details
Sold by Coventry and Miller
Fulfilled by Amazon
Condition: Used: Good
Comment: Used Book. Condition: Good. See extended description for more details. Soft Cover. No notes, underlining or highlighting. Typical wear to covers / cover edges / spine for a used book. Front cover has a few line like indentations that are noticeable when looking at the inside of the front cover. The same indentations transferred to the first few pages of the book. With the exception of those pages all other pages are bright and unmarred. Corners have been bumped.

Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.

If you're a seller, Fulfillment by Amazon can help you grow your business. Learn more about the program.

Access codes and supplements are not guaranteed with used items.
Amazon book clubs early access
Loading your book clubs
There was a problem loading your book clubs. Please try again.
Not in a club? Learn more
Amazon book clubs early access

Join or create book clubs

Choose books together

Track your books
Bring your club to Amazon Book Clubs, start a new book club and invite your friends to join, or find a club that’s right for you for free.
Explore Amazon Book Clubs
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the author

Matt Goldwasser
Follow
Something went wrong. Please try your request again later.

SQL for Data Analytics

by Upom Malik (Author), Matt Goldwasser (Author), Benjamin Johnston (Author)
4.4 4.4 out of 5 stars 245 ratings
See all formats and editions
{"desktop_buybox_group_1":[{"displayPrice":"$76.70","priceAmount":76.70,"currencySymbol":"$","integerValue":"76","decimalSeparator":".","fractionalValue":"70","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"a924l%2FKHQciiwesW54FbrX3OeiYubFaIcnnjXtd1qfJLP5IJmS8Iwyo4TDSu8wR7jJ%2FFoCkjTHvc1N%2BpVCbcWh6ecrOowrZrDobnqzwX4JwQf3cbf1JriVXJfV15%2F8OD%2BqNhvYFzescIjZ3XWhR14nJZHH6mutCtkNerJVznMf0w9MjOpttgRo8IqS6Maoua","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$39.88","priceAmount":39.88,"currencySymbol":"$","integerValue":"39","decimalSeparator":".","fractionalValue":"88","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"a924l%2FKHQciiwesW54FbrX3OeiYubFaIC6ljN3R846XKoZFPOHTcoFyt%2FM6ZVGY9MGHj6QDx7DBuu43BpyTg5obaHWpIXgjl3DffQRr4kgz6FL0nqGtB9qvcbV56GxBSuhVA8siTM%2FA0ehFM%2FE0DDvCtQAzbOPHEPagOLMyHbQ3OIEW9aSPGUTOMKktyOZB%2F","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

Take your first steps to become a fully qualified data analyst by learning how to explore large relational datasets

Key Features

  • Explore a variety of statistical techniques to analyze your data
  • Integrate your SQL pipelines with other analytics technologies
  • Perform advanced analytics such as geospatial and text analysis

Book Description

Understanding and finding patterns in data has become one of the most important ways to improve business decisions. If you know the basics of SQL, but don't know how to use it to gain the most effective business insights from data, this book is for you.

SQL for Data Analytics helps you build the skills to move beyond basic SQL and instead learn to spot patterns and explain the logic hidden in data. You'll discover how to explore and understand data by identifying trends and unlocking deeper insights. You'll also gain experience working with different types of data in SQL, including time-series, geospatial, and text data. Finally, you'll learn how to increase your productivity with the help of profiling and automation.

By the end of this book, you'll be able to use SQL in everyday business scenarios efficiently and look at data with the critical eye of an analytics professional.

Please note: if you are having difficulty loading the sample datasets, there are new instructions uploaded to the GitHub repository. The link to the GitHub repository can be found in the book's preface.

What you will learn

  • Perform advanced statistical calculations using the WINDOW function
  • Use SQL queries and subqueries to prepare data for analysis
  • Import and export data using a text file and psql
  • Apply special SQL clauses and functions to generate descriptive statistics
  • Analyze special data types in SQL, including geospatial data and time data
  • Optimize queries to improve their performance for faster results
  • Debug queries that won’t run
  • Use SQL to summarize and identify patterns in data

Who this book is for

If you’re a database engineer looking to transition into analytics, or a backend engineer who wants to develop a deeper understanding of production data, you will find this book useful. This book is also ideal for data scientists or business analysts who want to improve their data analytics skills using SQL. Knowledge of basic SQL and database concepts will aid in understanding the concepts covered in this book.

Table of Contents

  1. Understanding and Describing Data
  2. The Basics of SQL for Analytics
  3. SQL for Data Preparation
  4. Aggregate Functions for Data Analysis
  5. Window Functions for Data Analysis
  6. Importing and Exporting Data
  7. Analytics Using Complex Data Types
  8. Performant SQL
  9. Using SQL to Uncover the Truth - A Case Study
Previous page
  1. ISBN-10
    1789807352
  2. ISBN-13
    978-1789807356
  3. Publisher
    Packt Publishing
  4. Publication date
    August 22, 2019
  5. Language
    English
  6. Dimensions
    9.25 x 7.52 x 0.8 inches
  7. Print length
    386 pages
  8. See all details
Next page
Amazon First Reads | Editors' picks at exclusive prices

Frequently bought together

SQL for Data Analytics
$76.70
Get it as soon as Tuesday, Apr 30
Only 6 left in stock - order soon.
Sold by Tome Dealers and ships from Amazon Fulfillment.
+
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL (Coding & Progra
$23.79
Get it as soon as Tuesday, Apr 30
In Stock
Ships from and sold by Amazon.com.
+
Sql Guide (Quick Study: SQL)
$4.95
Get it as soon as Tuesday, Apr 30
In Stock
Ships from and sold by Amazon.com.
Total price:
To see our price, add these items to your cart.
Details
Added to Cart
Some of these items ship sooner than the others.
Show details Hide details
Choose items to buy together.

Editorial Reviews

About the Author

Upom Malik is a data scientist who has worked in the technology industry for over 6 years. He has a master's degree in chemical engineering from Cornell University and a bachelor's degree in biochemistry from Duke University. He uses SQL and other tools to solve interesting challenges in finance, energy, and consumer technologies. While working on analytical problems, he has lived out of a suitcase and spent the last year as a digital nomad. Outside of work, he likes to read, hike the trails of the Northeastern United States, and savor ramen bowls from around the world.

Matt Goldwasser is a lead data scientist at T. Rowe Price. He enjoys demystifying data science for business stakeholders and deploying production machine learning solutions. Matt has been using SQL to perform data analytics in the financial industry for the last 8 years. He has a bachelor's degree in mechanical and aerospace engineering from Cornell University. In his spare time, he enjoys teaching his infant son data science.

Benjamin Johnston is a senior data scientist for one of the world's leading data-driven medtech companies and is involved in the development of innovative digital solutions throughout the entire product development pathway, from problem definition to solution research and development, through to final deployment. He is currently completing his PhD in machine learning, specializing in image processing and deep convolutional neural networks. He has more than 10 years' experience in medical device design and development, working in a variety of technical roles, and holds first-class honors bachelor's degrees in both engineering and medical science from the University of Sydney, Australia.

Product details

  • Publisher ‏ : ‎ Packt Publishing (August 22, 2019)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 386 pages
  • ISBN-10 ‏ : ‎ 1789807352
  • ISBN-13 ‏ : ‎ 978-1789807356
  • Item Weight ‏ : ‎ 1.47 pounds
  • Dimensions ‏ : ‎ 9.25 x 7.52 x 0.8 inches
  • Customer Reviews:
    4.4 4.4 out of 5 stars 245 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.
Matt Goldwasser

Matt Goldwasser

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

Discover more of the author’s books, see similar authors, read author blogs and more

Customer reviews

4.4 out of 5 stars
4.4 out of 5
245 global ratings

Top reviews from the United States

Giorgi
5.0 out of 5 stars Great
Reviewed in the United States on July 30, 2023
Verified Purchase
Great
Helpful
 Report
RB
5.0 out of 5 stars Very Informative
Reviewed in the United States on September 24, 2022
Verified Purchase
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.
Helpful
 Report
Spoiled Dog Family
3.0 out of 5 stars Book is great - but the Index needs first aid
Reviewed in the United States on June 15, 2020
Verified Purchase
The book itself if very helpful BUT I strongly encourage the authors to take time to revise the Index when it is printed again. The Index is near to useless. We get reference books like this to learn the details of code and to look up questions as we are working with the code. This involves referring to the Index. It seems that creating the Index was rushed - perhaps the authors created it themselves instead of having someone who knew what they were doing create it? In any case, you find something like the word "Select" and then 42 (!) pages or page combinations where this word appears. Did that help? Not at all, unless you want to look through 42 different page references. As a matter of fact, the entire Index is only 4 pages total which should say something in itself. Other than this, I think the book will be helpful BUT I need a decent Index to get the most use out of it. I will essentially have to recreate it myself so that I can find key terms when needed.
15 people found this helpful
Helpful
 Report
Ryan W
5.0 out of 5 stars Excellent SQL book for anyone in the data analytics field
Reviewed in the United States on November 23, 2019
Verified Purchase
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.
21 people found this helpful
Helpful
 Report
ajibade samson adetogun
5.0 out of 5 stars Good book but need more information on how to load data.dump
Reviewed in the United States on May 17, 2020
Verified Purchase
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.
7 people found this helpful
Helpful
 Report
Emily
5.0 out of 5 stars Great for learning SQL
Reviewed in the United States on April 18, 2021
Verified Purchase
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.
One person found this helpful
Helpful
 Report
edona
5.0 out of 5 stars Well organized and simple language
Reviewed in the United States on December 18, 2019
Verified Purchase
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.
6 people found this helpful
Helpful
 Report
Samuel Gedon
1.0 out of 5 stars Lazily put together book.
Reviewed in the United States on August 12, 2022
Verified Purchase
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.
9 people found this helpful
Helpful
 Report

Top reviews from other countries

Translate all reviews to English
Andrea
5.0 out of 5 stars Perfect for BA study
Reviewed in Germany on July 15, 2022
Verified Purchase
I ordered the book in order improve my basic SQL knowledge as my career path in Business Analyst involved massive use of SQL.
The book covers EVERY aspect of it as it exactly resume what I was asked to improve my knowledge for. Advised to anyone with any grade of SQL knowledge.
Report
Renato Oliveira
5.0 out of 5 stars Melhor do que esperava
Reviewed in Brazil on October 5, 2020
Verified Purchase
Excellent 😊❤️! Chegou antes do prazo
Report
Ashish
4.0 out of 5 stars Every software engineer's library item.
Reviewed in India on July 28, 2021
Verified Purchase
Every software engineer's library item.
Report
The Saske
5.0 out of 5 stars A Collectors Essential
Reviewed in the United Kingdom on November 21, 2020
Verified Purchase
Absolutely brilliant script for anyone interested in Hacking, White Hat style of course, making it a very welcome part of my now extensive Computer Software Library
One person found this helpful
 Report
Paul
5.0 out of 5 stars EXCELLENT
Reviewed in France on February 12, 2020
Verified Purchase
Bon livre sur le SQL.
Report