This book is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. Anthony DeBarros, a journalist and data analyst, focuses on using SQL to find the story within your data. The examples and code use the open-source database PostgreSQL and its companion pgAdmin interface, and the concepts you learn will apply to most database management systems, including MySQL, Oracle, SQLite, and others.

Author: Anthony DeBarros
Publisher: No Starch
Date: January 2022
Pages: 427
ISBN: 978-1718501065
Print: 1718501064
Kindle: B08K7LJRQX
Audience: General
Level: Intermediate
Category: Database

Topics Covered:

•   Create databases and related tables using your own data
•   Aggregate, sort, and filter data to find patterns
•   Use functions for basic math and advanced statistical operations
•   Identify errors in data and clean them up
•   Analyze spatial data with a geographic information system (PostGIS)
•   Create advanced queries and automate tasks

For recommendations of MySQL books see MySQL and MariaDB Database Books in our Programmer's Bookshelf section. For recommendations of Big Data books see Reading Your Way Into Big Data in our Programmer's Bookshelf section.

For more Book Watch just click.

Book Watch is I Programmer's listing of new books and is compiled using publishers' publicity material. It is not to be read as a review where we provide an independent assessment. Some, but by no means all, of the books in Book Watch are eventually reviewed.

To have new titles included in Book Watch contact  BookWatch@i-programmer.info

Follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for each day's new addition to Book Watch and for new reviews.