This course prepares you for the Google BigQuery Qualification Exam and is meant for solution developers, solutions architects, and data analysts who: 1) Analyze and query data using BigQuery; and 2) Incorporate BigQuery data analysis into cloud-based solutions. The training will cover: Google BigQuery Fundamentals; Loading Data Into BigQuery; Querying Data; and Exporting Data from BigQuery.
What am I going to get from this course?
- Analyze and query data using BigQuery
- Incorporate BigQuery data analysis into cloud-based solutions
Prerequisites and Target Audience
What will students need to know or do before starting this course?
Understanding of the fundamentals of Google App Engine is necessary to take this course. You can take the Experfy course "Google App Engine Qualification Exam Training" as a refresher. You must also know the fundamentals of MySQL.
Who should take this course? Who should not?
This course is meant for solution developers, solutions architects, and data analysts.
Module 1: Google BigQuery Fundamentals
Use cases for Google BigQuery
Streaming and batch jobs
BigQuery and MapReduce
Google BigQuery Fundamentals
Module 2: Loading Data Into BigQuery
Designing appropriate schemas for BigQuery
Creating datasets and tables
Defining access control for datasets
Preparing data for BigQuery
Quotas and quota management
Handling streaming data and bulk loading
Loading Data Into BigQuery
Running simple queries using the BigQuery console and the command-line tool (bq)
Querying data using the service API
Using the EACH parameter in queries
Using table decorators
Using table wildcard functions
Using JOIN and JOIN EACH clauses in queries
Using GROUP BY and GROUP EACH BY clauses in queries
Determining when to use the FLATTEN clause in a query
Module 4: Exporting Data from BigQuery
Control requirements for exporting data
Access control requirements for exporting data
Access quotas for BigQuery
Setting configuration options for destination formats and compression
Exporting data to Google Cloud Storage
Exporting Data from BigQuery