BigQuery Courses and Certifications

BigQuery Fundamentals for Snowflake Professionals

Transition from Snowflake to BigQuery: Learn architecture, data modeling, security, ingestion, and optimization for efficient cloud data warehousing on Google's platform.

• Google Skills
• 16 hours
• On-Demand
• Paid Course

BigQuery Fundamentals for Oracle Professionals

Learn BigQuery essentials for Oracle pros: architecture, data modeling, security, ingestion, optimization, and SQL differences. Hands-on labs included for practical experience.

• Google Skills
• 16 hours
• On-Demand
• Paid Course

BigQuery: Qwik Start - Console

Learn to query public tables and load sample data into BigQuery using the Web UI. Practice creating datasets, loading data, and running queries on custom and public datasets.

• Google Skills
• On-Demand
• Free Online Course

Analyze BigQuery data in Connected Sheets: Challenge Lab

This challenge lab tests your skills and knowledge from the labs in the <b>Analyze BigQuery data in Connected Sheets<b> quest. You should be familiar with the content of labs before attempting this lab.

• Google Skills
• On-Demand
• Free Online Course

Using BigQuery Omni with AWS

In this lab, you will run BigQuery analytics on data stored in AWS S3 using BigQuery Omni.

• Google Skills
• 1 hour
• On-Demand
• Paid Course

Working with JSON, Arrays, and Structs in BigQuery

In this lab you will work with semi-structured data (ingesting JSON, Array data types) inside of BigQuery. You will practice loading, querying, troubleshooting, and unnesting various semi-structured datasets.

• Google Skills
• 1 hour
• On-Demand
• Paid Course

Exploring NCAA Data with BigQuery

Use BigQuery to explore the NCAA dataset of basketball games, teams, and players. The data covers plays from 2009 and scores from 1996. Watch <A HREF="https://youtu.be/xDZjcfMm-t8">How the NCAA is using Google Cloud to tap into decades of sports da…

• Google Skills
• On-Demand
• Free Online Course

Exploring Your Ecommerce Dataset with SQL in Google BigQuery

In this lab, you learn to use BigQuery to find data, query the data-to-insights public dataset, and write and execute queries.

• Google Skills
• On-Demand
• Free Online Course

BigQuery: Qwik Start - Command Line

Learn to query public tables and load data into BigQuery using the Command Line Interface. Practice examining tables, running queries, and creating new tables.

• Google Skills
• On-Demand
• Free Online Course

Ingesting New Datasets into BigQuery

This lab focuses on how to ingest new datasets into tables inside of BigQuery.

• Google Skills
• 1 hour
• On-Demand
• Paid Course

Troubleshooting Common SQL Errors with BigQuery

In this lab, you use BigQuery to troubleshoot common SQL errors, query the data-to-insights public dataset, use the Query Validator, and troubleshoot syntax and logical SQL errors.

• Google Skills
• On-Demand
• Free Online Course

Using BigQuery in the Google Cloud Console

This lab shows you how to query public tables and load sample data into BigQuery using the GCP Console. Watch the following short video <A HREF="https://youtu.be/m0rqccviLNM">Get Meaningful Insights with Google BigQuery</A>.

• Google Skills
• On-Demand
• Free Online Course

Build and Optimize Data Warehouses with BigQuery: Challenge Lab

This challenge labs tests your skills in building and optimizing your data warehouse using BigQuery.

• Google Skills
• 1 hour
• On-Demand
• Paid Course

Introduction to SQL for BigQuery and Cloud SQL

In this lab you will learn fundamental SQL clauses and will get hands on practice running structured queries on BigQuery and Cloud SQL.

• Google Skills
• 1 hour
• On-Demand
• Paid Course

Weather Data in BigQuery

In this lab you analyze historical weather observations using BigQuery and use weather data in conjunction with other datasets. This lab is part of a series of labs on processing scientific data.

• Google Skills
• On-Demand
• Free Online Course