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

Google via Google Cloud Skills Boost

Overview

Complete the intermediate Build a Data Warehouse with BigQuery skill badge to demonstrate skills in the following: joining data to create new tables, troubleshooting joins, appending data with unions, creating date-partitioned tables, and working with JSON, arrays, and structs in BigQuery. A skill badge is an exclusive digital badge issued by Google Cloud in recognition of your proficiency with Google Cloud products and services and tests your ability to apply your knowledge in an interactive hands-on environment. Complete the skill badge course, and final assessment challenge lab, to receive a digital badge that you can share with your network. For practice with BigQuery fundamentals (including working with the console and command line), complete the course titled BigQuery Basics for Data Analysts.

Syllabus

  • Build a Data Warehouse with BigQuery
    • Creating a Data Warehouse Through Joins and Unions
    • Creating Date-Partitioned Tables in BigQuery
    • Troubleshooting and Solving Data Join Pitfalls
    • Working with JSON, Arrays, and Structs in BigQuery
    • Build a Data Warehouse with BigQuery: Challenge Lab
  • Your Next Steps
    • Course Badge

Reviews

Start your review of Build and Optimize Data Warehouses with BigQuery

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.