
Practical SQL, 2nd Edition
Anthony DeBarros · 2021
Programming and computer science › Databases and distributed data
#5,448 most recommended
Hacker News
7
mentions by 7 people · top 38% of 15,732 books
Open Library
1.00★★★★★★★★★★
1 rating · 16 want to read
Wikipedia
—
No article yet
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
In the commenters’ own words
I found that it depends on where your interest lies. If you just want to learn practical SQL then I have historically found the Celko books (…
Ugh, there's a basic PostgreSQL book listed on there, which (from the Amazon reviews) seems to be the worst possible pick. eg it's rated as 1 star. :(…
What Open Library readers say 1.00 from 1 rating
- 50
- 40
- 30
- 20
- 11
- 16 want to read
- 0 reading
- 0 have read
Only 1 rating: treat the average as a hint.
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
Read next: its neighbours on the mosaic
Joe Celko's SQL for SmartiesJoe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
The art of SQLStephane Faroult · 2006 · recommended by 8 people · similar by subject and what people say about it
Learning SQLAlan Beaulieu · 2005 · recommended by 3 people · similar by subject and what people say about it
SQL for Web NerdsPhilip Greenspun · 2000 · recommended by 7 people · similar by subject and what people say about it
SQL CookbookAnthony Molinaro · 2005 · recommended by 7 people · similar by subject and what people say about it
SQL antipatternsBill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
SQL for DummiesAllen G. Taylor · 1993 · recommended by 1 person · similar by subject and what people say about it
Automate the Boring Stuff with PythonAl Sweigart · 2015 · recommended by 75 people · 2 people recommended both
SQL Performance ExplainedMarkus Winand · 2011 · recommended by 26 people · similar by subject and what people say about it
Pro SQL Server InternalsDmitri Korotkevitch · 2014 · recommended by 2 people · similar by subject and what people say about it
SQL puzzles & answersJoe Celko · 1997 · recommended by 3 people · similar by subject and what people say about it
SQL Design PatternsVadim Tropashko · 2007 · recommended by 2 people · similar by subject and what people say about it
Database System ConceptsKorth · 2005 · recommended by 4 people · similar by subject and what people say about it
Database systemsHector Garcia-Molina · 2001 · recommended by 11 people · similar by subject and what people say about it
The Art of PostgreSQLDimitri Fontaine · 2019 · recommended by 20 people · similar by subject and what people say about it
Developing time-oriented database applications in SQLRichard T. Snodgrass · 1999 · recommended by 6 people · similar by subject and what people say about it
UNIX Shell programmingStephen G. Kochan · 1985 · recommended by 4 people · loosely similar by subject
Designing Data-Intensive ApplicationsMartin Kleppmann · 2017 · recommended by 457 people · similar by subject and what people say about it
High Performance MySQLJeremy D. Zawodny · 2004 · recommended by 27 people · similar by subject and what people say about it
Database design and implementationEdward Sciore · 2008 · recommended by 7 people · similar by subject and what people say about it
Practical C ProgrammingSteve Oualline · 1991 · recommended by 7 people · similar by subject and what people say about it
Database Design for Mere MortalsMichael J. Hernandez · 1996 · recommended by 12 people · similar by subject and what people say about it
Fluent PythonLuciano Ramalho · 2015 · recommended by 67 people · similar by subject and what people say about it
The Manga Guide to DatabasesMana Takahashi · 2005 · recommended by 11 people · similar by subject and what people say about it