Performance and Cost Optimization with BigQuery

About this course

This is a self-paced lab that takes place in the Google Cloud console. Learn how to improve your database from a performance and cost perspective

What you will learn

• Create BigQuery tables and load data into it. Reduce the cost of a query by using partitioning.
• Optimize a query by using denormalization. Improve row filtering and join performance by using clustering.
• Improve dashboard loading speed and cost by using materialized view. Reduce the elapsed time and cost by pruning the partitions with filters.
• Save cost by moving data out of unused partitions in BigQuery and onto cheaper Google Cloud Storage.