Introduction to BigQuery

Start Free Preview

Buying via our links supports this free directory · Affiliate disclosure.
Course facts
  • Payment: Free Preview (Paid Upgrade)
  • Learning style: Self-paced, start anytime
  • Format: Text & Interactive
  • Video access: Streaming Only
  • Before you start: Data Manipulation in SQL
DataCamp details
  • Chapters: 4
Created byDataCamp
Available onDataCamp

Course Details
Learning Style

Start Anytime

Level

Intermediate

Study Mode

100% Online

Duration

Short (< 10 Hours)

Languages
Audio Language

English

Outcomes
Certificate

Certificate of Completion

Price & Terms
Pricing Model

Free Preview (Paid Upgrade)

Technical
Content Medium

Text & Interactive

Video Access

Streaming Only

Specification
Access

Subscription

SKU: introduction-bigquery Category: Tags: , , Brand:

Learn BigQuery’s architecture, load data, and write CTE, window function, join and DML queries in its SQL dialect, with interactive exercises.

At a glance
Duration4 hrs
LevelIntermediate
CertificateCertificate of Completion
LanguageEnglish
Taught byMatt Forrest
AccessSubscription
Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare

BigQuery is built to run large analytical queries, and its SQL dialect, table rules and data organization differ from those of a traditional SQL database. Working with an e-commerce dataset, you load local files, format dates and timestamps, build arrays and search unstructured data, then write queries with common table expressions, window functions and joins, and limit the amount of data a query works with to keep it efficient.

What You Will Achieve

  • Describe what sets BigQuery apart from a traditional SQL database and how it organizes data into tables
  • Load local files into BigQuery tables and format dates and timestamps for reports
  • Rank rows, compare neighboring values and filter window results in BigQuery SQL
  • Choose the right join type, change table data with DML statements and cut the data a query processes


Program Overview

BigQuery Architecture and Data Loading

Covers what sets BigQuery apart, how its components fit together and organize data, and how local files are loaded into tables.

  • Unique attributes compared with a traditional SQL database
  • Architecture components and data organization
  • Table structure and data rules
  • LOAD DATA statements and acceptable data formats

Data Types and Analytical Queries

Reviews core SQL inside BigQuery, then works through its date, time and array types, common table expressions, aggregate functions and window queries.

  • Date, time and timestamp types, including CURRENT_TIMESTAMP
  • Arrays, SEARCH and UNNEST with unstructured data
  • Common table expressions, COUNTIF, HAVING and special aggregations
  • Window functions with RANK, LEAD/LAG and QUALIFY

Joins, Data Manipulation, and Query Optimization

Covers every join type, changing table data with DML statements, and strategies for improving query performance.

  • RIGHT, LEFT, OUTER and CROSS joins with UNNEST
  • Joins combined with aggregations
  • DML statement types, conditions and considerations
  • Query optimization strategies and limiting data

Certificate Awarded (Paid)


Job Outlook

BigQuery skills are used in data analysis and data engineering work on cloud data warehouses, such as reporting on e-commerce orders, where large analytical queries run in SQL.


Our take

Good for: Analysts who already write SQL and want to apply it to BigQuery’s dialect, functions and table model through exercises on an e-commerce dataset.

Keep in mind: Data loading is taught with LOAD DATA statements on local files; most of the work is writing queries, joins and DML statements in BigQuery’s SQL dialect.

Bottom line: Its value lies in the BigQuery-specific SQL it drills, including QUALIFY, SEARCH, arrays, UNNEST and approximate statistical functions.

Frequently Asked Questions

Which BigQuery-specific functions appear in the lessons?

The aggregation lessons use COUNTIF, ANY_VALUE, logical aggregates, STRING_AGG, ARRAY_CONCAT_AGG and approximate statistical functions. Window queries are filtered with QUALIFY, and the data type lessons use SEARCH, UNNEST and CURRENT_TIMESTAMP.

Which e-commerce tasks appear in the exercises?

The exercises use an e-commerce dataset. Tasks include finding the total value of an order, formatting dates and timestamps for reports, and finding the orders placed in the last 90 days.

How does the course handle unstructured data?

One part of the data types chapter is given to unstructured data: you create an array inside a query, search it with SEARCH and flatten it with UNNEST. The joins chapter returns to UNNEST when pairing it with CROSS JOIN.

What does the query optimization part involve?

The final chapter presents query optimization strategies, with practice on limiting the amount of data a query uses and applying optimizations in BigQuery. An earlier lesson also shows how common table expressions can help optimize a query.

User Reviews

0.0 out of 5
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0

No reviews yet. Be the first to review this course.

There are no reviews yet.

Write your review

Reviews can only be posted by registered learners. Log in, then you will return here to post.

×

    Report this page
    LiveTalent
    Logo
    Compare items
    • Total (0)
    Compare
    0