Fundamentals of Big Query


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
BigQuery is an essential tool for any data analyst using Google Cloud Platform. This course will focus on BigQuery and describe several operations including multiple table queries, nested and repeated fields and building BigQueries.

Target Audience
Data professionals who are responsible for provisioning and optimizing big data solutions, and data enthusiasts getting started with Google Cloud Platform

Prerequisites
None

Expected Duration (hours)
1.3

Lesson Objectives

Fundamentals of Big Query

  • start the course
  • Define BigQuery and its use in GCP
  • recognize concepts in BigQuery datasets, tables, and views
  • describe the process of executing queries
  • describe how to load data into BigQuery
  • describe how to export data into GCP BigQuery
  • define the process of querying nested and repeated fields
  • demonstrate query plans and complex queries using BigQuery
  • describe the process of querying with multiple tables
  • demonstrate how to write query results, use cached queries, use parameterized queries, and save and sharing queries in BigQuery
  • recognize the main concepts and operations behind BigQuery

    • Course Number:
    cl_gcde_a09_it_enus

    Expertise Level
    Intermediate