Cloud Academy – Optimizing Google BigQuery

BigQuery 是 Google 令人难以置信的快速、安全且价格低廉的数据仓库，但有多种方法可以使其更快、更便宜且更安全。

以下是您将在本课程中学到的一些示例：

BigQuery 可以在几秒钟内处理数十亿行，但前提是您要打破关系数据库设计的规则。
如果您分析的数据量相对较少，那么您的查询成本不会很高，但如果您定期分析庞大的数据集，那么您的成本会迅速增加。但是，通过对在 BigQuery 中存储数据的方式进行一些调整，您只需花费一小部分成本即可运行查询。
为了让您能够灵活地实施细粒度的安全性，BigQuery 具有多层访问控制功能，但它们可能会令人困惑，因此我将向您展示使用哪些功能来满足您组织的要求。
这是一门实践课程，您可以在其中使用自己的 Google Cloud 帐户或试用帐户进行演示。如果您还没有使用 BigQuery 的经验，请先阅读 Google BigQuery 简介。

MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz, 2 Ch
Difficulty: Intermediate | Genre: eLearning | Language: English | Duration: 7 Lectures (39m) | Size: 588 MB

BigQuery is Google’s incredibly fast, secure, and surprisingly inexpensive data warehouse, but there are ways to make it even faster, cheaper, and more secure.

Here are some examples of what you will learn in this course:

BigQuery can process billions of rows in seconds, but only if you break the rules of relational database design.
If you are analyzing relatively small amounts of data, then your queries won’t cost very much, but if you regularly analyze huge datasets, then your costs can add up quickly. However, with a few adjustments to how you store your data in BigQuery, you can run queries for a fraction of the cost.
To give you the flexibility to implement fine-grained security, BigQuery has several layers of access control capabilities, but they can be confusing, so I’ll show you which ones to use to meet your organization’s requirements.
This is a hands-on course where you can follow along with the demos using your own Google Cloud account or a trial account. If you don’t already have experience with BigQuery, then please take Introduction to Google BigQuery first

Learning Objectives

Reduce your BigQuery costs by reducing the amount of data processed by your queries
Create, load, and query partitioned tables for daily time series data
Speed up your queries by using denormalized data structures, with or without nested repeated fields
Implement fine-grained access control using roles and authorized views