开始时间: 12/21/2023 持续时间: 1 week of study, 5-7 hours/week
|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/gcp-advanced-insights-bigquery
课程评论：没有评论
The third course in this course series 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. After completing this course, enroll in the Applying Machine Learning to your Data with Google Cloud course. >>> 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 <<<
Name:Introduction
Description:Overview of what you will learn in this course
Name:Advanced Functions and Clauses
Description:Deepen your knowledge of SQL on BigQuery by learning about more advanced functions like statistical approximations, analytical window queries, user-defined functions, and WITH clauses.
Name:Schema Design and Nested Data Structures
Description:Walkthrough the evolution of how traditional databases handle dataset scale and compare how BigQuery was developed to address scaling limitations. Deep dive into nested and repeated fields which are a key part of denormalized BigQuery data structures.
Name:Optimizing for Performance
Description:Learn the fundamental pieces of work that impact BigQuery performance and how to optimize your queries for speed.
Name:Advanced Insights with Vertex AI Workbench
Description:Introducing Vertex AI Workbench -- a key tool in the Data Scientist toolkit -- which enables analysts to collaborate through the use of scalable cloud notebooks.
Name:Data Access
Description:Securing and sharing your BigQuery datasets is critical for any organization. Learn what Google Cloud and BigQuery tools are available to you to permission control and share your data.
Name:Summary
Description:Summary of the course ley learning points
本课程系列的第三门课程是使用 BigQuery 获得高级见解。 在这里，我们将深入了解高级功能以及如何将复杂的查询分解为可管理的步骤，从而建立在您不断增长的 SQL 知识的基础上。 我们将通过使用数组和结构来介绍 BigQuery（基于列的分片存储）的内部架构以及嵌套和重复字段等高级 SQL 主题。 最后，我们将深入探讨优化查询以提高性能，以及如何通过授权视图保护数据。 完成本课程后，注册使用 Google Cloud 将机器学习应用于您的数据课程。 >>> 注册此专业即表示您同意常见问题解答中规定的 Qwiklabs 服务条款，该条款位于：https://qwiklabs.com/terms_of_service <<<
