К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Achieving Advanced Insights with BigQuery · LearnSpace
Назад в каталог
courseraIT и технологии

Achieving Advanced Insights with BigQuery

Курс от Google Cloud
Начальный≈ 9.3 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

The third course in this course series is Achieving Advanced Insights with BigQuery. Here we will build on your growing knowledge of SQL as we dive into advanced functions and how to break apart a complex query into manageable steps. We will cover the internal architecture of BigQuery (column-based sharded storage) and advanced SQL topics like nested and repeated fields through the use of Arrays and Structs. Lastly we will dive into optimizing your queries for performance and how you can secure your data through authorized views. After completing this course, enroll in the Applying Machine Learning to your Data with Google Cloud course.

Навыки, которые вы освоите

SQLGoogle Cloud PlatformAuthorization (Computing)Data SharingData AccessDashboardPerformance TuningJupyterData SecurityData Visualization SoftwareScalabilityDatabase Architecture and AdministrationCollaborative SoftwareQuery LanguagesData AnalysisCloud Computing

Программа курса

7 модулей · 35 учебных материалов

01Module 10: Advanced Functions and Clauses8 материалов

Advanced Functions - Statistical and Approximations

Advanced Functions - Statistical and ApproximationsВидео

Advanced Functions - Analytic Functions and WITH Clause

Achieving Advanced Insights with BigQueryВидео

BigQuery User-Defined Functions (UDFs)

BigQuery User-Defined Functions (UDFs)Видео

Discuss Effective Sub-query and CTE design

Achieving Advanced Insights with BigQueryВидео

Lab: Deriving Insights from Advanced SQL Functions

Учитесь у экспертов

Google Cloud Training

Преподаватель курса

Achieving Advanced Insights with BigQuery
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 9.3 ч

7 модулей

Язык: Английский

Субтитры: Арабский, Французский, Бразильский португальский, Немецкий, Испанский

Часть программы вашего университета
Lab 9 OverviewВидео
Lab 9: Deriving Insights from Advanced SQL FunctionsВнешний инструмент
Lab 9 SolutionВидео

Module Quiz

Advanced FunctionsЗадание
02Module 11: Schema Design and Nested Data Structures10 материалов

Background: Traditional Relational Database Architecture

Background: Traditional Relational Database ArchitectureВидео

BigQuery Architecture

Denormalized, Column-Based StorageВидеоTable ShardingВидеоIntroducing Nested and Repeated FieldsВидео

BigQuery Nested and Repeated Fields

Working with Arrays and Structs in BigQueryВидеоBigQuery Standard SQL vs Legacy SQLВидеоPracticing SQL on Repeated Fields in BigQueryВидео

Lab: Practicing Working with Nested and Repeated Fields

Lab 10: Practice Querying Nested and Repeated FieldsВнешний инструментLab Solution WalkthroughВидео

Module Quiz

BigQuery ArchitectureЗадание
03Module 12: More Visualization with Google Data Studio3 материалов

Advanced Data Studio: Case Statements and Filters

Advanced Data Studio: Case Statements and FiltersВидео

Sharing Dashboards and Data Access Pitfalls

Sharing Dashboards and Data Access PitfallsВидео

Module Quiz

Advanced Google Data StudioЗадание
04Module 13: Optimizing for Performance7 материалов

Optimizing for Performance

Avoid BigQuery Performance PitfallsВидео

Data Skew in your Datasets

Data Skew in your DatasetsВидео

Diagnose Performance Issues with the Query Explanation map

Diagnose Performance Issues with the Query Explanation mapВидео

Lab: Optimizing and Troubleshooting Query Performance

Lab OverviewВидеоLab 11: Optimizing and Troubleshooting Query PerformanceВнешний инструментLab Solution WalkthroughВидео

Module Quiz

Performance OptimizationЗадание
05Module 14: Advanced Insights with Cloud Datalab4 материалов

Introducing Cloud Datalab

Introducing Cloud DatalabВидео

Demo: Cloud Datalab Notebook Cells

Demo: Cloud Datalab Notebook CellsВидео

Benefits of Cloud Datalab

Benefits of Cloud DatalabВидео

Module Quiz

Cloud DatalabЗадание
06Module 15: Data Access2 материалов

Data Access Roles, Creating Authorized Views, and Common Pitfalls

Data Access Roles, Creating Authorized Views, and Common PitfallsВидео

Module Quiz

Data AccessЗадание
07Completion1 материалов

Course Completion, Feedback, and Resources

End of Course RecapВидео