Data Warehousing w/ BigQuery: Storage Design, Query Optimization, Administration (GC-DWB-SQA)

About this course

Get the most from BigQuery. Over three days you will learn its architecture, design storage and schemas for performance, ingest data with DML and scheduled transfers, optimise queries using proven patterns and avoiding anti-patterns, and manage capacity and automate workloads.

What you'll learn

• Describe BigQuery architecture fundamentals.
• Implement storage and schema design patterns to improve performance
• Use DML and schedule data transfers to ingest data.
• Apply best practices to improve read efficiency and optimize query performance.
• Manage capacity and automate workloads.
• Understand patterns versus anti-patterns to optimize queries and improve read performance.
• Use logging and monitoring tools to understand and optimize usage patterns.
• Apply security best practices to govern data and resources.
• Build and deploy several categories of machine learning models with BigQuery ML.

Curriculum

Who it's for

Data engineers, analysts and BigQuery administrators.

Before you start

• Big Data and Machine Learning Fundamentals