Achieving Advanced Insights with BigQuery
By Google Cloud
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.
Course info
Level
Beginner
Updated
Oct 1, 2019
Duration
3h 25m
Table of contents
Introduction
Advanced Functions and Clauses
BigQuery User-Defined Functions (UDFs)
5m
Analytic Functions, WITH clause, and RANK()
18m
Lab Overview
0m
Deriving Insights from Advanced SQL Functions v1.5
0m
Sub-query and CTE design
4m
Lab Solution
11m
Advanced Functions - Statistical and Approximations
8m
Schema Design and Nested Data Structures
Data to Insights: Practicing Querying Nested and Repeated Fields v1.1
0m
Practicing SQL on Repeated Fields in BigQuery
8m
Introducing Nested and Repeated Fields
4m
Table Sharding
8m
Lab Solution Walkthrough
12m
Working with Arrays and Structs in BigQuery
21m
Background:Traditional Relational Database Architecture
11m
Denormalized, Column-Based Storage
4m
BigQuery Standard SQL vs Legacy SQL
1m
More Visualization with Google Data Studio
Optimizing for Performance
Data Skew in your Datasets
1m
Avoid BigQuery Performance Pitfalls
9m
Data to Insights: Optimizing and Troubleshooting Query Performance v1.1
0m
Lab Overview
0m
Lab Solution Walkthrough
6m
Diagnose Performance Issues with the Query Explanation map
19m
Advanced Insights with Cloud Datalab
Data Access
Summary
Description
Course info
Level
Beginner
Updated
Oct 1, 2019
Duration
3h 25m
Description
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.
About the author
About the author
Build, innovate, and scale with Google Cloud Platform.
More from the author
More courses by Google Cloud