Google BigQuery for Data and ML Engineers (Video Course)

Description

Master Google BigQuery to transform your data engineering and machine learning skills with hands-on, expert-led training.

• Gain in-depth knowledge of BigQuerys serverless architecture, data warehousing capabilities, and advanced SQL functionalities to efficiently manage and analyze large datasets.
• Learn to build, evaluate, and deploy machine learning models directly within BigQuery, covering essential techniques.
• Explore the cutting-edge applications of generative AI in BigQuery.

Dive into the world of data engineering and machine learning with Google BigQuery for Data and ML Engineers, a comprehensive course designed to equip you with the skills needed to leverage Google Clouds BigQuery in your everyday work. Whether youre a beginner or looking to deepen your expertise, this course offers hands-on experience with data ingestion, transformation, and advanced machine learning techniques. Led by Dan Sullivan, a seasoned cloud architect and author, youll explore the intricacies of BigQuerys architecture, learn to build robust data pipelines, and harness the power of generative AI tools. Transform your data skills and elevate your career with this essential training.

Skill Level

Beginner to Intermediate

About Pearson Video Training

Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Sams, and Que. Topics include IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more. Learn more about Pearson Video training at http://www.informit.com/video.

Sample Content

Table of Contents

Introduction
Lesson 1: BigQuery for Data Engineering and Machine Learning Engineering
1.1 Serverless, Multi-function Data Platform
1.2 Architecture of BigQuery
1.3 Data Engineering and Machine Learning in BigQuery
Lesson 2: Data Ingestion in BigQuery
2.1 Batch Data Ingestion
2.2 Lab Assignment: Batch Data Ingestion
2.3 Streaming Ingestion
2.4 Lab Assignment: Ingest Streaming Data
Lesson 3: Data Qualtiy and Data Exploration
3.1 SQL for Data Quality Checks
3.2 Lab Assignment: Data Quality Checks
3.3 DataFrames for Data Exploration
3.4 Lab Assignment: Data Exploration
3.5 Cloud Dataproc Spark and BigQuery
Lesson 4: Machine Learning with BigQuery
4.1 Introduction to Machine Learning
4.2 Machine Learning Workflow
Lesson 5: Building Classification and Regression Models in BigQuery
5.1 Building and Evaluating a Classification Model
5.2 Lab Assignment: Build a Classification Model
5.3 Building and Evaluating a Regression Model
5.4 Lab Assignment: Build a Regression Model
Lesson 6: Building a Time Series Predictive Model
6.1 Introduction to Time Series Modeling
6.2 Building Time Series Model in SQL
6.3 Lab Building a Time Series Model in SQL
Lesson 7: Using Generative AI with BigQuery
7.1 Generative AI Services in Google Cloud
7.2 Introduction to Generative AI in BigQuery
7.3 Lab Using Generative AI tools in BigQuery
7.4 Working with Text in BigQuery
Summary

Updates

Submit Errata