Google BigQuery Advanced

Learn via : Virtual Classroom / Online
Duration : 2 Days
  1. Home
  2. / /
  3. Google BigQuery Advanced

Description

BigQuery, the Google Cloud Platform technology, is a cloud computing service built on top of Dremel technology with its own unique architecture in 2008. Unlike its alternatives, BigQuery uses column-based storage and tree architecture. In this way, since the queries we write work in parallel, the processes that should take days and weeks are realized in seconds.

Google BigQuery offers many advantages for companies and data professionals who want to perform big data processing and analysis. It is preferred by many companies due to the fact that it is a suitable solution for both small-scale and large-scale projects.

The Google BigQuery Advanced tutorial is a training program that aims to explore Google Cloud’s BigQuery database service in depth. This course teaches the advanced features and use cases of BigQuery, and develops participants’ knowledge and skills in data analytics and big data processing.

Outline

  • Migrating Data to BigQuery
  • Subqueries: Scripts and Procedures
  • Using data manipulation language (DML)
  • Data Definition Language (DDL)
  • Legacy SQL
  • Partitioning, clustering, and retaining data
  • Use the Python agent, Pandas, and Jupyter to access data in BigQuery
  • Get to know all the advanced BigQuery UI functions
  • Create a connection between SQL and Google E-TabIoIar and BigQuery
  • Backing up data
  • Set up detailed performance monitoring of queries
  • Query Performance monitoring in BigQuery
  • BigQuery Cost tracking
  • Recover deleted data in BigQuery

Prerequisites

Attending Google BigQuery Fundamentals training