Monthly Subscription Starting at AED 99 + VAT

Achieving Advanced Insights with BigQuery
  • Level Foundation
  • Duration 8 hours
  • Course by Google Cloud
  • Offered by

About

The third course in this course series is Achieving Advanced Insights with BigQuery. Here we will build on your growing knowledge of SQL as we dive into advanced functions and how to break apart a complex query into manageable steps. We will cover the internal architecture of BigQuery (column-based sharded storage) and advanced SQL topics like nested and repeated fields through the use of Arrays and Structs. Lastly we will dive into optimizing your queries for performance and how you can secure your data through authorized views. After completing this course, enroll in the Applying Machine Learning to your Data with Google Cloud course.

Modules

Introduction

    • 1 Videos
Show info about module content

1 Videos

  • Course Introduction

Advanced BigQuery SQL Functions

    • 4 Videos
Show info about module content

4 Videos

  • Advanced functions (Statistical, analytic, user-defined)
  • Analytic Functions, WITH clause, and RANK()
  • BigQuery User-Defined Functions (UDFs)
  • Sub-query and CTE design

Lab: Deriving Insights from Advanced SQL Functions

    • 2 Videos
    • 1 ExternalTool
Show info about module content

1 External Tool

  • Deriving Insights from Advanced SQL Functions

2 Videos

  • Lab Intro: Deriving Insights from Advanced SQL Functions
  • Getting Started with Google Cloud Platform and Qwiklabs

Module Quiz

    • 1 Assignment
Show info about module content

1 Assignment

  • Advanced Functions

Background: Traditional Relational Database Architecture

    • 1 Videos
Show info about module content

1 Videos

  • BigQuery versus traditional relational data architecture

BigQuery Architecture

    • 3 Videos
Show info about module content

3 Videos

  • Denormalized, Column-Based Storage
  • Table Sharding
  • Introducing Nested and Repeated Fields

BigQuery Nested and Repeated Fields

    • 3 Videos
Show info about module content

3 Videos

  • Introducing arrays and structs
  • Flattening arrays: Legacy versus Standard
  • Module summary

Lab: Working with JSON, Arrays, and Structs in BigQuery

    • 1 ExternalTool
Show info about module content

1 External Tool

  • Working with JSON, Arrays, and Structs in BigQuery

Module Quiz

    • 1 Assignment
Show info about module content

1 Assignment

  • BigQuery Architecture

Optimizing for Performance

    • 3 Videos
Show info about module content

3 Videos

  • Avoid BigQuery Performance Pitfalls
  • Prevent hotspots in your data
  • Diagnose performance issues

Lab: Optimizing BigQuery for Cost and Performance

    • 1 Videos
    • 1 ExternalTool
Show info about module content

1 External Tool

  • Optimizing BigQuery for Cost and Performance

1 Videos

  • Lab Intro: Optimizing BigQuery for Cost and Performance

Module Quiz

    • 1 Assignment
Show info about module content

1 Assignment

  • Performance Optimization

Introducing Vertex AI Workbench

    • 1 Readings
    • 1 ExternalTool
Show info about module content

1 External Tool

  • BigQuery in JupyterLab on Vertex AI

1 Readings

  • A primer on Notebooks in the Cloud

Data Access

    • 1 Videos
Show info about module content

1 Videos

  • Data Access Roles, Creating Authorized Views, and Common Pitfalls

Module Quiz

    • 1 Assignment
Show info about module content

1 Assignment

  • Data Access

Course Summary

    • 1 Videos
Show info about module content

1 Videos

  • Course summary

Auto Summary

Achieving Advanced Insights with BigQuery is a foundational IT & Computer Science course offered by Coursera. Taught over 480 minutes, it delves into advanced SQL functions, BigQuery’s architecture, and optimization techniques. Ideal for learners aiming to deepen their SQL skills, it also covers data security via authorized views. Subscribers can access the course through a Starter plan.

Google Cloud Training
Instructor

Google Cloud Training