Summary
You have just completed this real-world case study using SQL. In this chapter, you utilized the SQL skills you have gained throughout this book, from simple SELECT statements to aggregating complex data types. You started this case study with an understanding of the storage characteristics required by data analysis and the data warehouse ecosystem that is built to provide these characteristics. Then you walked through the data loading process step by step, from raw data copying all the way to the final queries for analysis. After completing this chapter, you will be able to create similar tasks in your own data projects.
You have reached the end of this book. Throughout these chapters, you have learned about data and how you can make sense of it with one of the most important computer technologies, SQL. You learned how SQL’s powerful functionality can be used to organize data, process it, and identify interesting patterns. Additionally, you saw how SQL can be connected...
