Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying SQL for Data Analytics
  • Table Of Contents Toc
SQL for Data Analytics

SQL for Data Analytics - Fourth Edition

By : Jun Shan, Benjamin Johnston, Haibin Li, Matt Goldwasser, Upom Malik
close
close
SQL for Data Analytics

SQL for Data Analytics

By: Jun Shan, Benjamin Johnston, Haibin Li, Matt Goldwasser, Upom Malik

Overview of this book

SQL remains one of the most essential tools for modern data analysis and mastering it can set you apart in a competitive data landscape. This book helps you go beyond basic query writing to develop a deep, practical understanding of how SQL powers real-world decision-making. SQL for Data Analytics, Fourth Edition, is for anyone who wants to go beyond basic SQL syntax and confidently analyze real-world data. Whether you're trying to make sense of production data for the first time or upgrading your analytics toolkit, this book gives you the skills to turn data into actionable outcomes. You'll start by creating and managing structured databases before advancing to data retrieval, transformation, and summarization. From there, you’ll take on more complex tasks such as window functions, statistical operations, and analyzing geospatial, time-series, and text data. With hands-on exercises, case studies, and detailed guidance throughout, this book prepares you to apply SQL in everyday business contexts, whether you're cleaning data, building dashboards, or presenting findings to stakeholders. By the end, you'll have a powerful SQL toolkit that translates directly to the work analysts do every day. *Email sign-up and proof of purchase required
Table of Contents (21 chapters)
close
close
Lock Free Chapter
1
Part 1: Data Management Systems
6
Part 2: Data Presentation and Manipulation
12
Part 3: Advanced Topics on Analytics
19
Other Books You May Enjoy
20
Index
chevron up

Index

Symbols

\COPY command 53, 54

\df command 116

\sf command 116

A

advanced window definitions

using 174

window frame 176-179

window functions 174, 175

WINDOW keyword 175, 176

aggregate functions 146-150

using, to analyze data 150, 151

aggregations 145

American National Standards Institute (ANSI) 14

analytics

fundamental concepts 252

moving, to statistics 252

analytics, fundamental concepts

measures of central tendency 255, 256

measures of variability 256, 257

parameters, versus statistics 254

population, versus samples 252, 253

AND or OR clause 93-95

arrays

sequences, analyzing 226-228

using, to process element collections 222-225

atomicity, consistency, isolation, and durability (ACID) 13

B

bitmap heap scan 197

block 188

Boolean 36

B-tree index 193-195

Business Intelligence (BI) tools 278

C

CASE WHEN function 108, 109

casting function 110

...
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
SQL for Data Analytics
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon