|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/bigquery/
课程评论：没有评论
课程名称: BigQuery for Big Data Engineers - 掌握 BigQuery 内部机制 课程概述: **[更新2024]** - 本课程根据最新的 BigQuery 用户界面和功能进行了更新。请注意，这门课程并不旨在教授 SQL 或 PostgreSQL，重点是深入了解 Google BigQuery 的概念与内部结构。BigQuery 是一个无服务器、高度可扩展且具有成本效益的数据仓库，旨在为 Google Cloud Platform (GCP) 存储和查询 PB 级的数据。 课程内容包括： - 对 Google Cloud 提供的一系列服务的简要介绍。 - 从基础到高级的 BigQuery 概念的完整深入学习，并涵盖实时实施。 - 每个 BigQuery 概念都通过实际操作示例进行解释，涵盖的细节非常详细。 - 学习如何使用 Web 控制台、Bq CLI 和 Python 客户端库与 BigQuery 进行交互。 - 创建、加载、修改和管理 BigQuery 数据集、表、视图、物化视图等。 - 独家内容：查询执行计划、高效的模式设计、优化技巧、分区、聚类。 - 构建和部署端到端的数据管道（批处理和流处理），结合实际案例研究。 - 管道中使用的服务包括：Dataflow、Apache Beam、Pub/Sub、BigQuery、Cloud Storage、Data Studio 以及 Cloud Composer/Airflow 等。 - 学习实时 Google Cloud BigQuery 项目中的最佳实践和优化技巧。 完成本课程后，您将可以自信地参与任何 BigQuery 项目的工作。 附加内容： - 提问和查询将得到快速回答。 - 课堂中使用的查询和数据集将附加在课程中以方便学习。 - 本课程将定期更新，持续添加 BigQuery 的新组件。
**[Updated 2024]** - This course is updated as per latest BigQuery UI and features. Note: This Bigquery course is NOT intended to teach SQL or PostgreSQL. The focus of the course is kept to give you In-depth knowledge of Google Bigquery concepts/Internals."BigQuery is server-less, highly scalable, and cost-effective Data warehouse designed for Google cloud Platform (GCP) to store and query petabytes of data."What's included in the course ?Brief introduction to the set of services Google Cloud provides.Complete In-depth knowledge of Google BigQuery concepts explained from Scratch to ADVANCE to Real-Time implementation.Each and every BigQuery concept is explained with HANDS-ON examples.Includes each and every, even thin detail of Big Query.Learn to interact with BigQuery using its Web Console, Bq CLI and Python Client Library.Create, Load, Modify and Manage BigQuery Datasets, Tables, Views, Materialized Views etc. *Exclusive* - Query Execution Plan, Efficient schema design, Optimization techniques, Partitioning, Clustering.Build and deploy end-to-end data pipelines (Batch & Stream) of Real-Time case studies in GCP.Services used in the pipelines- Dataflow, Apache Beam, Pub/Sub, Bigquery, Cloud storage, Data Studio, Cloud Composer/Airflow etc.Learn Best practices and Optimization techniques to follow in Real-Time Google Cloud BigQuery Projects.After completing this course, you can start working on any BigQuery project with full confidence.Add-OnsQuestions and Queries will be answered very quickly.Queries and datasets used in lectures are attached in the course for your convenience.I am going to update it frequently, every time adding new components of Bigquery.
