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

Included withPremium or Teams

BigQueryData Engineering4 hours15 videos60 Exercises5,000 XP7,381Statement 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.

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

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

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

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

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

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 review

Included withPremium or Teams

Don’t just take our word for it

*4.8

from 142 reviews

82%

16%

1%

1%

0%

Sort by

Christos

1 day

Adam

4 days

johann

7 days

Richard

8 days

Great course overall. Without advanced SQL preparation, the analytical SQL functions would have been difficult to complete. It would be great to have a chapter that talks about how to manage a project in BigQuery Studio including saving queries, exporting query results, etc.

Jeleazar

9 days

Fernando

12 days

Christos

Adam

"Great course overall. Without advanced SQL preparation, the analytical SQL functions would have been difficult to complete. It would be great to have a chapter that talks about how to manage a project in BigQuery Studio including saving queries, exporting query results, etc."

Richard

Join over 17 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.