Practical SQL. A Beginner's Guide to Storytelling With Data
- 427 stránek
- 15 hodin čtení
Anthony DeBarros Pořadí knih (chronologicky)
Anthony DeBarros combines a passion for data analysis and coding with a knack for storytelling. His journalistic work delves into complex topics such as the economy and politics, leveraging his expertise to uncover and present insights. He approaches his craft with a unique blend of technical skill and narrative flair, making intricate subjects accessible and engaging for readers.
Practical SQL
- 392 stránek
- 14 hodin čtení
Introduction Chapter 1: Creating your first database & table Chapter 2: Beginning Data Exploration with SELECT Chapter 3: Understanding Data Types Chapter 4: Importing and Exporting Data Chapter 5: Basic Math and Stats Chapter 6: Joining Tables in a Relational Database Chapter 7: Table Design that Works for You Chapter 8: Grouping and Summarizing Data Chapter 9: Cleaning , Modifying, Deleting Data Chapter 10: Ranks, Rates, asnd Stats Chapter 11: Dealing with Dates Chapter 12: Advanced Queries Chapter 13: Full- Text Search Chapter 14: GIS Chapter 15: Views Chapter 16: Working from the command line Chapter 17: Maintenance Appendix A: Alternative software and text editors Appendix B: Solutions