DifficultyIntermediate
AVG Duration3h
Students1739
Ratings
5/5
starstarstarstarstar
Content
3111

Description

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.

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

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 

Intended Audience

  • Anyone who is interested in analyzing data on Google Cloud Platform

Prerequisites

  • Experience with databases
  • Familiarity with writing queries using SQL is recommended
  • A Google Cloud Platform account is recommended (sign up for a free trial at https://cloud.google.com/free/ if you don’t have an account)

Certificate

Your certificate for this learning path
lock

Training Content

1
Course - Beginner - 36m
Introduction to Google BigQuery
Learn how to load data into BigQuery, run queries using standard SQL, and export data from BigQuery with this hands-on course.
2
Hands-on Lab - Beginner - 35m
Structure and Analyze Data with Google BigQuery
This Lab will show you the basic concepts of BigQuery and will allow you to handle data and query them in a real GCP environment.
3
Course - Intermediate - 37m
Optimizing Google BigQuery
Learn how to make BigQuery faster, cheaper, and more secure with this hands-on course.
4
Quiz - Intermediate - 9m
Google BigQuery Quiz
Google BigQuery Quiz
5
Course - Intermediate - 40m
Visualizing BigQuery Data with Google Data Studio
With this course, you'll learn how to visualize BigQuery Data with Google Data Studio and create BigQuery reports.
6
Exam - 30m
Exam: Google BigQuery
Exam: Google BigQuery
About the Author
Students97272
Courses64
Learning paths85

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).