Build a Data Warehouse Using BigQuery

Build a Data Warehouse Using BigQuery

Instructors: Caio Avelino

Included with

Learn more

1 module

Gain insight into a topic and learn the fundamentals.

Advanced level

Recommended experience

6 hours to complete

Flexible schedule

Learn at your own pace

1 module

Gain insight into a topic and learn the fundamentals.

Advanced level

Recommended experience

6 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Create efficient data warehouses and tables using Google BigQuery's UI and SQL.
Build dynamic ETL pipelines with Python, incorporating partitioning and clustering strategies.
Perform advanced queries, including aggregate and window functions, for insightful data analysis.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

6 assignments¹

AI Graded see disclaimer

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There is 1 module in this course

This course provides a practical, hands-on introduction to Google BigQuery for building efficient data warehouses and performing advanced queries. You’ll learn how to set up and access BigQuery, create data warehouses using both the web interface and Python, and apply optimization techniques to manage and analyze large datasets in the cloud.

Designed for data analysts, data engineers, and business intelligence professionals, the course is also valuable for aspiring analysts seeking to strengthen SQL skills and gain experience with enterprise-scale data management. A basic understanding of SQL and core data concepts is recommended. By the end, you’ll be able to design scalable data warehouses, run complex queries, and extract actionable insights—enabling data-driven decision-making and improving business performance using the full capabilities of Google BigQuery.

Unlock the power of Google BigQuery as you embark on a journey to understand the basic data warehouse builder and query expert. In this comprehensive course, you'll learn to harness the capabilities of BigQuery, from setting up and accessing the platform to creating data warehouses using both UI and Python. Through hands-on lessons and practical applications, you'll develop the basic skills needed to manage, query, and optimize your data in this powerful cloud-based platform.

What's included

24 videos6 readings6 assignments

24 videos Total 112 minutes

Introduction to the Instructor 3 minutes
Introduction to BigQuery 2 minutes
Setting Up and Accessing BigQuery 3 minutes
Navigating the BigQuery UI 4 minutes
Exploring "BigQuery-Public-Data" Datasets 3 minutes
Introduction to Data Warehousing and BigQuery 4 minutes
Creating Datasets for Data Organization 5 minutes
Defining Tables with Schema and Settings 5 minutes
Partitioning and Clustering Strategies 5 minutes
Creating Tables Using SQL 7 minutes
Creating Partitioned Tables Using SQL 2 minutes
Installing Anaconda Package and Configuring Credentials 4 minutes
Introduction to Jupyter Notebook UI 3 minutes
Manipulating Data with Pandas: Replacing and Appending Tables 9 minutes
Adding Schema Information Dynamically 7 minutes
Incorporating Partitioning and Clustering Configurations 6 minutes
Understanding ETL (Extract, Transform, Load) 2 minutes
Performing ETL with CSV, Excel, and JSON files 13 minutes
Introduction to Data Query Language 2 minutes
Exploring SQL Examples for Data Retrieval 7 minutes
Leveraging Aggregate and Window Functions for Advanced Queries 6 minutes
User-Defined Functions (UDFs) for Custom Transformations 5 minutes
Data Security and Governance Best Practice 3 minutes
Conclusion 2 minutes

6 readings Total 55 minutes

Welcome to the Course: Course Overview 5 minutes
Additional Resources 10 minutes
Additional Resources 10 minutes
Additional resources 10 minutes
Additional resources 10 minutes
Additional resources 10 minutes

6 assignments Total 190 minutes

Understanding BigQuery platform 30 minutes
Data Warehouse Using UI Interface And SQL 30 minutes
Creating A Data Warehouse Using Python 30 minutes
ETL With Python From External Sources 30 minutes
Querying And Governance 30 minutes
Final Assessment 40 minutes

Instructors

Caio Avelino

Starweaver

9 Courses 8,060 learners

Offered by

Starweaver

Explore more from Data Analysis

Google Cloud
BigQuery Fundamentals for Teradata Professionals
Course
Google Cloud
BigQuery Fundamentals for Oracle Professionals
Course
Google Cloud
BigQuery Fundamentals for Redshift Professionals
Course
Google Cloud
BigQuery Fundamentals for Snowflake Professionals
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.