• This course is designed for anyone interested to get started with using BigQuery on GCP – Software Developers, DBA, Architects.

• Basic knowledge of relational databases and SQL is desired but not mandatory. Basic understanding of Google Cloud Platform is required.

Course Outline:

1. Introduction to GCP and Data Warehousing
   1. Refresher on what is GCP
   2. What is Data Warehouse & Why is it used?
2. BigQuery Architecture
   1. Understanding BigQuery Architecture
   2. Data Storage – sources and storage
   3. Query Processing Engine
   4. Lab: Hands-on Lab to get started with BigQuery
3. Working with data in BigQuery
   1. Understand the different BigQuery data sources
   2. Working with Joins and Unions
   3. Understanding Table Partitioning
   4. Using semi-structured data like JSON, Geo-Spatial data
   5. Lab: Couple of labs on these topics
4. Understanding Query Execution
   1. Understand BigQuery execution
   2. Tables & Views in BigQuery
   3. Understanding BigQuery pricing and costs
   4. Lab: Data Ingestion
5. Machine Learning on BigQuery
   1. Performing machine learning with BigQuery
   2. Build Classification, Regression models using BigQuery
   3. Lab: Building models using BQML

Training material provided:

Yes (Digital format)

• Hands-on Lab: Students must create Qwiklabs account for performing hands-on labs.