Conclusion

Contents

keyboard_tab
Introduction
1
Introduction
PREVIEW1m 5s
Security
Summary

The course is part of these learning paths

Optimizing Cloud Costs
11
1
2
3
Google BigQuery
3
1
1
1
Google Professional Cloud Architect Exam Preparation
8
2
14
1
more_horizSee 1 more
Start course
Overview
Difficulty
Intermediate
Duration
37m
Students
2195
Ratings
4.9/5
starstarstarstarstar-half
Description

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.

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

Intended Audience

  • Database administrators
  • Anyone who wants to learn how to get the most out of Google BigQuery

Prerequisites

To get the most out of this course, you should already have some experience with BigQuery. If you don’t, then please take Introduction to Google BigQuery first.

Resources

The GitHub repository for this course can be found at https://github.com/cloudacademy/optimizing-bigquery/.

Transcript

I hope you enjoyed learning how to optimize BigQuery. Now you know how to reduce the amount of data processed by queries, speed up your queries through denormalization, and use access controls on projects, datasets, and tables.

To learn more about BigQuery, you can read Google’s online documentation. You can also try one of the other Google courses on Cloud Academy, and watch for new ones, because we’re always developing new courses.

If you have any questions or comments, please let me know in the Comments tab below this video. Thanks and keep on learning!

About the Author
Avatar
Guy Hummel
Azure and Google Cloud Content Lead
Students
107922
Courses
66
Learning Paths
86

Guy launched his first training website in 1995 and he's been helping people learn IT technologies ever since. He has been a sysadmin, instructor, sales engineer, IT manager, and entrepreneur. In his most recent venture, he founded and led a cloud-based training infrastructure company that provided virtual labs for some of the largest software vendors in the world. Guy’s passion is making complex technology easy to understand. His activities outside of work have included riding an elephant and skydiving (although not at the same time).