Practical SQL, 2nd Edition (No Starch Press)
Wednesday, 02 February 2022

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

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.




Swift Programming In Easy Steps

Author: Darryl Bartlett
Publisher: In Easy Steps
Pages: 192
ISBN: 978-1840787775
Audience: Novice developers interested in Swift
Rating: 4
Reviewer: Lucy Black
Swift - Is this iOS-oriented language worth learning?

Using Asyncio in Python

Author: Caleb Hattingh
Publisher: O'Reilly
Date: February 2020
Pages: 166
ISBN: 978-1492075332
Print: 1492075337
Kindle: B084D653HW
Audience: Python developers
Rating: 2
Reviewer: Ian Elliot
Asycio is the new way to do asynchronous code in Python and  you probably do want to know about it.

More Reviews