Optimizing Google BigQuery with Query Design

1m 40s

Google BigQuery is one of the fastest data warehousing and analytics platforms available. However, its performance will heavily depend on the complexity of your queries. This lesson will teach you how to write the most efficient queries.

Learning Objectives

  • Write more efficient SQL queries
  • Cache your results in the most optimal way
  • Lower your BigQuery costs

Intended Audience

  • Database Administrators
  • Data Engineers
  • Data Analysts
  • Anyone preparing for a Google Cloud certification


  • Familiar with BigQuery
  • Comfortable with SQL syntax
  • Access to a GCP account
About the Author
Daniel Mease, opens in a new tab
Google Cloud Content Creator
Learning paths

Daniel began his career as a Software Engineer, focusing mostly on web and mobile development. After twenty years of dealing with insufficient training and fragmented documentation, he decided to use his extensive experience to help the next generation of engineers.

Daniel has spent his most recent years designing and running technical classes for both Amazon and Microsoft. Today at Cloud Academy, he is working on building out an extensive Google Cloud training library.

When he isn’t working or tinkering in his home lab, Daniel enjoys BBQing, target shooting, and watching classic movies.

Covered Topics