Chevron Left
Back to Achieving Advanced Insights with BigQuery

Achieving Advanced Insights with BigQuery, Google Cloud

4.7
303 ratings
36 reviews

About this Course

***NEW! Specialization Completion Challenge, receive Qwiklabs credits valued up to $120! See below for details.*** 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. SPECIALIZATION COMPLETION CHALLENGE As if learning new skills wasn’t enough of an incentive, we're excited to announce a special completion challenge for 'From Data to Insights on Google Cloud Platform’ specialization. Here’s how it works: Our completion challenge runs through 11:59pm PT May 5, 2019. Complete any course in this Specialization anytime in this period and we'll send you 30 Qwiklabs credits for each course completed (upto $120 value given there are 4 courses in the specialization). You can use these credits to take additional labs and earn badges, which you can then add to your resume and social profiles. >>> By enrolling in this specialization you agree to the Qwiklabs Terms of Service as set out in the FAQ and located at: https://qwiklabs.com/terms_of_service <<<...

Top reviews

By 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.

By 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.

Filter by:

36 Reviews

By Ngo Doan Vinh

Mar 30, 2019

good for Data Analyst

By Ridhima Shinde

Mar 25, 2019

Absolutely important topics such as handling nested fields, query optimization techniques and advanced functions are covered. Excellent content!

By Sirisha Pasumarthy

Jan 26, 2019

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

By 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

By Fernando Escobar

Dec 04, 2018

Really helpful with enough theory background and practical exercises

By Oleg Zagorulko

Nov 20, 2018

nice course

By Arun Biji Mathew

Nov 18, 2018

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

By Nguyen Vu Trung Hieu

Nov 13, 2018

Good but lack of sql example and sql questions

By Sanket Mehta

Oct 19, 2018

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

By Aditya Shivam

Oct 15, 2018

Superb!!!