Practical SQL: A beginner's guide to storytelling with data - DeBarrosm, Anthony (San Francisco.: No Startch Press,Inc., 2018)
Acknowledgement --Chapter 1.Creating your first database and table --Chapter 2.Begining Data Exploration with SELECT --Chapter 3.Understanding Data Types --Chapter 4.Importing and Exporting Data --Chapter 5.Basic Math and Stats with SQL --Chapter 6.Joining Tables in a Relational Database --Chapter 7.Table Design That Works for you --Chapter 8.Extracting Information by Grouping and Summarizing --Chapter 9.Inspecting and Modifying Data --Chapter 10.Statistical Functions in SQL --Chapter 11.Working with Dates and Times --Chapter 12. Advanced Query Techniques --Chapter 13. MIning Text to Find Meaningful Data --Chapter 14. Analyzing Spatial Data with PostGIS --Chapter 15.Saving Time with views, Functions, and Triggers --Chapter 16.Using PostgreSQL from the Command Line --Chapter 17. Maintaining your Database --Chapter 18.Identifying and Telling the Story Behind Your Data
Includes contents Appendix, Index and References
Keywords: 9; 9