首页 Data Engineering

课程

Introduction to BigQuery

中级技能水平

更新时间 2025年2月

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

免费开始课程

BigQueryData Engineering4 小时15 视频60 练习5,000 经验值11,595成就声明

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

深受数千家公司学习者的喜爱

培训2人或更多？

试用DataCamp for Business

课程描述

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.

先决条件

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

50 经验值

Starting with e-commerce

100 经验值

Unique attributes of BigQuery

50 经验值

BigQuery compared to a traditional SQL database

100 经验值

BigQuery Architecture

50 经验值

Classifying BigQuery components

100 经验值

Ordering the BigQuery architecture

100 经验值

BigQuery data organization

50 经验值

Table structure

100 经验值

BigQuery data rules

50 经验值

Tables in the wild

100 经验值

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

50 经验值

Exploring the course data with SQL

100 经验值

Finding order total value

100 经验值

Using joins

100 经验值

Data ingestion in BigQuery

50 经验值

Loading local data to BigQuery

50 经验值

Acceptable data formats

100 经验值

Structuring a LOAD DATA statement

100 经验值

Date/time types in BigQuery

50 经验值

Formatting dates for reports

100 经验值

Formatting timestamps and dates

100 经验值

Finding data within certain ranges

100 经验值

Using CURRENT_TIMESTAMP

100 经验值

Unstructured data

50 经验值

Create an array in a query

100 经验值

Use SEARCH with unstructured data

100 经验值

UNNEST-ing Data

100 经验值

3

Querying data in BigQuery

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

Common table expressions

50 经验值

Filtering data with CTEs

100 经验值

Optimizing using CTEs

100 经验值

Using multiple CTEs

100 经验值

Aggregations

50 经验值

Classifying aggregate functions

100 经验值

Using COUNTIF

100 经验值

Filtering with HAVING

100 经验值

100 经验值

Special aggregations in BigQuery

50 经验值

Logical aggregates

100 经验值

Using STRING_AGG and ARRAY_CONCAT_AGG

100 经验值

Approximate statistical functions

100 经验值

WINDOW Functions

50 经验值

Writing a window query

100 经验值

RANK and LEAD/LAG

100 经验值

Using row based WINDOW functions

100 经验值

Filtering with QUALIFY

100 经验值

4

Data management and optimization

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

Joins in BigQuery

50 经验值

Finding the correct join type

50 经验值

RIGHT, LEFT, and OUTER joins

100 经验值

UNNEST with CROSS JOINs

100 经验值

Joins with aggregations

100 经验值

Data manipulation language (DML) statements

50 经验值

Data manipulation types

50 经验值

Using conditions in DML statements

100 经验值

Considerations using DML statements

100 经验值

Query optimization strategies

50 经验值

Limiting the amount of data

100 经验值

Finding the last 90 days of orders

100 经验值

Perform optimizations in BigQuery

100 经验值

Congratulations!

50 经验值

Introduction to BigQuery

课程完成

获得成就证明

将此证书添加到你的 LinkedIn 档案、简历或履历中
在社交媒体和绩效评估中分享立即注册

加入超过19百万学习者，今天就开始Introduction to BigQuery！

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。