Practical SQL: A beginner's guide to storytelling with data/
DeBarrosm, Anthony
Practical SQL: A beginner's guide to storytelling with data/ by Anthony DeBarros - San Francisco.: No Startch Press,Inc., c2018 - x-351p.: 23.5cm - c2018
Includes contents Appendix, Index and References
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
978-1-59327-827-4
SQL (Computer program language)
Database design
BCir. 005.756 / O350p
Practical SQL: A beginner's guide to storytelling with data/ by Anthony DeBarros - San Francisco.: No Startch Press,Inc., c2018 - x-351p.: 23.5cm - c2018
Includes contents Appendix, Index and References
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
978-1-59327-827-4
SQL (Computer program language)
Database design
BCir. 005.756 / O350p