|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/gcp-advanced-insights-bigquery
课程评论：没有评论
课程名称：通过BigQuery获得高级洞察力 课程概述：这是该系列课程的第三门课程，旨在帮助学生在SQL的基础上深入了解高级功能，以及如何将复杂的查询分解为可管理的步骤。课程将涵盖BigQuery的内部架构（列存储分片）以及高级SQL主题，如通过数组和结构体使用的嵌套和重复字段。最后，我们将探讨如何优化查询性能并通过授权视图保护数据。 完成本课程后，您可以注册“将机器学习应用于您的数据与Google Cloud”课程。 课程大纲： 1. **介绍**：概述您将在本课程中学习的内容。 2. **高级函数和子句**：深化您对BigQuery上SQL的知识，学习更高级的函数，如统计近似、分析窗口查询、自定义函数以及WITH子句。 3. **模式设计和嵌套数据结构**：回顾传统数据库如何处理数据集规模的演变，并比较BigQuery如何开发以解决扩展性限制。深入了解嵌套和重复字段，这些字段是去规范化BigQuery数据结构的一部分。 4. **性能优化**：学习影响BigQuery性能的基本工作要素，以及如何优化查询速度。 5. **通过Vertex AI工作台获得高级洞察**：介绍Vertex AI工作台——数据科学家工具包中的关键工具，使分析师能够通过可扩展的云笔记本进行协作。 6. **数据访问**：确保和共享您的BigQuery数据集对任何组织都至关重要。了解Google Cloud和BigQuery提供的工具，以进行权限控制和数据共享。 7. **总结**：本课程学习要点的总结。 通过本课程的学习，学员将能够深入掌握BigQuery的高级功能，并有效地在云环境中进行数据分析与管理。
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
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 <<<
