Practical SQL

A beginner-oriented guide to SQL and relational databases aimed at people who want to tell stories with data. Topics include designing and creating databases, data types, import/export, querying from basic to advanced, statistics, text analysis, and spatial data with PostGIS.

This page is free — overview and chapter list only.
The complete book body is sold separately.

Full book: $0.99 USDC via x402 ·
Per chapter: $0.10 USDC

Buy / open complete book (HTML)
· Complete book Markdown (.md)

Agents: start with free /library/discovery.json, sample free teaser chapters,
then pay for individual chapters or the complete book URL above.
Append .md to any content URL for Markdown with YAML front matter.

Chapters

  1. Contents In Detail (Free teaser)
  2. Introduct Ion ($0.10)
  3. U N D Erstan Di Ng Data Ty Pes ($0.10)
  4. I Mporting An D E Xporting Data ($0.10)
  5. Basic M Ath An D S Tats With Sql ($0.10)
  6. E Xtracting I Nformation By Grouping An D Summarizing ($0.10)
  7. S Tatistical F Unctions In Sql ($0.10)
  8. Calculating Rates For Meaningful Comparisons ($0.10)
  9. Wrapping Up ($0.10)
  10. Working With Dates An D T Imes ($0.10)
  11. Data Types And Functions For Dates And Times ($0.10)
  12. Manipulating Dates And Times ($0.10)
  13. Working With Time Zones ($0.10)
  14. Calculations With Dates And Times ($0.10)
  15. Wrapping Up 2 ($0.10)
  16. Advance D Query T Echniques ($0.10)
  17. Using Subqueries ($0.10)
  18. Common Table Expressions ($0.10)
  19. Cross Tabulations ($0.10)
  20. Spatial Reference System Identifier ($0.10)
  21. Postgis Data Types ($0.10)
  22. Creating Spatial Objects With Postgis Functions ($0.10)
  23. Analyzing Farmers Markets Data ($0.10)
  24. Working With Census Shapefiles ($0.10)
  25. Performing Spatial Joins ($0.10)
  26. Wrapping Up 3 ($0.10)
  27. Using Views To Simplify Queries ($0.10)
  28. Programming Your Own Functions ($0.10)
  29. Automating Database Actions With Triggers ($0.10)
  30. M Aintaining Your Data B Ase ($0.10)
  31. Name Value ($0.10)
  32. Start With A Question ($0.10)
  33. Gather Your Data ($0.10)
  34. Assess The Datas Origins ($0.10)
  35. Consult The Datas Owner ($0.10)
  36. Identify Key Indicators And Trends Over Time ($0.10)
  37. Ask Why ($0.10)
  38. Communicate Your Findings ($0.10)
  39. Wrapping Up 4 ($0.10)
  40. Resources ($0.10)
  41. Find The Story In Your Data ($0.10)