Kickstart BigQuery on GCP in a Day
- Created By raju2006
- Last Updated December 12th, 2023
- Overview
- Prerequisite
- Audiance
- Audiance
- Curriculum
Description:
"Kickstart Your BigQuery On GCP In A Day Training: Unlock Google's Powerful Data Warehouse. Dive into the world of BigQuery, Google's cutting-edge data warehouse service, built on the cloud platform following the SaaS model. Learn how to harness BigQuery's capability to store and rapidly query vast amounts of data, with even terabytes at your fingertips within seconds. In this comprehensive class, grasp the intricacies of BigQuery's architecture, and gain proficiency in its storage and query engine. Explore hands-on sessions using Qwiklabs to master BigQuery's practical applications."
Course Code/Duration:
BDT184 / 1 Day
Learning Objectives:
After completing this course, you'll:
- Gain insight into Google Cloud Platform and Data Warehousing.
- Understand BigQuery's architecture.
- Learn data management techniques in BigQuery.
- Grasp the nuances of query execution.
- Explore the possibilities of Machine Learning with BigQuery.
- Basic knowledge of relational databases and SQL is desired but not mandatory. Basic understanding of Google Cloud Platform is required.
- This course is designed for anyone interested to get started with using BigQuery on GCP – Software Developers, DBA, Architects.
- This course is designed for anyone interested to get started with using BigQuery on GCP – Software Developers, DBA, Architects.
Course Outline:
- Introduction to GCP and Data Warehousing
- Refresher on what is GCP
- What is Data Warehouse & Why is it used?
- BigQuery Architecture
- Understanding BigQuery Architecture
- Data Storage – sources and storage
- Query Processing Engine
- Lab: Hands-on Lab to get started with BigQuery
- Working with data in BigQuery
- Understand the different BigQuery data sources
- Working with Joins and Unions
- Understanding Table Partitioning
- Using semi-structured data like JSON, Geo-Spatial data
- Lab: Couple of labs on these topics
- Understanding Query Execution
- Understand BigQuery execution
- Tables & Views in BigQuery
- Understanding BigQuery pricing and costs
- Lab: Data Ingestion
- Machine Learning on BigQuery
- Performing machine learning with BigQuery
- Build Classification, Regression models using BigQuery
- Lab: Building models using BQML
Training material provided:
Yes (Digital format)
- Hands-on Lab: Students must create Qwiklabs account for performing hands-on labs.
The curriculum is empty
[INSERT_ELEMENTOR id="19900"]
