YoVDO

Learning BigQuery

Offered By: LinkedIn Learning

Tags

BigQuery Courses Data Analysis Courses Data Visualization Courses Cloud Computing Courses SQL Courses Data Warehousing Courses Data Management Courses

Course Description

Overview

Get up and running with BigQuery, the powerful and easy-to-use data warehouse on the Google Cloud Platform.

Syllabus

Introduction
  • Introducing BigQuery
1. Introducing BigQuery
  • BigQuery services and compute process
  • The arrangement of data in BigQuery
  • Data sources and queries in BigQuery
  • The BigQuery cost structure
2. Creating and Working with Datasets and Tables
  • Configuring the GCP
  • Creating a BigQuery dataset
  • Defining a BigQuery table from the UI
  • Querying a simple BigQuery table
  • Uploading data to create a BigQuery table
  • Querying data and viewing statistics of queries
  • Reading JSON data into a BigQuery table
  • Creating a table from a query result
  • Creating a table from a filter
3. Executing Queries and Visualizing Results
  • Public datasets in BigQuery
  • Configuring and using BigQuery caches
  • External BigQuery tables
  • Integrating BigQuery with Data Studio
  • Geographic points in BigQuery
  • Visualizing geographical data with Geo Viz
4. Creating and Working with Views
  • Saving query results using views
  • Querying views vs. querying the original tables
  • Materialized views in BigQuery
  • Defining a restricted view of data
  • Granting a user project-level access
  • Setting up an authorized view
5. Using the bq Command-Line Tool
  • Configuring the bq shell
  • Executing queries from the BigQuery command-line
Conclusion
  • Summary and next steps

Taught by

Kishan Iyer

Related Courses

Serverless Data Analysis with Google BigQuery and Cloud Dataflow en Français
Google Cloud via Coursera
Google Cloud Big Data and Machine Learning Fundamentals en Español
Google Cloud via Coursera
Google Cloud Big Data and Machine Learning Fundamentals 日本語版
Google Cloud via Coursera
Industrial IoT on Google Cloud
Google Cloud via Coursera
Google Cloud Platform Big Data and Machine Learning Fundamentals em Português Brasileiro
Google Cloud via Coursera