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.

<ASIN:1718501064>

 

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.

 

 

Banner
 


The Phoenix Project

Author: Gene Kin, Kevin Behr and George Spafford
Publisher:  IT Revolution Press
Pages: 583
ISBN: 9781942788294
Print: 1942788290
Kindle: B078Y98RG8
Audience: Anyone in IT
Rating: 4.5
Reviewer: Sanjay Kanade

 

With the subtitle "A Novel about IT, DevOps, and Helping Your  [ ... ]



HTML, CSS & JavaScript (In Easy Steps)

Author: Mike McGrath
Publisher: In Easy Steps
Date: July 2020
Pages: 480
ISBN: 978-1840788785
Print: 184078878X
Kindle: B08FBGXGF1
Audience: would-be web developers
Rating: 5
Reviewer Mike James
The three core web technologies in a single book.


More Reviews