Fundamentals of BigQuery

Google Cloud 2018    |    Intermediate
  • 10 videos | 1h 13m 22s
  • Includes Assessment
  • Earns a Badge
Likes 60 Likes 60
BigQuery is an essential tool for any data analyst using Google Cloud Platform. Explore BigQuery and examine several operations including multiple table queries, nested and repeated fields and building BigQueries.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 3m 48s
    During this video, you will learn how to define BigQuery and its use in GCP. FREE ACCESS
  • 6m 49s
    After completing this video, you will be able to recognize concepts in BigQuery datasets, tables, and views. FREE ACCESS
  • Locked
    3.  Writing Queries with BigQuery
    6m 36s
    After completing this video, you will be able to describe the process of executing SQL queries. FREE ACCESS
  • Locked
    4.  Big Query - Loading Data
    5m
    After completing this video, you will be able to describe how to load data into BigQuery. FREE ACCESS
  • Locked
    5.  Exporting with BigQuery
    7m 7s
    After completing this video, you will be able to describe how to export data into Google Cloud Platform BigQuery. FREE ACCESS
  • Locked
    6.  Using Nested and Repeated Fields
    7m 2s
    In this video, find out how to query nested and repeated fields. FREE ACCESS
  • Locked
    7.  Using Complex Queries
    8m 29s
    In this video, you will learn how to apply query plans and complex queries using BigQuery. FREE ACCESS
  • Locked
    8.  Multiple Table Queries
    6m 52s
    Upon completion of this video, you will be able to describe the process of querying with multiple tables. FREE ACCESS
  • Locked
    9.  Building BigQuery Queries
    8m 23s
    In this video, you will learn how to write query results, use cached queries, use parameterized queries, and save and share queries in BigQuery. FREE ACCESS
  • Locked
    10.  Exercise: BigQuery Concepts and Operations
    13m 16s
    After completing this video, you will be able to recognize the main concepts and operations behind BigQuery. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Queries in Snowflake: Getting Started with Performance Optimizations
Book Querying SQL Server: Run T-SQL Operations, Data Extraction, Data Manipulation, and Custom Queries to Deliver Simplified Analytics
Course Implementations with BigQuery for Big Data
Likes 40 Likes 40  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Dataflow Autoscaling Pipelines
Likes 33 Likes 33  
Course Getting Started with Python: Introduction
Likes 2989 Likes 2989  
Book Official Google Cloud Certified Professional Data Engineer Study Guide