Skip to main content

Home Data Engineering

Course

Introduction to BigQuery

IntermediateSkill Level

4.8+

Updated 02/2025

Unlock BigQuery's power: grasp its fundamentals, execute queries, and optimize workflows for efficient data analysis.

Start Course for Free

BigQueryData Engineering4 hr15 videos60 Exercises5,000 XP11,640Statement of Accomplishment

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies

Training 2 or more people?

Try DataCamp for Business

Course Description

Delve into the core concepts of BigQuery architecture, understanding its historical significance and comparing it to traditional database systems. Uncover the diverse range of applications where BigQuery shines, setting the stage for a deeper exploration of its capabilities.

Mastering Analytical Queries and Data Manipulation

Learn to wield the power of BigQuery by executing analytical queries and manipulating data with precision. Navigate datasets and tables effortlessly while gaining proficiency in utilizing bq command line tools for data ingestion. Dive into the complexities of data types and unstructured data, honing your skills to extract meaningful insights.

Optimizing Workflow Efficiency and Query Performance

Elevate your data analysis workflow to new heights by mastering advanced techniques within BigQuery. From optimizing query performance through strategic optimization strategies to mastering the intricacies of joining data, this section equips you with the tools needed to streamline your analytical processes. Unlock the potential of Data Manipulation Language (DML) statements, empowering you to perform complex data transformations with ease.

Prerequisites

Data Manipulation in SQL

1

BigQuery Architecture and Structure

In this chapter, you will learn about the unique features of BigQuery, how it runs large analytical queries, and how it compares to other data warehouses and databases.

Introduction to BigQuery

Starting with e-commerce

Unique attributes of BigQuery

BigQuery compared to a traditional SQL database

BigQuery Architecture

Classifying BigQuery components

Ordering the BigQuery architecture

BigQuery data organization

Table structure

BigQuery data rules

Tables in the wild

2

Writing queries and data types

This chapter will cover the fundamentals of how to write queries in BigQuery while also providing a review of SQL concepts. You will also learn how to ingest bulk data into BigQuery and the different data types within BigQuery.

Writing queries in BigQuery

Exploring the course data with SQL

Finding order total value

Using joins

Data ingestion in BigQuery

Loading local data to BigQuery

Acceptable data formats

Structuring a LOAD DATA statement

Date/time types in BigQuery

Formatting dates for reports

Formatting timestamps and dates

Finding data within certain ranges

Using CURRENT_TIMESTAMP

Unstructured data

Create an array in a query

Use SEARCH with unstructured data

UNNEST-ing Data

3

Querying data in BigQuery

Learn how to query data using common table expressions, aggregations, and window functions.

Common table expressions

Filtering data with CTEs

Optimizing using CTEs

Using multiple CTEs

Aggregations

Classifying aggregate functions

Using COUNTIF

Filtering with HAVING

Special aggregations in BigQuery

Logical aggregates

Using STRING_AGG and ARRAY_CONCAT_AGG

Approximate statistical functions

WINDOW Functions

Writing a window query

RANK and LEAD/LAG

Using row based WINDOW functions

Filtering with QUALIFY

4

Data management and optimization

Understand all join types in BigQuery, mange data with data manipulation, and optimize your queries.

Joins in BigQuery

Finding the correct join type

RIGHT, LEFT, and OUTER joins

UNNEST with CROSS JOINs

Joins with aggregations

Data manipulation language (DML) statements

Data manipulation types

Using conditions in DML statements

Considerations using DML statements

Query optimization strategies

Limiting the amount of data

Finding the last 90 days of orders

Perform optimizations in BigQuery

Congratulations!

Introduction to BigQuery

Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance reviewEnroll Now

Don’t just take our word for it

*4.8

from 405 reviews

83%

16%

1%

0%

0%

Sort by

AR+I

17 hours ago

Luis Fernando

19 hours ago

Karla Fernanda

20 hours ago

Ruben

yesterday

Vania Aline

yesterday

Rene

yesterday

Luis Fernando

Karla Fernanda

Ruben

FAQs

What SQL background do I need before learning BigQuery?

You should have completed introductory and intermediate SQL courses, plus courses on data manipulation and joining data. The course builds on standard SQL skills within the BigQuery environment.

How does BigQuery differ from traditional databases?

The first chapter explains BigQuery's architecture, how it runs large analytical queries at scale, and how it compares to other data warehouses and relational databases.

Does this course cover window functions in BigQuery?

Yes. Chapter 3 teaches you to query data using common table expressions, aggregations, and window functions specific to BigQuery's SQL dialect.

Will I learn how to load bulk data into BigQuery?

Yes. The second chapter covers how to ingest bulk data into BigQuery tables and explains the different data types available within the platform.

What query optimization techniques are taught?

The final chapter covers all join types in BigQuery, data manipulation language for managing data, and optimization strategies to improve your query performance.

Join over 19 million learners and start Introduction to BigQuery today!

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Grow your data skills with DataCamp for Mobile

Make progress on the go with our mobile courses and daily 5-minute coding challenges.