BigQuery Fundamentals for Redshift Professionals

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.

• 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