Fundamentals of BigQuery

Google Cloud    |    Intermediate
  • 10 videos | 1h 13m 22s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 50 users Rating 4.6 of 50 users (50)
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 Google Professional Cloud Architect: Google Cloud Database Design
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Channel Big Data Core Concepts
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, Second Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Implementations with BigQuery for Big Data
Rating 4.6 of 41 users Rating 4.6 of 41 users (41)
Course An Overview of Cloud Databases
Rating 4.5 of 147 users Rating 4.5 of 147 users (147)
Course Working with Google Cloud SQL: An Introduction to Cloud SQL
Rating 4.7 of 37 users Rating 4.7 of 37 users (37)