BigQuery on GC Training Overview
BigQuery is a data warehouse service that Google developed using the Software as a Service (SaaS) principle on their cloud platform. In this accelerated BigQuery on Google Cloud training course, attendees learn BigQuery's architecture and discover how it can store and query data.
Location and Pricing
This course is taught as a private, live online class for teams of 3 or more. All our courses are hands-on, instructor-led, and tailored to fit your group’s goals and needs. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for online corporate training, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Understand Google Cloud and data warehousing
- Understand BigQuery architecture
- Work with data in BigQuery
- Perform query execution
- Perform machine learning with BigQuery
Prerequisites
All students must have a basic understanding of Google Cloud. Basic knowledge of relational databases and SQL is desired but not mandatory.
Outline
Expand All | Collapse All
Introduction to Google Cloud (GC) and Data Warehousing
- Refresher on what GC is
- What is Data Warehouse & Why is it used?
BigQuery Architecture
- Understanding BigQuery architecture
- Data storage – sources and storage
- Query processing engine
- 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 (JSON and geo-spatial data)
Understanding Query Execution
- Understand BigQuery execution
- Tables and views in BigQuery
- Understanding BigQuery pricing and costs
- Data ingestion
Machine Learning on BigQuery
- Performing machine learning with BigQuery
- Build classification, regression models using BigQuery
- Building models using BQML
Conclusion
Training Materials
All Google Cloud training students receive comprehensive courseware.
Software Requirements
Students must have a modern web browser (ideally Chrome) and Internet access.
