Congratulations, that does it for this second course in the Data to Insights Specialization. Let's do a recap of what we just learned. We covered how you can permanently store the results of your queries into tables and retrieve them later. And don't forget that BigQuery's going to store those results of every single one of your queries into temporary tables. Which are around for 24 hours and actually form the basis of query cache. And keep in mind, you can always promote these temp tables into permanent ones, as you practiced in your lab. We compared the different methods for loading and storing data as external connections, or BigQuery managed tables. Recall that querying external data directly instead of storing it inside of BigQuery, can be useful for things like one time ETL or extract transfer load queries. But not so useful for performance at scale. We explored SQL JOINS and UNIONS. Now you can relate and query your data across multiple different tables. You then learned tips and tricks like using wildcards and partitions, for better performance across subsets of data. Then lastly, we did some fun exercise and perception when we covered visualization theory. And putting into practice creating those interactive dashboards inside of Google Data Studio. Well that does it for this second course, tune in for the next course which covers advanced sequel topics like, statistical functions, in-depth query performance and, an inside look as to how BigQuery operates from an architectural standpoint. We'll see you there.
