|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/bigquery-for-data-analysts/
课程评论：没有评论
## Coursera 课程总结：Google Cloud - BigQuery for Data Analysts 本课程专为希望深入分析 BigQuery 中数据的分析师设计，尤其适合已具备 BigQuery 使用基础知识的学员。通过讲座、测验和实际作业，您将显著提升在 BigQuery 中的数据分析能力。 **课程亮点：** * **SQL 基础与进阶：** * 掌握数据定义语言（DDL），包括创建和修改表与视图。 * 复习数据操纵语言（DML），涵盖 SELECT、INSERT、UPDATE、DELETE 和 MERGE。 * 高效运用公用表表达式（CTEs）来模块化 SQL 代码，简化复杂逻辑。 * *（温馨提示：如果您已完成“Introduction to BigQuery”课程或熟悉 SELECT 语句，可跳过相关基础视频。）* * **BigQuery 特有数据类型处理：** * 学习 BigQuery 与传统关系型数据库（如 PostgreSQL, SQL Server）在数据处理上的差异。 * 深入掌握数组（Arrays）和结构体（Structures）的使用，包括查询、展开（unnesting）数组，以及处理嵌套结构体。 * **强大的 SQL 函数应用：** * 全面了解 BigQuery 中常用的 SQL 函数，加速数据分析效率，包括： * 数学与统计函数 * 聚合函数 * 数据类型转换函数 * 日期与时间函数 * 字符串函数 * 正则表达式函数 * 近似函数（适用于大数据集） * 分析函数与窗口函数 * **BigQuery 操作与管理：** * 掌握 BigQuery 安全性，包括访问控制、列安全和行级安全。 * 学习性能优化和成本管理技巧，确保高效且经济地使用 BigQuery。 **学习成果：** 完成本课程后，您将能够： * 熟练掌握 BigQuery 中的数据分析和转换技术。 * 理解如何通过 IAM、行级安全和列安全有效控制数据访问。 * 学会如何优化 BigQuery 操作的成本。 本课程通过 8 个作业和 10 个测验，帮助您巩固 BigQuery 的核心概念和实践技能，为成为一名出色的 BigQuery 数据分析师奠定坚实基础。
Analyze data in BigQuery using both basic SQL statements as well as specialized functions to help you gain insight into your data. If you need to analyze data in BigQuery and have some familiarity with using BigQuery, then this course will help you expand your skills with lectures, quizzes, and assignments. (If you are new to BigQuery, consider taking the Introduction to BigQuery course first.)The course begins with data definition language statements for creating and altering tables and views followed by a review of data manipulation statements, including SELECT, INSERT, UPDATE, DELETE, and MERGE. Learn how to use common table expressions (CTEs) effectively to modularize your SQL and make even complex logic easy to understand.Note: There are several basic videos reviewing SELECT statements which you can skip if you have taken Introduction to BigQuery or are comfortable writing SELECT statements.Working with BigQuery has some differences from working with relational databases like Postgres and SQL Server. We often use arrays and structures in BigQuery and this course will teach you how to work with arrays, querying and unnesting arrays, using array functions as well as working with structures and arrays of structures.SQL functions are foundational building blocks for data analytics work and it is important to know the functions available in BigQuery to rapidly and effectively analyze data. In this course, we will learn about a range of SQL functions for:Math and statisticsAggregate functionsData type castingDates and timesString manipulationRegular expressionsApproximate functions for working with large datasetsAnalytical and window functionsData analysts need to be familiar with BigQuery operations so the course also covers BigQuery security, including access controls, column security, and row-level security, as well as performance and cost management.Test your understanding of BigQuery concepts with 8 assignments and 10 quizzes.In this course, you will learn a wide range of topics that data analysts need to understand and you will know how to apply that knowledge effectively in BigQuery while working cost-effectively. After completing this course you will know a wide range of functions and techniques for analyzing and transforming data in BigQuery, understand how access to data is controlled using IAM, row-level, and column security, and how to control the cost of your BigQuery operations.
