Google BigQuery

• Basic understanding of databases and SQL concepts

Audience

• Data analysts
• Database administrators

Google BigQuery is a powerful serverless data warehousing and analytics platform that provides tools to query and analyze large datasets, optimize query performance, integrate with other GCP services, and even build machine learning models.

This instructor-led, live training (online or onsite) is aimed at advanced-level data analysts who wish to learn how to use Google BigQuery for data querying, optimization, and machine learning integration.

By the end of this training, participants will be able to:

• Understand the fundamentals of Google BigQuery and its use for data analytics and cloud computing.
• Use Google BigQuery for data management and complex SQL queries.
• Implement query optimization strategies to improve performance.
• Integrate BigQuery with other Google Cloud services.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction

• Overview of Google BigQuery

Getting Started

• Setting up a Google Cloud account
• Introduction to BigQuery Web UI
• Creating and managing datasets and tables
• Loading data into BigQuery
• Basic SQL queries in BigQuery

SQL Query in BigQuery

• Advanced SQL querying techniques
• Aggregating data with GROUP BY
• Filtering and sorting data
• Working with date and time functions
• Joining multiple tables
• Subqueries and window functions

Advanced BigQuery Features

• Exporting data from BigQuery
• Using user-defined functions (UDFs)
• Managing and scheduling queries
• Introduction to BigQuery scripting
• Handling arrays and structs
• Working with JSON data

BigQuery Optimization

• Query performance optimization techniques
• Partitioning and clustering tables
• Using the Query Execution Plan
• Troubleshooting and debugging queries
• Cost control and billing best practices
• Security and access control in BigQuery

Advanced Topics and Integration

• Real-time data analysis with streaming data
• Integrating BigQuery with Google Data Studio
• Introduction to BigQuery ML for machine learning
• Building and deploying machine learning models with BigQuery ML
• Data lake integration with BigQuery

Summary and Next Steps