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

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

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

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Build a Data Warehouse Using BigQuery · LearnSpace
Назад в каталог
courseraАнализ данных

Build a Data Warehouse Using BigQuery

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

О курсе

This course provides a practical, hands-on introduction to Google BigQuery for building scalable data warehouses using BigQuery and performing advanced cloud-based analytics. Learners will explore what is a data warehouse, how modern enterprise data warehouse systems operate, and how to efficiently manage large datasets using Google BigQuery. Through real-world exercises and guided demonstrations, participants will learn how to set up and access BigQuery, build a data warehouse with BigQuery using both the web interface and Python, and apply optimization techniques to improve query performance, scalability, and cost efficiency in cloud environments. Designed for data analysts, data engineers, and business intelligence professionals, this Data warehouse using BigQuery course is also valuable for aspiring analysts seeking to strengthen SQL expertise and gain practical experience with modern data warehouse architectures and enterprise-scale data management. Learners will develop hands-on skills in querying, transforming, and analyzing large datasets to support data-driven decision-making and business intelligence initiatives. A basic understanding of SQL and foundational data concepts is recommended. By the end of the course, participants will be able to design scalable data warehouse with BigQuery solutions, execute complex analytical queries, and extract actionable insights using the full capabilities of Google BigQuery.

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

Data WarehousingSQLData TransformationData PipelinesCloud ManagementData ArchitectureData ModelingCloud ComputingBusiness IntelligenceBusiness AnalyticsQuery LanguagesPerformance TuningPython ProgrammingScriptingData-Driven Decision-MakingData Management

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

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

01Build a Data Warehouse Using BigQuery36 материалов

Lesson 1: Understanding BigQuery Platform 

Welcome to the Course: Course OverviewЧтениеIntroduction to the InstructorВидеоIntroduction to BigQuery ВидеоSetting Up and Accessing BigQuery Видео

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

Caio Avelino

Data Science, Business Intelligence, Machine Learning

Starweaver

Global Leaders in Professional & Technology Education

Build a Data Warehouse Using BigQuery
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 5.9 ч

1 модулей

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

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

Часть программы вашего университета
Navigating the BigQuery UIВидео
Exploring "BigQuery-Public-Data" Datasets Видео
Additional ResourcesЧтение
Understanding BigQuery platformЗадание

Lesson 2: Creating A Data Warehouse Using UI Interface And SQL 

Introduction to Data Warehousing and BigQuery ВидеоCreating Datasets for Data Organization ВидеоDefining Tables with Schema and Settings ВидеоPartitioning and Clustering Strategies ВидеоCreating Tables Using SQL ВидеоCreating Partitioned Tables Using SQL ВидеоAdditional ResourcesЧтениеData Warehouse Using UI Interface And SQLЗадание

Lesson 3: Creating A Data Warehouse Using Python 

Installing Anaconda Package and Configuring Credentials ВидеоIntroduction to Jupyter Notebook UI ВидеоManipulating Data with Pandas: Replacing and Appending Tables ВидеоAdding Schema Information Dynamically ВидеоIncorporating Partitioning and Clustering Configurations ВидеоAdditional resourcesЧтениеCreating A Data Warehouse Using PythonЗадание

Lesson 4: ETL With Python From External Sources 

Understanding ETL (Extract, Transform, Load) ВидеоPerforming ETL with CSV, Excel, and JSON files ВидеоAdditional resourcesЧтениеETL With Python From External SourcesЗадание

Lesson 5: Querying And Governance 

Introduction to Data Query Language ВидеоExploring SQL Examples for Data Retrieval ВидеоLeveraging Aggregate and Window Functions for Advanced Queries ВидеоUser-Defined Functions (UDFs) for Custom Transformations ВидеоData Security and Governance Best PracticeВидеоAdditional resourcesЧтениеQuerying And GovernanceЗадание

Conclusion & Final Assessment

ConclusionВидеоFinal AssessmentЗадание