BigQuery Courses and Certifications

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 Cloud Skills Boost
• On-Demand
• Free Online Course

Analytics as a Service for Data Sharing Partners

In this lab you will learn how Authorized Views in BigQuery can be shared and consumed to create customer-specific dashboards.

• Google Cloud Skills Boost
• On-Demand
• Paid 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 Cloud Skills Boost
• 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 Cloud Skills Boost
• 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 Cloud Skills Boost
• 1 hour
• On-Demand
• Paid Course

Ingesting New Datasets into BigQuery

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

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

Cloud Composer: Copying BigQuery Tables Across Different Locations

In this advanced lab you will create and run an Apache Airflow workflow in Cloud Composer that exports tables from a BigQuery dataset located in Cloud Storage buckets in the US to buckets in Europe, then import th0se tables to a BigQuery dataset in Europ…

• Google Cloud Skills Boost
• 1-2 hours
• On-Demand
• Paid Course

Insights from Data with BigQuery: Challenge Lab

This challenge lab tests your skills and knowledge from the labs in the Insights from Data with BigQuery Quest. You should be familiar with the content of the labs before attempting this lab.

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

ETL Processing on Google Cloud Using Dataflow and BigQuery

In this lab you will build several Data Pipelines that will ingest data from a publicly available dataset into BigQuery.

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

Examining BigQuery Billing Data in Google Sheets

Harness BigQuery's power in Google Sheets to analyze and query data, organize spreadsheets, and schedule automatic refreshes for up-to-date insights.

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

Getting Started with BigQuery Machine Learning

In this lab you'll learn how to use BigQuery to create machine learning models for datasets to create a model that predicts whether a visitor will make a transaction.

• Google Cloud Skills Boost
• On-Demand
• Free Online Course

Creating a Data Warehouse Through Joins and Unions

This lab focuses on how to create new reporting tables using SQL JOINS and UNIONs.

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

Creating New BigQuery Datasets and Visualizing Insights

This is the second course in the Data to Insights course series. Here we will cover how to ingest new external datasets into BigQuery and visualize them with Looker Studio.

• Pluralsight
• 57 minutes
• On-Demand
• Free Trial Available

Exploring the Public Cryptocurrency Datasets Available in BigQuery

In this hands-on lab you’ll learn how to use BigQuery to explore the cryptocurrency public datasets now available. This is a challange lab, and you are required to complete some simple SQL statements.

• Google Cloud Skills Boost
• On-Demand
• Paid Course

Offloading Financial Mainframe Data into BigQuery and Elastic Search

In this hands-on lab, you will import synthetic data* representing financial records offloaded from a bank’s mainframe.

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