← All courses
SQL
BigQuery
Build your data analytics skills with the latest no cost BigQuery trainings
4.5 (1161)4,761 learners27 lessons2h 11m
Curriculum
Topic
- How does bigquery separate storage and compute and why does this matter for sclaling4:04
- How does Dremel execution tree distribute a query across thousands of slots6:51
- How does capacitor columnar format store data differently from row-based storage7:08
- How does colossus distributed file system store and retrieve bigquery table data3:53
- How does bigquery slot allocation work and how do on-demand slots differ from reserved slots6:35
- How does bigquery clustering physically rearrange data blocks to speed up filtered queries3:17
- How does bigquery handle nested and repeated fields using STRUCT and ARRAY internally3:48
- How does bigquery time travel work and how does it store 7 days of historical snapshots6:16
- How does bigquery manage table snapshots and clones without duplicating storage4:49
- How does bigquery external tables read data from cloud storage without importing5:25
- How does bigquery handle schema evolution when you add or remove columns from a table5:43
- How does bigquery process a WHERE clause filter on a partitioned table with 10 billion rows3:28
- How BigQuery Handles Data Skew During Shuffle Operations When One Key Contains 90% of the Data6:25
- How BigQuery Query Cache Works and When It Serves Cached Results6:41
- How BigQuery Uses Column Pruning to Skip Unused Columns and Reduce Bytes Scanned3:10
- How BigQuery Uses Predicate Pushdown to Filter Data at the Storage Layer0:19
- How BigQuery Materialized Views Automatically Rewrite Queries for Faster Execution1:27
- How BigQuery BI Engine Uses In-Memory Caching to Accelerate Dashboard Queries2:36
- How to Read and Optimize a BigQuery Execution Plan Using EXPLAIN and Query Statistics2:19
- How BigQuery Processes a JOIN Between Two Large Tables Internally Step by Step4:20
- How BigQuery Decides to Use Broadcast Join for a Small Dimension Table4:49
- How BigQuery Handles Join Key Skew When One Customer Has Millions of Orders5:06
- How BigQuery Optimizes a LEFT JOIN with NULL Handling Across Distributed Slots4:04
- How BigQuery Executes RANK and ROW_NUMBER Over Billions of Rows Using PARTITION BY9:30
- How BigQuery Processes LAG and LEAD Functions Across Distributed Partitions4:58
- How BigQuery Calculates Running Totals Using SUM OVER with ORDER BY on Large Datasets7:04
- How BigQuery Processes a QUALIFY Clause and How It Differs from HAVING7:11