Data Warehousing with BigQuery: Storage Design, Query Optimization, and Administration

This course on Data Warehousing with BigQuery focuses on designing and managing an efficient data warehouse to enhance query performance. It is ideal for individuals seeking to develop skills in secure data governance, process automation, and building machine learning models with BigQuery ML. Targeted at developers with a foundational understanding of data analysis, SQL, and Google Cloud, the course covers essential strategies for storage design, query optimization, and administration, equipping participants with the tools needed to effectively manage data in a cloud environment.

Course Details

Price:

$1,875.00

Days:

Location:

Virtual

Course Overview

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

No specific prerequisites are required for this course. Basic computer literacy and familiarity with fundamental concepts in the subject area are recommended for the best learning experience.

• BigQuery Architecture Fundamentals
• BigQuery Architecture Fundamentals
• BigQuery Architecture Fundamentals
• Storage and Schema Optimizations
• Storage and Schema Optimizations
• Storage and Schema Optimizations
• Ingesting Data
• Ingesting Data
• Ingesting Data
• Changing Data
• Changing Data
• Changing Data
• Improving Read Performance
• Improving Read Performance
• Improving Read Performance
• Optimizing and Troubleshooting Queries
• Optimizing and Troubleshooting Queries
• Optimizing and Troubleshooting Queries
• Workload Management and Pricing
• Workload Management and Pricing
• Workload Management and Pricing
• Logging and Monitoring
• Logging and Monitoring
• Logging and Monitoring
• Security in BigQuery
• Security in BigQuery
• Security in BigQuery
• Automating Workloads
• Automating Workloads
• Automating Workloads
• Machine Learning in BigQuery
• Machine Learning in BigQuery
• Machine Learning in BigQuery

Class Dates & Times


6/11/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $1,875.00
8/13/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $1,875.00
10/22/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $1,875.00
12/17/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $1,875.00

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →