DeepRead
Cover of Practical SQL, 2nd Edition

Practical SQL, 2nd Edition

Anthony DeBarros · 2021

Programming and computer science › Databases and distributed data

#5,448 most recommended

About the book

A beginner's guide to SQL for analyzing real datasets, using PostgreSQL as the database. It covers creating tables, importing data, querying and filtering, joins, aggregate and date functions, and summarizing results. It also includes working with geographic data through PostGIS. Structured Query Language is a practical tool for answering real questions about data, and readers do not need prior programming experience to use it well. The book's approach is to learn by working through realistic datasets and tasks rather than abstract syntax alone. It also stresses that careful data cleaning and sound table design are what make analysis trustworthy.

Written by Claude from what it knows of this book.

What Hacker News says 71% recommend · 0% critical

02420202022202420262020 peak · 2
This bookAverage book in Databases and distributed data

In the commenters’ own words

What Open Library readers say 1.00 from 1 rating

  1. 50
  2. 40
  3. 30
  4. 20
  5. 11
  • 16 want to read
  • 0 reading
  • 0 have read

Only 1 rating: treat the average as a hint.

Open Library’s page for the book

What critics say, via Wikipedia

No Wikipedia article about this book yet, so no critics to quote.

Reddit communities — coming later

The threads it came up in

Details

First published
2021
ISBN
9781593278274
Editions known
2 at Open Library
Open Library
OL25266682W

Explore in the mosaic

Read next: its neighbours on the mosaic

  • Joe Celko's SQL for Smarties
    Joe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
  • The art of SQL
    Stephane Faroult · 2006 · recommended by 8 people · similar by subject and what people say about it
  • Learning SQL
    Alan Beaulieu · 2005 · recommended by 3 people · similar by subject and what people say about it
  • SQL for Web Nerds
    Philip Greenspun · 2000 · recommended by 7 people · similar by subject and what people say about it
  • SQL Cookbook
    Anthony Molinaro · 2005 · recommended by 7 people · similar by subject and what people say about it
  • SQL antipatterns
    Bill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
  • SQL for Dummies
    Allen G. Taylor · 1993 · recommended by 1 person · similar by subject and what people say about it
  • Automate the Boring Stuff with Python
    Al Sweigart · 2015 · recommended by 75 people · 2 people recommended both
  • SQL Performance Explained
    Markus Winand · 2011 · recommended by 26 people · similar by subject and what people say about it
  • Pro SQL Server Internals
    Dmitri Korotkevitch · 2014 · recommended by 2 people · similar by subject and what people say about it
  • SQL puzzles & answers
    Joe Celko · 1997 · recommended by 3 people · similar by subject and what people say about it
  • SQL Design Patterns
    Vadim Tropashko · 2007 · recommended by 2 people · similar by subject and what people say about it
  • Database System Concepts
    Korth · 2005 · recommended by 4 people · similar by subject and what people say about it
  • Database systems
    Hector Garcia-Molina · 2001 · recommended by 11 people · similar by subject and what people say about it
  • The Art of PostgreSQL
    Dimitri Fontaine · 2019 · recommended by 20 people · similar by subject and what people say about it
  • Developing time-oriented database applications in SQL
    Richard T. Snodgrass · 1999 · recommended by 6 people · similar by subject and what people say about it
  • UNIX Shell programming
    Stephen G. Kochan · 1985 · recommended by 4 people · loosely similar by subject
  • Designing Data-Intensive Applications
    Martin Kleppmann · 2017 · recommended by 457 people · similar by subject and what people say about it
  • High Performance MySQL
    Jeremy D. Zawodny · 2004 · recommended by 27 people · similar by subject and what people say about it
  • Database design and implementation
    Edward Sciore · 2008 · recommended by 7 people · similar by subject and what people say about it
  • Practical C Programming
    Steve Oualline · 1991 · recommended by 7 people · similar by subject and what people say about it
  • Database Design for Mere Mortals
    Michael J. Hernandez · 1996 · recommended by 12 people · similar by subject and what people say about it
  • Fluent Python
    Luciano Ramalho · 2015 · recommended by 67 people · similar by subject and what people say about it
  • The Manga Guide to Databases
    Mana Takahashi · 2005 · recommended by 11 people · similar by subject and what people say about it