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 26m
Table of contents
Introduction
Course Intro 2m Getting started with GCP and Qwiklabs 4m
Advanced Functions and Clauses
Advanced Functions - Statistical and Approximations 8m Analytic Functions, WITH clause, and RANK() 18m BigQuery User-Defined Functions (UDFs) 5m Sub-query and CTE design 4m Lab Overview 0m Deriving Insights from Advanced SQL Functions v1.5 0m Lab Solution 11m
Schema Design and Nested Data Structures
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 Data to Insights: Practicing Querying Nested and Repeated Fields v1.1 0m Lab Solution Walkthrough 12m
More Visualization with Google Data Studio
Advanced Data Studio:Case Statements and Filters 16m Sharing Dashboards and Data Access Pitfalls 2m
Optimizing for Performance
Avoid BigQuery Performance Pitfalls 9m Data Skew in your Datasets 1m Diagnose Performance Issues with the Query Explanation map 19m Lab Overview 0m Data to Insights: Optimizing and Troubleshooting Query Performance v1.1 0m Lab Solution Walkthrough 6m
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 26m
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
App Deployment, Debugging, and Performance
Beginner
1h 30m
Oct 31, 2019
Securing and Integrating Components of your Application
Beginner
1h 17m
Oct 31, 2019
Reliable Cloud Infrastructure - Design and Process
Beginner
4h 48m
Oct 30, 2019
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