Data Warehousing with BigQuery: Storage Design, Query Optimization, and Administration (DWBQ-SDQA)

 

Course Overview

In this course, you learn about the internals of BigQuery and best practices for designing, optimizing, and administering your data warehouse. Through a combination of lectures, demos, and labs, you learn about BigQuery architecture and how to design optimal storage and schemas for data ingestion and changes. Next, you learn techniques to improve read performance, optimize queries, manage workloads, and use logging and monitoring tools. You also learn about the different pricing models. Finally, you learn various methods to secure data, automate workloads, and build machine learning models with BigQuery ML.

Who should attend

Data analysts, data scientists, data engineers, and developers who perform work on a scale that requires advanced BigQuery internals knowledge to optimize performance.

Prerequisites

Course Objectives

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

Follow On Courses

Prices & Delivery methods

Online Training

Duration
3 days

Price
  • on request
Classroom Training

Duration
3 days

Price
  • on request

Click on town name or "Online Training" to book Schedule

Argentina

Online Training Time zone: UTC-3 Course language: Spanish
Online Training Time zone: UTC-3 Course language: Spanish
Online Training Time zone: UTC-3 Course language: Spanish

Brazil

Online Training Time zone: UTC-3 Course language: Portuguese
Online Training Time zone: UTC-3 Course language: Portuguese
Online Training Time zone: UTC-3 Course language: Portuguese

Chile

Online Training Time zone: UTC-4 Course language: Spanish
Online Training Time zone: UTC-3 Course language: Spanish
Online Training Time zone: UTC-3 Course language: Spanish

Colombia

Online Training Time zone: UTC-5 Course language: Spanish
Online Training Time zone: UTC-5 Course language: Spanish
Online Training Time zone: UTC-5 Course language: Spanish

Costa Rica

Online Training Time zone: Central Standard Time (CST) Course language: Spanish
Online Training Time zone: Central Standard Time (CST) Course language: Spanish
Online Training Time zone: Central Standard Time (CST) Course language: Spanish

Mexico

Online Training Time zone: Central Standard Time (CST) Course language: Spanish
Online Training Time zone: Central Standard Time (CST) Course language: Spanish
Online Training Time zone: Central Standard Time (CST) Course language: Spanish

Panama

Online Training Time zone: Eastern Standard Time (EST) Course language: Spanish
Online Training Time zone: Eastern Standard Time (EST) Course language: Spanish
Online Training Time zone: Eastern Standard Time (EST) Course language: Spanish

Peru

Online Training Time zone: UTC-5 Course language: Spanish
Online Training Time zone: UTC-5 Course language: Spanish
Online Training Time zone: UTC-5 Course language: Spanish
Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.