GC Partner no outline H
7878  Reviews star_rate star_rate star_rate star_rate star_half

Running Your First Data Warehouse Workload with BigQuery

Seating is Limited -- Act Now to Secure your Seat! The Microlearning program begins with a 3.5 hour instructor-led course delivery, followed by three Tech Advisory (2 hour) sessions in the weeks...

Read More
Free
Course Code GCP-DWBQ
Duration 30 days
Available Formats Classroom

Seating is Limited -- Act Now to Secure your Seat!

The Microlearning program begins with a 3.5 hour instructor-led course delivery, followed by three Tech Advisory (2 hour) sessions in the weeks following the first event - and includes 30 days access to Google Cloud Skills Boost. Training class schedule is as follows:

Instructor-led Training session (3.5 hours)
- October 30, 1:00-4:30pm EDT

Tech Advisory Session 1
- November 13, 1:00-3:00pm EDT

Tech Advisory Session 2
- November 20, 1:00-3:00pm EDT

Tech Advisory Session 3
- November 27, 1:00-3:00pm EDT

This 30-day training experience starts with an instructor-led microlearning session and then makes use of the dynamic Google Cloud Skills Boost (GCSB) platform, where attendees will get unlimited access to perform hands-on lab exercises within a Google Cloud environment for 30 days - along with authorized Google Cloud skill building reference materials and collateral.

To get you up and running quickly on Google Cloud, it is imperative that you get hands-on experience immediately and that's where this program will focus its efforts. This workshop session will equip attendees with a) an understanding of the purpose and use of BigQuery and b) an overview of the options for loading data into BigQuery.

The program assumes that attendees have already heard the benefits of moving data and analysis to the Cloud and aims to get them launching their first data warehouse workload with BigQuery as a way of learning about the available options. In the weeks following the class, there will be two Tech Advisory sessions scheduled where students can ask follow-up questions and receive targeted advisory.

Prerequisites

  • 1 year experience in data manipulation/management
  • Familiarity with relational databases and SQL
  • Familiarity with Cloud concepts

Course Details

Course Outline

  • Quick intro to BigQuery
  • Describe the essentials of BigQuery as a data warehouse
  • Demo: Getting started with BigQuery
  • Explore the different options for loading data into BigQuery
  • Batch vs Streaming
  • ETL vs ELT
  • Lab - Google Cloud Skills Boost: BigQuery Soccer Data Ingestion
  • Demo: Building Batch Pipelines to Load BigQuery
  • Next Steps: Making use of the Cloud Data Warehouse
  • Google Cloud Skills Boost Quest: Predict Soccer Match Outcomes with BigQuery ML
  • Google Cloud Skills Boost Quest: BigQuery for Marketing Analysts
  • Next Steps: More complex data loading
  • Google Cloud Skills Boost Quest: Engineer Data in Google Cloud
  • Q&A