Cloud Academy – Google BigQuery

Does your organization generate a huge amount of data every day? Does all of that data sit in a number of different databases, making it difficult to analyze? Even if you already have a data warehouse, can it keep up with your constantly growing volume of data? Google’s solution to these problems is Google BigQuery, a massive, lightning-fast data warehouse in the cloud.

This learning path will first show you the fundamentals of how to use BigQuery and then how to optimize BigQuery to reduce costs, speed up your queries, and apply proper access control.

Learning Objectives

Load data into BigQuery using files or by streaming one record at a time
Run a query using standard SQL and save your results to a table
Export data from BigQuery using Google Cloud Storage
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

So, if you’re interested in learning more about Google BigQuery, then click on the first course to get started!

Updates

June 13, 2018 – Added learning path exam

Miscellaneous
Provider: Cloud Academy
Title: Google BigQuery

Knowledge must be free. We are a 0day e-learning release group.
You can find us on Discord and pass some exams together. You will know when you found us.

Internal ID: CA44