{"product_id":"data-warehousing-with-bigquery","title":"Data Warehousing with BigQuery","description":"\u003cdiv\u003e\u003cp\u003eIn 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.\u003cb\u003e \u003c\/b\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eData Warehousing with BigQuery Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cb\u003eIn this course, you will:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe BigQuery architecture fundamentals.\u003c\/li\u003e\n\u003cli\u003eImplement storage and schema design patterns to improve performance.\u003c\/li\u003e\n\u003cli\u003eUse DML and schedule data transfers to ingest data.\u003c\/li\u003e\n\u003cli\u003eApply best practices to improve read efficiency and optimize query performance.\u003c\/li\u003e\n\u003cli\u003eManage capacity and automate workloads.\u003c\/li\u003e\n\u003cli\u003eUnderstand patterns versus anti-patterns to optimize queries and improve read performance.\u003c\/li\u003e\n\u003cli\u003eUse logging and monitoring tools to understand and optimize usage patterns.\u003c\/li\u003e\n\u003cli\u003eApply security best practices to govern data and resources.\u003c\/li\u003e\n\u003cli\u003eBuild and deploy several categories of machine learning models with BigQuery ML.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cb\u003ePrerequisites\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003eFundamentals of Big Data and Machine Learning\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eData Warehousing with BigQuery Training Outling\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLearning Objectives\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eModule 1) BigQuery Architecture Fundamentals\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExplain the benefits of columnar storage.\u003c\/li\u003e\n\u003cli\u003eUnderstand how BigQuery processes data.\u003c\/li\u003e\n\u003cli\u003eExplore the basics of BigQuery’s shuffling service to improve query efficiency.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 2) Storage and Schema Optimization\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCompare the performance of different schemas (snowflake, denormalized, and nested and repeated fields).\u003c\/li\u003e\n\u003cli\u003ePartition and cluster data for better performance improve schema design using nested and repeated fields.\u003c\/li\u003e\n\u003cli\u003eDescribe additional best practices such as table and partition expiration.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 3) Ingesting Data\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIngest batch and streaming data.\u003c\/li\u003e\n\u003cli\u003eQuery external data sources.\u003c\/li\u003e\n\u003cli\u003eSchedule data transfers.\u003c\/li\u003e\n\u003cli\u003eUnderstand how to use Storage Write API.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 4) Changing Data\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWrite DML statements.\u003c\/li\u003e\n\u003cli\u003eAddress common DML performance problems and bottlenecks.\u003c\/li\u003e\n\u003cli\u003eIdentify slowly changing dimensions (SCD) in your data and make updates.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 5) Improving Read Performance\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExplore BigQuery’s cache.\u003c\/li\u003e\n\u003cli\u003eCreate materialized views.\u003c\/li\u003e\n\u003cli\u003eWork with BI Engine to accelerate your SQL queries.\u003c\/li\u003e\n\u003cli\u003eUse the Storage Read API for fast access to BigQuery-managed storage.\u003c\/li\u003e\n\u003cli\u003eExplain the caveats of using external data sources.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 6) Optimizing and Troubleshooting Queries\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eInterpret BigQuery execution details and the query plan.\u003c\/li\u003e\n\u003cli\u003eOptimize query performance by using suggested methods for SQL statements and clauses.\u003c\/li\u003e\n\u003cli\u003eDemonstrate best practices for functions in business use cases.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 7) Workload Management and Pricing\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDefine a BigQuery slot.\u003c\/li\u003e\n\u003cli\u003eExplain pricing models and pricing estimations (BigQuery UI, bq dry_run, jobs API).\u003c\/li\u003e\n\u003cli\u003eUnderstand slot reservations, commitments, and assignments.\u003c\/li\u003e\n\u003cli\u003eIdentify best practices to control costs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 8) Logging and Monitoring\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUse Cloud Monitoring to view BigQuery metrics.\u003c\/li\u003e\n\u003cli\u003eExplore the BigQuery admin panel.\u003c\/li\u003e\n\u003cli\u003eUse Cloud Audit logs.\u003c\/li\u003e\n\u003cli\u003eWork with INFORMATION_SCHEMA tables to get insights for your BigQuery entities.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 9) Security in BigQuery\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExplore data discovery using Data Catalog.\u003c\/li\u003e\n\u003cli\u003eDiscuss data governance using DLP API and Data Catalog.\u003c\/li\u003e\n\u003cli\u003eCreate IAM policies (e.g., authorized views) to secure resources.\u003c\/li\u003e\n\u003cli\u003eSecure data with classifications (e.g., row-level policies).\u003c\/li\u003e\n\u003cli\u003eUnderstand how BigQuery uses encryption.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 10) Automating Workloads\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSchedule queries.\u003c\/li\u003e\n\u003cli\u003eUse scripting and stored procedures to build custom transformations.\u003c\/li\u003e\n\u003cli\u003eDescribe how to integrate BigQuery workloads with other Google Cloud big data products.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 11) Mastering BigQuery ML Applications\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe some of the different applications of BigQuery ML.\u003c\/li\u003e\n\u003cli\u003eBuild and deploy several categories of machine learning models with BigQuery ML.\u003c\/li\u003e\n\u003cli\u003eUse AutoML Tables to solve high-value business problems.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267B94US \/ 2026-07-29T09:00:00 \/ Online","offer_id":47534211956955,"sku":"US-1473-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AB92US \/ 2026-10-21T09:00:00 \/ Herndon, VA","offer_id":48216587108571,"sku":"US-1473-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274B84US \/ 2027-04-21T09:00:00 \/ Herndon, VA","offer_id":48619714609371,"sku":"US-1473-IL","price":2228.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/data-warehousing-with-bigquery","provider":"Learning Tree International","version":"1.0","type":"link"}