How Duolingo Plans to Reach 100M Users

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

Google Cloud

BigQuery Fundamentals for Redshift Professionals

Google Cloud via edX

Go to class Write review

Overview

MIT Sloan: Drive Business Value with AI
6-week cohort with live MIT Faculty sessions. Learn to scale AI beyond the pilot stage.
Build Your AI Strategy

Move from SQL-based cloud data warehouses in Redshift to BigQuery with BigQuery Fundamentals for Redshift Professionals, developed by Google Cloud and delivered on edX.

This course features interactive lecture content and hands-on labs that teach you how to provision resources, create and share data assets, ingest data, and optimize query performance in BigQuery. Drawing on your knowledge of Redshift, you’ll also learn about the similarities and differences between Redshift and BigQuery to get started with data warehouses in BigQuery.

After completing this course, you’ll be able to complete the skill badge quest titled Build and Optimize Data Warehouses with BigQuery to continue your BigQuery journey.

Syllabus

  • Describe BigQuery’s architecture, resource provisioning, and data definition model
  • Create, secure, and share BigQuery data assets using best practices
  • Implement common patterns and best practices for designing schemas and ingesting data in BigQuery
  • Use best practices to optimize query performance and control costs in BigQuery
  • Compare and contrast the differences and commonalities between Redshift and BigQuery

Reviews

Start your review of BigQuery Fundamentals for Redshift Professionals

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.