Achieving Advanced Insights with BigQuery

Want to know how to query and process petabytes of data in seconds? Curious about data analysis that scales automatically as your data grows? Welcome to the Data Insights course!This four-course accelerated online specialization teaches course participants how to derive insights through data analysis and visualization using the Google Cloud Platform. The courses feature interactive scenarios and hands-on labs where participants explore, mine, load, visualize, and extract insights from diverse Google BigQuery datasets. The courses also cover data loading, querying, schema modeling, optimizing p

Created by: Google Cloud Training

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100

icon
Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a go course? Or looking for more detail on Google Cloud Training's Achieving Advanced Insights with BigQuery? Feel free to chat below.
Join CourseDuck's Online Learning Discord Community

icon
Course Description

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: https://qwiklabs.com/terms_of_service <<

icon
Instructor Details

Google Cloud Training

The Google Cloud Training team is responsible for developing, delivering and evaluating training that enables our enterprise customers and partners to use our products and solution offerings in an effective and impactful way. Google Cloud helps millions of organizations empower their employees, serve their customers, and build what's next for their businesses with innovative technology created in-and for-the cloud. Our products are engineered for security, reliability, and scalability, running the full stack from infrastructure to applications to devices and hardware. Our teams are dedicated to helping customers apply our technologies to create success.

icon
Reviews

4.7

51 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Fernando E on 4-Dec-18

Really helpful with enough theory background and practical exercises

By Ridhima S on 25-Mar-19

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

By Ngo D V on 30-Mar-19

good for Data Analyst

By Michael T on 8-Jan-19

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 Juan D O on 13-Jul-18

Very interesting and nice to follow

By Jose L C V on 26-Aug-18

Muy buen curso

By LIJUN L on 10-Aug-18

Super GREAT job Evan! This is the most valuable BigQuery courses I've ever learned!

By Lawrence M on 11-Aug-18

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.

By Rommel J P on 11-Oct-18

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

By Nguyen V T H on 13-Nov-18

Good but lack of sql example and sql questions

By Oleg Z on 20-Nov-18

nice course

By Ekta M on 21-Aug-18

good