Achieving Advanced Insights with BigQuery
Achieving Advanced Insights with BigQuery will build on your growing knowledge of SQL as we dive into advanced functions and how to break apart a complex query into manageable steps. We will cover the internal architecture of BigQuery (column-based sharded storage) and advanced SQL topics like nested and repeated fields through the use of Arrays and Structs. Lastly we will dive into optimizing your queries for performance and how you can secure your data through authorized views.
What you'll learn
Achieving Advanced Insights with BigQuery will build on your growing knowledge of SQL as we dive into advanced functions and how to break apart a complex query into manageable steps. We will cover the internal architecture of BigQuery (column-based sharded storage) and advanced SQL topics like nested and repeated fields through the use of Arrays and Structs. Lastly we will dive into optimizing your queries for performance and how you can secure your data through authorized views.
Table of contents
- Background:Traditional Relational Database Architecture 11m
- Denormalized, Column-Based Storage 4m
- Table Sharding 8m
- Introducing Nested and Repeated Fields 4m
- Working with Arrays and Structs in BigQuery 21m
- BigQuery Standard SQL vs Legacy SQL 1m
- Practicing SQL on Repeated Fields in BigQuery 8m
- Lab: Data to Insights: Practicing Querying Nested and Repeated Fields v1.1 0m
- Lab Solution Walkthrough 12m