Chevron Left
返回到 Achieving Advanced Insights with BigQuery

Achieving Advanced Insights with BigQuery, Google 云端平台

269 個評分
34 個審閱


The third course in this specialization is Achieving Advanced Insights with BigQuery. Here we 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. >>> By enrolling in this specialization you agree to the Qwiklabs Terms of Service as set out in the FAQ and located at: <<<...


創建者 KF

Sep 18, 2018

Useful practical course, especially about performance optimization. Window functions have many options, it would be nice to add window size description with practical examples or links to them.

創建者 LM

Aug 11, 2018

Excellent course; I only wish there were a much longer and more robust lab on optimizing query performance, after all the tips we learned in the corresponding lessons.


34 個審閱

創建者 Sirisha Pasumarthy

Jan 26, 2019

I am excited with Bigquery Advanced concepts and giving me a great learning.

創建者 Michael To

Jan 08, 2019

I learned lots about the structs and arrays and how it could be used to improve performance by creating parent child relationships instead of doing expensive joins

創建者 Fernando Escobar

Dec 04, 2018

Really helpful with enough theory background and practical exercises

創建者 Oleg Zagorulko

Nov 20, 2018

nice course

創建者 Arun Biji Mathew

Nov 18, 2018

Good course, more detailed/complex but practical scenarios in data warehousing space would be appreciated.

創建者 Nguyen Vu Trung Hieu

Nov 13, 2018

Good but lack of sql example and sql questions

創建者 Sanket Mehta

Oct 19, 2018

The course was fun with learning. One suggestion to improve the video player somewhat.

創建者 Aditya Shivam

Oct 15, 2018


創建者 Rommel John Panal

Oct 11, 2018

Some useful insights here that I can immediately apply to my work in BigQuery.

創建者 Akshaya

Oct 02, 2018

A lab on notebook would have been nice.