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.
Get started
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
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 Lab: 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 Lab: 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 Lab: 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 25m
Your 10-day individual free trial includes:

Expert-led courses

Keep up with the pace of change with thousands of expert-led, in-depth courses.
Start a 10-day free trial
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
Developing Data Models with LookML
Intermediate
2h 37m
Nov 24, 2021
Migrating to Google Cloud
Intermediate
4h 55m
Nov 3, 2021
Networking in Google Cloud: Defining and Implementing Networks
Intermediate
3h 32m
Nov 2, 2021
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

Course info
Level
Beginner
Updated
Oct 1, 2019
Duration
3h 25m
Pluralsight IQ
Know exactly where everyone on your team stands with assessments and analytics.
Try our full library including this course free for your whole team for 14-days.