|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/practical-google-bigquery-for-those-who-already-know-sql/
课程评论：没有评论
课程名称：实用Google BigQuery（针对已经掌握SQL的人员） 课程概述： 《实用Google BigQuery》课程专为数据科学家、数据工程师、商业智能专家和开发者设计，帮助他们深入了解BigQuery的工作原理及其独特功能。课程特别适合那些不愿意花费大量时间浏览文档、担心查询速度和成本、以及不想再学习JOIN类型的SQL的人员。通过本课程，您将学习如何充分利用这一强大的工具。 在整个课程中，您将： - 学习如何通过BigQuery访问Google Sheets。 - 理解BigQuery资源层级（数据集、表、视图）。 - 像专业人士一样使用SQL编辑器快捷键（包括隐藏的快捷键）。 - 理解BigQuery的附加功能，如Google转移。 - 学习如何通过Python客户端访问BigQuery。 - 了解BigQuery的底层工作机制，包括数据存储和查询执行方式。 - 学习BigQuery的定价机制，并如何优化查询成本。 - 创建具有所有高级选项的表，应用分区、聚类和保留策略。 - 设置监控每个查询成本的功能。 - 学习如何使用SYSTEM TIME恢复在BigQuery中删除的数据。 - 备份视图的SQL代码。 除了课程视频外，您还将获得代码片段、示例的SQL代码、备忘单和幻灯片。Google BigQuery正在颠覆数据分析的世界，本课程旨在提升任何敢于使用这一令人惊叹的产品的人的职业生涯！
Practical Google BigQuery for those who already know SQL ...is made for Data Scientists, Data Engineers, Business Intelligence specialist and Developers that:- don't know how BigQuery works and why it's such a game changer,- don't like spending hours browsing through documentation to do things right,- worry that their queries will be slow and expensive,- don't need yet another course that explains types of JOINs in SQL.If you fit the description, this course will help you understand deeply how BigQuery works, what are all its funky functionalities and how to make this powerful tool work for you.Over the entire course you will:learn how to access Google Sheets over BigQuery,understand BigQuery resources hierarchy - datasets, tables, views,make use of SQL editor shortcuts (also hidden ones!) like a pro,understand BigQuery additional functionalities like google transfers, learn how to access BigQuery from python client,understand how BigQuery works under the hood - how it stores data and performs queries, learn how BigQuery pricing works, and how to optimize query costs,create table with all advanced options - applying partitioning, clustering and retention policy,setup monitoring of costs of each query in BigQuery,learn how to recover deleted data in BigQuery using SYSTEM TIME,backup your view's SQL code.Except of the course videos you will get code snippets, SQL code of the examples, cheetsheets and slides.Google BigQuery is revolutionizing data analysis world right now and this course is made to boost career of anyone that dare to use this amazing product!
