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

2. Introduction to Data Management Systems FREE CHAPTER

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

Activity 11

A salesperson asks you whether you can use your new search skill to find a customer by the name of Arlena who has made some purchases before.

Use the customer_sales table and create a searchable view with one record per customer. This view should use the customer_id column as the primary key and be searchable on everything related to that customer: name, email address, phone number, and purchased products. It is acceptable to include other fields as well. For your convenience, you can also include the original JSON column as is.

Query your new searchable view using the Arlena keyword filter. Note that the results of some JSON functions are still JSON, not TEXT. You may need to perform type conversion based on the function you choose. Also, there must be a filter condition that this customer made some purchases before (the sales array contains at least one record, which is record 0).