Achieving Advanced Insights with BigQuery
5.0 /5- Offered byCoursera
- Public/Government Institute
Achieving Advanced Insights with BigQuery at Coursera Overview
Duration | 10 hours |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
Achieving Advanced Insights with BigQuery at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Course 3 of 4 in the From Data to Insights with Google Cloud Platform Specialization
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Beginner Level
- Approx. 10 hours to complete
- English Subtitles: English, Japanese
Achieving Advanced Insights with BigQuery at Coursera Course 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.
- >>> 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 <<<
Achieving Advanced Insights with BigQuery at Coursera Curriculum
Introduction
Course Intro
Qwiklabs Introduction
Advanced Functions - Statistical and Approximations
Analytic Functions, WITH clause, and RANK()
BigQuery User-Defined Functions (UDFs)
Sub-query and CTE design
Lab Overview
Advanced Functions
Background: Traditional Relational Database Architecture
Denormalized, Column-Based Storage
Table Sharding
Introducing Nested and Repeated Fields
Working with Arrays and Structs in BigQuery
BigQuery Standard SQL vs Legacy SQL
Practicing SQL on Repeated Fields in BigQuery
BigQuery Architecture
More Visualization with Google Data Studio
Advanced Data Studio: Case Statements and Filters
Sharing Dashboards and Data Access Pitfalls
Advanced Google Data Studio
Avoid BigQuery Performance Pitfalls
Data Skew in your Datasets
Diagnose Performance Issues with the Query Explanation map
Lab Overview
Performance Optimization
A primer on Notebooks in the Cloud
Cloud Datalab
Data Access Roles, Creating Authorized Views, and Common Pitfalls
Data Access
Course Recap
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?
Useful Links
Know more about Coursera
Know more about Programs
- Engineering
- Instrumentation Technology
- Food Technology
- BTech Chemical Engineering
- Aeronautical Engineering
- AI & ML Courses
- BTech Petroleum Engineering
- Metallurgical Engineering
- MTech in Computer Science Engineering
- VLSI Design
- Petroleum Engineering
- BTech Robotics Engineering
- Aerospace Engineering
- BTech in Biotechnology Engineering
- BTech Mechatronics Engineering