CPB200: Google BigQuery for Data Analysts

Course details

This 3 day instructor­led class introduces participants to Google BigQuery. Through a combination of instructor­led presentations, demonstrations, and hands­on labs, students learn how to store, transform, analyze, and visualize data using Google BigQuery.
This class is intended for data analysts and data scientists responsible for: analyzing and visualizing big data, implementing cloud­based big data solutions, deploying or migrating big data applications to the public cloud, implementing and maintaining large­scale data storage environments, and transforming/processing big data.
At the end of this one­day course, participants will be able to:
Understand the purpose of and use cases for Google BigQuery
Describe ways in which customers have used Google BigQuery to improve their businesses
Understand the architecture of BigQuery and how queries are processed
Interact with BigQuery using the web UI and command­line interface
Identify the purpose and structure of BigQuery schemas and data types
Understand the purpose of and advantages of BigQuery destinations tables and caching
Use BigQuery jobs
Transform and load data into BigQuery
Export data from BigQuery
Store query results in a destination table
Create a federated query
Export log data to BigQuery and query it
Understand the BigQuery pricing structure and evaluate mechanisms for controlling query and storage costs
Identify best practices for optimizing query performance
Troubleshoot common errors in BigQuery
Use various BigQuery functions
Use external tools such as spreadsheets to interact with BigQuery
Visualize BigQuery data
Use access controls to restrict access to BigQuery data
Query Google Analytics Premium data exported to BigQuery Updated on 17 October, 2017