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

Google

BigQuery Fundamentals for Redshift Professionals

Google via Google Cloud Skills Boost

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
This course covers BigQuery fundamentals for professionals who are familiar with SQL-based cloud data warehouses in Redshift and want to begin working in BigQuery. Through interactive lecture content and hands-on labs, you learn how to provision resources, create and share data assets, ingest data, and optimize query performance in BigQuery. Drawing upon your knowledge of Redshift, you also learn about similarities and differences between Redshift and BigQuery to help you get started with data warehouses in BigQuery. After this course, you can continue your BigQuery journey by completing the skill badge quest titled Build and Optimize Data Warehouses with BigQuery.

Syllabus

  • BigQuery Architecture and Resource Provisioning
    • BigQuery Architecture and Resource Provisioning
    • Module 1 Quiz
    • Monitoring BigQuery Workloads
  • BigQuery Data Definition Model
    • BigQuery Data Definition Model
    • Module 2 Quiz
  • BigQuery and Google Cloud IAM
    • BigQuery and Google Cloud IAM
    • Module 3 Quiz
    • Securing and Sharing BigQuery Datasets and Tables
  • BigQuery Data Ingestion
    • BigQuery Data Ingestion
    • Module 4 Quiz
  • BigQuery Schema Design and Optimization
    • BigQuery Schema Design and Optimization
    • Module 5 Quiz
    • Designing BigQuery Table Schemas for Redshift Professionals
  • SQL in BigQuery
    • SQL in BigQuery
    • Module 6 Quiz
    • Working with SQL in BigQuery for Redshift Professionals
  • Course Resources
    • Course Resources
  • Your Next Steps
    • Course Badge

Reviews

Start your review of BigQuery Fundamentals for Redshift Professionals

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.