|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-bigquery-from-basics-to-advanced-with-case-studies/
课程评论：没有评论
**课程名称：** Google BigQuery - 从基础到高级（含案例研究） **课程概述：** 本课程旨在帮助初学者和数据专业人士全面掌握 Google BigQuery 的强大功能。无论您是首次接触云数据仓库，还是希望精通高级技术，本课程都将引导您了解 BigQuery 的每一个关键方面，从基础知识到实际案例研究。 课程内容涵盖： * **BigQuery 介绍：** 了解 BigQuery 及其在 Google Cloud 中的定位。 * **表格管理：** 学习创建和管理表格的不同方法（原生表格与外部表格）。 * **存储优化：** 掌握分区（Partitioning）和集群（Clustering）等存储优化技术。 * **复杂数据类型：** 深入学习处理 JSON 和 ARRAY 等嵌套和重复字段。 * **视图应用：** 构建和使用逻辑视图（Logical Views）、物化视图（Materialized Views）和授权视图（Authorized Views）。 * **实际案例研究：** * **Spotify 分析项目：** 从真实歌曲数据中挖掘洞察。 * **社交媒体分析练习：** 分析和报告社交媒体互动情况。 通过本课程，您将不仅理解理论知识，更能获得实际操作经验，能够运用 BigQuery 构建数据管道和分析项目。
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.
