TY  - BOOK
AU  - DeBarros, Anthony
TI  - Practical SQL: a beginner's guide to storytelling with data 
SN  - 978-1-7185-0106-5
AV  - QA 76.73 D43 2022 
PY  - 2022///
CY  - San Francisco, California
PB  - No Starch Press, Inc.
KW  - SQL (COMPUTER PROGRAM LANGUAGE)
KW  - DATABASE DESIGN
KW  - COMPUTERS -- PRGRAMMING LANGUAGE -- SQL
KW  - COMPUTERS -- DATABASE MANAGEMENT -- DATA MINING
N1  - Includes index; Chapter 1 : Setting up your coding environment -- Chapter 2 : Creating your first database and table -- Chapter 3 : Beginning data exploration with SELECT -- Chapter 4 : Understanding data types -- Chapter 5 : Importing and exporting data -- Chapter 6 : Basic math and stats with SQL -- Chapter 7 : Joining tables in relational database -- Chapter 8 : Table design that works for you -- Chapter 9 : Extracting information by grouping and summarizing -- Chapter 10 : Inspecting and modifying data -- Chapter 11 : Statistical functions in SQL -- Chapter  12 : Working with dates and times -- Chapter 13 : Advanced query techniques -- Chapter 14 : Mining text to find meaningful data -- Chapter 15 : Analyzing spatial data with PostGIS -- Chapter 16 : Working with JSON data -- Chapter 17 : Saving time with views, functions, and triggers -- Chapter18 : Using PostgreSQL from the command line -- Chapter  19 : Maintaining your database -- Chapter20 : Telling your data's story -- Appendix -- Index
N2  - This second edition has been revised to reflect the latest in SQL code and practices. These updates include more thorough instructions to set up your system, a new chapter on working with the popular and portable JSON data format, improved examples using the latest data techniques, and new syntax and techniques for handling data. -- back cover
ER  -