Practical SQL : a beginner's guide to storytelling with data /
Anthony DeBarros
- 2nd edition
- San Francisco, California : No Starch Press, Inc., c2022.
- xxviii, 427 pages : illustrations ; 24 cm.
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.
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.
978-1-7185-0106-5
SQL (COMPUTER PROGRAM LANGUAGE) DATABASE DESIGN COMPUTERS -- PRGRAMMING LANGUAGE -- SQL COMPUTERS -- DATABASE MANAGEMENT -- DATA MINING.