BigQuery for Data Science

Analyze Data in an Optimized way at Google Scale

Duration

3 Days

Level

Intermediate Level

Design and Tailor this course

As per your team needs

Edit Content

The purpose of this course is to provide participants with knowledge and skills essential to work with BigQuery in an optimal manner. The participants will understand how BigQuery works, its Architecture, Best Practices and how to optimize it for minimizing the cost and reducing the query runtime.

The lab exercises of the course will be performed using Jupyter Lab Environment.

Edit Content

Data Analysts
Data Engineers
Data Scientists

Edit Content

BigQuery (BQ) Overview

Features of Big Query
Big Query Architecture
How BigQuery stores data
How does a query execute on BQ?
Various APIs in BQ
Bootstrapping Lab Environment

Working with BigQuery

Ways to interact with BigQuery
BQ Command line interface
Exploring BigQuery Dataset & Tables
BigQuery Table Types
Wildcard Tables & its limitations
Query Execution Plan
Writing Effective Queries
With Clause in BigQuery
BigQuery Core – Python Client API

BigQuery Capabilities

Understanding Query Metadata
Caching in BigQuery
Time Travels and
Table Snapshots
Table Clones
Extending BQ

Structuring the Data Model

Approach of Data Modeling
Denormalized Tables
Understanding Key Data Formats
Solving Data Skew Problem
Working with Views
Using Materialized Views

Tuning BigQuery

Scope of Optimizations
Ways to Optimize Big Query
Understanding Slots & BigQuery Pricing
Diagnose Query Performance Issues
Query Plan Analysis
Understanding Partitioning
Key considerations for Partitioning
Making use of Partitioning
Benefits of Clustering
Key considerations for Clustering
Making use of Clustered Tables
When to prefer Partitioning, Clustering, or Both
Exploring Indexing Capability
Exploring Join and Best Practices
Nested & Repeated Data
Best Practices for BigQuery

Edit Content

Participants must have knowledge of –

SQL query language
Data Warehousing concepts
Jupyter Notebook Environment
Python Basics

Knowledge of “Basics of BigQuery” will be a plus.

our Footprints

Quick Links

our Offerings

Follow Us

Sign up for DataCouch Communications

Copyright 2024 © DataCouch

Apache, Apache Kafka, Apache Spark, Apache Trino, Apache Iceberg, Apache Hive, Kafka, Spark, Trino, Iceberg, Hive, and other associated open-source project names are the Apache Software Foundation trademarks. Starburst, Starburst Data, Starburst Enterprise, and Starburst Galaxy are registered trademarks of Starburst Data, Inc. All rights reserved. DataCouch is not affiliated with, endorsed by, or otherwise associated with the Apache Software Foundation (ASF) or any of its projects.