Data Warehousing with  BigQuery: Storage Design, Query Optimization, and Administration

• Describe BigQuery architecture fundamentals.
• Implement storage and schema design patterns to improve performance
• Use DML and schedule data transfers to ingest data.
• Apply best practices to improve read efficiency and optimize query performance.
• Manage capacity and automate workloads.
• Understand patterns versus anti-patterns to optimize queries and improve read performance.
• Use logging and monitoring tools to understand and optimize usage patterns.
• Apply security best practices to govern data and resources.
• Build and deploy several categories of machine learning models with BigQuery ML.

Big Data and Machine Learning Fundamentals