Working with JSON, Arrays, and Structs in BigQuery GSP416
https://www.cloudskillsboost.google/f...
00:00 Task 1. Create a new dataset to store the tables
01:00 Task 2. Practice working with arrays in SQL
05:53 Task 3. Creating your own arrays with ARRAY_AGG()
08:10 Task 4. Querying datasets that already have arrays
09:38 Task 5. Introduction to STRUCTs
14:40 Task 6. Practice with STRUCTs and arrays
19:15 Task 7. Lab question: STRUCT()
19:40 Task 8. Lab question: Unpacking arrays with UNNEST( )
20:05 Task 9. Filtering within array values