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

Données et services numériques, dans le nuage et ailleurs
Certificat informatique et internet via France Université Numerique
Introduction to Digital Curation
University College London via Independent
Excel Avanzado
Miríadax
SAP Business Warehouse powered by SAP HANA
SAP Learning
Programming Mobile Applications for Android Handheld Systems: Part 2
University of Maryland, College Park via Coursera