Google Bigquery - From Basics To Advanced With Case Studies
Published 7/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.63 GB | Duration: 7h 41m
Published 7/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.63 GB | Duration: 7h 41m
Master Google BigQuery with lot of examples and real-world case studies
What you'll learn
Understand the fundamentals of Google BigQuery, including architecture, storage, and pricing
Load and manage data efficiently using various methods such as Cloud Storage, SDK, Console and streaming inserts.
Apply advanced concepts like partitioning, clustering, and working with arrays
Implement a complete end-to-end case study to simulate a real-world data analytics pipeline using BigQuery.
Requirements
Basic understanding of SQL is helpful, but not mandatory.
Description
Unlock the power of Google BigQuery in this comprehensive course designed for beginners and data professionals alike. Whether you're new to cloud data warehousing or want to master advanced techniques, this course guides you through every critical aspect of BigQuery — from the fundamentals to real-world case studies.We begin by introducing BigQuery and its key features, followed by hands-on sessions where you'll learn how to create tables using different methods, work with external vs native tables, and optimize your storage using partitioning and clustering.You’ll also gain deep practical experience working with complex data types like JSON and ARRAY, building logical, materialized, and authorized views, and exploring how BigQuery handles various data processing scenarios.To reinforce your learning, we’ll walk through real-world case studies, including a Spotify analytics project and a Social Media case study assignment, so you can confidently apply your knowledge in real data scenarios.What you'll cover in this section:Introduction to BigQuery and how it fits into Google CloudMethods for creating and managing tables (Native vs External)Storage optimization techniques: Partitioning & ClusteringHandling nested and repeated fields like JSON and ARRAYCreating and using views: logical, materialized, and authorizedSpotify case study: building insights from real songs dataHands-on assignment: analyze and report on social media engagementBy the end of this section, you’ll not only understand the theory but will also have hands-on experience building real data pipelines and analytics projects using BigQuery.
Overview
Section 1: Notes and Datasets
Lecture 1 Running Notes PDF
Lecture 2 Sample Datasets
Section 2: Lets get into to BigQuery
Lecture 3 BigQuery Introduction
Lecture 4 Various Methods of Creating Tables in BigQuery - Table Types (Native & External)
Lecture 5 Storage Optimization Techniques - Partitioning & Clustering with examples
Lecture 6 Working with Complex data in BigQuery with examples - JSON/ARRAY
Lecture 7 Spotify Case Study - session_1
Lecture 8 Spotify Case Study - session_2
Lecture 9 Views - Logical Views, Materialized Views and Authorized Views with Examples
Lecture 10 Assignment - Social Media Case study
Beginners and Professionals who want to learn BigQuery from scratch.