Data Warehousing w/BigQuery: Storage Design; Query Optimization; Administration

Training Summary
In this course, you learn about the internals of BigQuery and best practices for designing, optimizing, and administering your data warehouse. Through a combination of lectures, demos, and labs, you learn about BigQuery architecture and how to design optimal storage and schemas for data ingestion and changes. Next, you learn techniques to improve read performance, optimize queries, manage workloads, and use logging and monitoring tools. You also learn about the different pricing models. Finally, you learn various methods to secure data, automate workloads, and build machine learning models with BigQuery ML.
Before attending this course, students should have completed Big Data and Machine Learning Fundamentals or have equivalent experience.
3 Days/Lecture & Lab
This class is designed for Data analysts, data scientists, data engineers, and developers who perform work on a scale that requires advanced BigQuery internals knowledge to optimize performance.
Course Topics
  • BigQuery Architecture Fundamentals
  • Storage and Schema Optimizations
  • Ingesting Data
  • Changing Data
  • Improving Read Performance
  • Optimizing and Troubleshooting Queries
  • Workload Management and Pricing
  • Logging and Monitoring
  • Security in BigQuery
  • Automating Workloads
  • Machine Learning in BigQuery

Related Scheduled Courses