About this Course

18,898 recent views
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Beginner Level
Approx. 10 hours to complete
English

Skills you will gain

BigqueryGoogle Cloud PlatformCloud ComputingSQL
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Beginner Level
Approx. 10 hours to complete
English

Instructor

Offered by

Placeholder

Google Cloud

Syllabus - What you will learn from this course

Week
1

Week 1

7 minutes to complete

Introduction

7 minutes to complete
2 videos (Total 7 min)
2 videos
Qwiklabs Introduction5m
2 hours to complete

Advanced Functions and Clauses

2 hours to complete
5 videos (Total 34 min)
5 videos
Analytic Functions, WITH clause, and RANK()18m
BigQuery User-Defined Functions (UDFs)4m
Sub-query and CTE design3m
Lab Overview15s
1 practice exercise
Advanced Functions30m
2 hours to complete

Schema Design and Nested Data Structures

2 hours to complete
7 videos (Total 58 min)
7 videos
Denormalized, Column-Based Storage4m
Table Sharding7m
Introducing Nested and Repeated Fields3m
Working with Arrays and Structs in BigQuery21m
BigQuery Standard SQL vs Legacy SQL1m
Practicing SQL on Repeated Fields in BigQuery8m
1 practice exercise
BigQuery Architecture30m
Week
2

Week 2

1 hour to complete

More Visualization with Google Data Studio

1 hour to complete
2 videos (Total 18 min)
2 videos
Sharing Dashboards and Data Access Pitfalls1m
1 practice exercise
Advanced Google Data Studio30m
2 hours to complete

Optimizing for Performance

2 hours to complete
4 videos (Total 30 min)
4 videos
Data Skew in your Datasets1m
Diagnose Performance Issues with the Query Explanation map19m
Lab Overview18s
1 practice exercise
Performance Optimization30m
2 hours to complete

Advanced Insights with Cloud AI Platform

2 hours to complete
1 reading
1 reading
A primer on Notebooks in the Cloud10m
1 practice exercise
Cloud Datalab30m
1 hour to complete

Data Access

1 hour to complete
1 video (Total 13 min)
1 practice exercise
Data Access30m
2 minutes to complete

Summary

2 minutes to complete
1 video (Total 2 min)
1 video

Reviews

TOP REVIEWS FROM ACHIEVING ADVANCED INSIGHTS WITH BIGQUERY

View all reviews

About the From Data to Insights with Google Cloud Platform Specialization

From Data to Insights with Google Cloud Platform

Frequently Asked Questions

More questions? Visit the Learner Help Center.