Black Friday 2024: 25+ Ways to Save on Online Learning

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

Build and Optimize Data Warehouses with BigQuery: Challenge Lab

Google via Google Cloud Skills Boost

Go to class Write review

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Grab it
This challenge labs tests your skills in building and optimizing your data warehouse using BigQuery.

Syllabus

  • GSP340
  • Overview
  • Challenge scenario
  • Task 1. Create a table partitioned by date
  • Task 2. Add new columns to your table
  • Task 3. Add country population data to the population column
  • Task 4. Add country area data to the country_area column
  • Task 5. Populate the mobility record data
  • Task 6. Query missing data in population & country_area columns
  • Tips and tricks
  • Congratulations!

Tags

Reviews

Start your review of Build and Optimize Data Warehouses with BigQuery: Challenge Lab

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.