You're reading from SQL for Data Analytics Analyze data effectively, uncover insights and master advanced SQL for real-world applications

Product type Paperback

Published in Nov 2025

Publisher Packt

ISBN-13 9781836646259

Length 336 pages

Edition 4th Edition

Languages

SQL

Tools

MySQL

Concepts

Data Analysis

Authors (5):

Jun Shan

Benjamin Johnston

Haibin Li

Matt Goldwasser

Upom Malik

+1 more

View More author details

Table of Contents (21) Chapters

Preface

Free Benefits with Your Book

1. Part 1: Data Management Systems FREE CHAPTER

2. Introduction to Data Management Systems

3. Creating Tables with Solid Structures

4. Exchanging Data Using COPY

5. Manipulating Data with Python

6. Part 2: Data Presentation and Manipulation

7. Presenting Data with SELECT

8. Transforming and Updating Data

9. Defining Datasets from Existing Datasets

10. Aggregating Data with GROUP BY

11. Inter-Row Operation with Window Functions

12. Part 3: Advanced Topics on Analytics

13. Performant SQL

14. Processing JSON and Arrays

15. Advanced Data Types: Date, Text, and Geospatial

16. Inferential Statistics Using SQL

17. A Case Study for Analytics Using SQL

18. Unlock Your Exclusive Benefits

Unlock this Book’s Free Benefits in 3 Easy Steps

19. Other Books You May Enjoy

20. Index

Data Management Systems

The first part of this book introduces how to describe and analyze real-world objects using data, starting with an understanding of relational databases and SQL. It guides you through setting up a PostgreSQL database to store and query data effectively. You will learn how to create, insert, and delete tables and perform CRUD operations using SQL. This part also covers how to import and export data between PostgreSQL and external filesystems. Finally, it introduces Python for database interaction and data manipulation, enabling you to manage relational data programmatically.

This part of the book includes the following chapters: