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
Course Intro 2m Getting started with GCP and Qwiklabs 4m
Advanced Functions and Clauses
Lab Overview 0m BigQuery User-Defined Functions (UDFs) 5m Analytic Functions, WITH clause, and RANK() 18m Deriving Insights from Advanced SQL Functions v1.5 0m Sub-query and CTE design 4m Advanced Functions - Statistical and Approximations 8m Lab Solution 11m
Schema Design and Nested Data Structures
Lab Solution Walkthrough 12m Practicing SQL on Repeated Fields in BigQuery 8m Introducing Nested and Repeated Fields 4m Table Sharding 8m Data to Insights: Practicing Querying Nested and Repeated Fields v1.1 0m 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
Sharing Dashboards and Data Access Pitfalls 2m Advanced Data Studio:Case Statements and Filters 16m
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
Introducing Cloud Datalab 3m Demo:Cloud Datalab Notebook Cells 9m Benefits of Cloud Datalab 2m
Data Access
Data Access Roles, Creating Authorized Views, and Common Pitfalls 13m
Summary
Course Recap 2m
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
Google Cloud
About the author

Build, innovate, and scale with Google Cloud Platform.

More from the author
G Suite Security
Beginner
15m
Jun 2, 2020
G Suite Mail Management
Beginner
4m
Jun 2, 2020
Introduction to G Suite
Beginner
22m
Jun 2, 2020
More courses by Google Cloud

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT