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
Coursera Ad

Google Data Analytics, IBM AI & Meta Marketing — All in One Subscription

Learn More → Corporate Finance Institute Ad

Learn Excel & Financial Modeling the Way Finance Teams Actually Use Them

Learn More →

Overview

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.