Coursera Plus Annual is 40% Off — Ends July 13.

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 Skills

Go to class Write review
CodeSignal Ad

Learn Generative AI, Prompt Engineering, and LLMs for Free

Learn More → DataCamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
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.