- Data Analysts
- Data Engineers
- Cloud Engineers
- Business Intelligence Analysts
- Data Scientists
- Cloud Architects
What you'll learn
BigQuery Essentials
Introduction to big query, Understanding what it is meant for, writing your first query, etc.,
Under the hood
Knowing the internals helps you to write better queries and use it optimally
Cost Control
The different ways and practices you would follow to control your cost in BigQuery
Query Optimization
The best practices and methods to make your queries faster and better
Monitoring
To keep a tab on usage, logging and monitoring helps to understand where to improvise
Access control
Different levels of authorization and access control
The Plan
Day 1
- BigQuery basics and features
- How BigQuery stores data
- Exploring BQ console
- BQ architecture and Query execution stages
- Query external data source(s) within BQ
- Recover deleted data using Snapshots
- Run Scheduled Queries
- Transferring data from Amazon s3 without code
- Understanding how BQ Pricing works
- Methods for controlling cost
Day 2
- How to do access control in BigQuery
- How to create Authorized views and when to use
- How to work with Nested Fields
- BQ Partitioning and Clustering
- Logging and Monitoring
- Best practices for optimizing query performance