faq-updates-errata.md

Practical SQL: A Beginner's Guide to Storytelling with Data, 2nd Edition

FAQ, Updates, and Errata

This page contains answers to Frequently Asked Questions, updates to material and URLs, and errata for Practical SQL, 2nd Edition.

Introduction

None yet

Chapter 1: Setting Up Your Coding Environment

Page 13: pgAdmin Dialog to Create Server

The location of the pgAdmin dialog to add a server has changed. Now, in the object browser, right-click Servers and then click Register > Server. The remaining steps in the Note on page 13 are the same. (Formerly, the dialog was accessed by right-clicking Servers and selecting Create > Server.)

Page 15, Figure 1-5: pgAdmin Query Tool

Version 6.9 of pgAdmin, released in May 2022, introduced a redesigned Query Tool Layout. General functionality is the same, but if you are using version 6.9 or later, you will see that some menu icons shown in the book at the top of the window are now placed atop the results grid.

Chapter 2: Creating Your First Database and Table

None yet

Chapter 3: Beginning Data Exploration with SELECT

None yet

Chapter 4: Understanding Data Types

None yet

Chapter 5: Importing and Exporting Data

None yet

Chapter 6: Basic Math and Stats with SQL

None yet

Chapter 7: Joining Tables in a Relational Database

None yet

Chapter 8: Table Design That Works for You

None yet

Chapter 9: Extracting Information by Grouping and Summarizing

None yet

Chapter 10: Inspecting and Modifying Data

None yet

Chapter 11: Statistical Functions in SQL

None yet

Chapter 12: Working With Dates and Times

None yet

Chapter 13: Advanced Query Techniques

None yet

Chapter 14: Mining Text to Find Meaningful Data

None yet

Chapter 15: Analyzing Spatial Data with PostGIS

Pages 282, 288: Geometry Viewer Results Grid Icon

Beginning with version 6.9 of pgAdmin, released in May 2022, the icon to launch the Geometry Viewer in the result column header was changed from an eye to a map (makes sense). On Page 282 and later in the book, I mention clicking the eye icon to launch the viewer. Now, instead, click the map icon.

Chapter 16: Working With JSON Data

None yet

Chapter 17: Saving Time with Views, Functions, and Triggers

None yet

Chapter 18: Using PostgreSQL from the Command Line

None yet

Chapter 19: Maintaining Your Database

None yet