Complete Guide to Google BigQuery for Data and ML Engineers
4h 22mIntermediate2025-08-15
Authors
Dan Sullivan
Enterprise Architect, Big Data Expert
Pearson
Course details
Data and the ability to analyze it and use it to build machine learning models are driving innovation and new ways of organizing work in businesses. Enter Google BigQuery, the widely used data platform for data warehousing, analytics, and machine learning. BigQuery is offered as a managed, serverless offering from Google Cloud that lets you spend less time maintaining infrastructure and more time building machine learning systems and extracting insights from data. In this course, join instructor Dan Sullivan as he shows you how to get the most out of BigQuery as a data or machine learning engineer. Along the way, discover essential skills for ingesting data, transforming data to prepare it for analysis, and building, evaluating, deploying, and monitoring models in production.
Skills covered
BigQueryAI for Data Engineers and ScientistsMachine Learning FundamentalsTraditional AI and Machine LearningRole-Based AI ApplicationsData EngineeringGoogleArtificial Intelligence (AI)Data ScienceOne-Off
Concepts
Introduction
- Google BigQuery for data and ML engineers - Introduction
BigQuery for Data Engineering and Machine Learning Engineering
- Topics
- Serverless, multifunction data platform
- Architecture of BigQuery
- Data engineering and machine learning in BigQuery
Data Ingestion in BigQuery
- Topics
- Batch data ingestion
- Lab assignment - Batch data ingestion
- Streaming ingestion
- Lab assignment - Ingest streaming data
Data Quality and Data Exploration
- Topics
- SQL for data quality checks
- Lab assignment - Data quality checks
- DataFrames for data exploration
- Lab assignment - data exploration
- Cloud Dataproc Spark and BigQuery
Machine Learning with BigQuery
- Topics
- Introduction to machine learning
- Machine learning workflow
Building Classification and Regression Models in BigQuery
- Topics
- Building and evaluating a classification model
- Lab assignment - Build a classification model
- Building and evaluating a regression model
- Lab assignment - Build a regression model
Building a Time Series Predictive Model
- Topics
- Introduction to time series modeling
- Building time series model in SQL
- Lab building a time series model in SQL
Using Generative AI with BigQuery
- Topics
- Generative AI services in Google Cloud
- Introduction to generative AI in BigQuery
- Lab using generative AI tools in BigQuery
- Working with text in BigQuery
Conclusion
- Google BigQuery for data and ML engineers - Summary