Data Warehousing with BigQuery
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. Data Warehousing with BigQuery Benefits In this course, you will: 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 an