Introduction to BigQuery

The Introduction to BigQuery training course initially provides high level overview of BigQuery. After establishing the foundation it delves into and provides exposure around loading data, exporting data and exploring data using BigQuery.

Course Summary

Purpose: 
Empower developers to use Google's BigQuery to explore and gain insights from large datasets
Audience: 
Developers who work with Big Data
Skill Level: 
Learning Style: 

Hands-on training is customized, instructor-led training with an in-depth presentation of a technology and its concepts, featuring such topics as Java, OOAD, and Open Source.

Hands On help
Duration: 
2 Days
Productivity Objectives: 
  • Distinguish between BigQuery and Hive.
  • Design Schemas and create datasets and tables.
  • Load data into BigQuery
  • Query large datasets
  • Export data

What You'll Learn

In the Introduction to BigQuery training course you’ll learn:

  • Why BigQuery?

    • What is BigQuery?

    • Background

    • BigQuery vs Hive

    • Use cases for Google BigQuery

    • Google BigQuery Fundamentals

    • Hands-on: Experience BigQuery



  • Importing Data into BigQuery

    • Schema Design

    • Creating datasets and tables

    • How to define ACLs for datasets?

    • Data Preparation and Transformation Aspect

    • Dealing with streaming data and bulk loading

    • Hands-on: Loading Data Into BigQuery



  • Exploring Data using BigQuery

    • Ways to query BigQuery
 *** Console
 *** CLI
 *** Service API

    • Query Syntax

    • Caching Details

    • Using table decorators and wildcard functions

    • Using Join and Group clauses

    • Hands-on: Exploring Data related exercises


  • Exploring Data from BigQuery

    • Control requirements for exporting data

    • Quota policies

    • Access control requirements for exporting data

    • Access quotas

    • Compression and DataFormats

    • Exporting data to Google Cloud Storage

    • Hands-on: Exporting Data from BigQuery related exercises


Free Pluralsight Licenses in May

We'll work with you to design a custom Introduction to BigQuery training course that meets your specific needs. 100% guaranteed. Schedule a class of 10+ students in May and you'll also get free Pluralsight licenses for a year!

Learn More

Chat with one of our Program Managers from our Boulder, Colorado office to discuss various training options.

DevelopIntelligence has been in the technical/software development learning and training industry for nearly 20 years. We’ve provided learning solutions to more than 48,000 engineers, across 220 organizations worldwide.

About Develop Intelligence
Di Clients
Need help finding the right learning solution?   Call us: 877-629-5631