CH-BIGQUERYSKOfficial Google Curriculum
Cloud Hero BigQuery Skills
1 dayOn-DemandIntroductoryLoading...
Overview
This game equips you with hands-on experience crafting queries to unlock insights from BigQuery public datasets. Learn to export data, create Cloud SQL instances, and manage tables. Sharpen your skills by troubleshooting common SQL errors and writing effective queries to transform raw data into actionable intelligence.
What You'll Learn
- Craft queries to unlock insights from BigQuery public datasets
- Export data from BigQuery
- Create Cloud SQL instances
- Manage BigQuery tables
- Troubleshoot common SQL errors
- Write effective queries to transform raw data into actionable intelligence
Who Should Attend
Someone who is brand new to BigQuery
Prerequisites
This assumes little to no prior experience with SQL. Familiarity with Cloud Storage and Cloud Shell is recommended, but not required.
Products Covered
BigQueryCloud FirestoreCloud MemorystoreCloud SQLDatabase Migration ServiceGoogle Data StudioCloud BigtableCloud Dataproc
Course Modules
1
Introduction to SQL for BigQuery and Cloud SQL
Topics
- SQL fundamentals
- BigQuery query basics
- Cloud SQL instances
- Data export and management
Learning Outcomes
- Write basic SQL queries for BigQuery
- Create and manage Cloud SQL instances
- Export data from BigQuery
Activities
Lab: GSP281 - Introduction to SQL for BigQuery and Cloud SQL (75 mins)
2
BigQuery: Qwik Start - Console
Topics
- BigQuery Console interface
- Loading data into BigQuery
- Running queries in the console
Learning Outcomes
- Navigate the BigQuery Console
- Load data into BigQuery tables
- Execute queries using the Console interface
Activities
Lab: GSP072 - BigQuery: Qwik Start - Console (30 mins)
3
Exploring Your Ecommerce Dataset with SQL in Google BigQuery
Topics
- Ecommerce data analysis
- SQL query patterns for business intelligence
- Data exploration techniques
Learning Outcomes
- Analyze ecommerce datasets using SQL
- Write queries to extract business insights
- Explore datasets to identify trends and patterns
Activities
Lab: GSP407 - Exploring Your Ecommerce Dataset with SQL in Google BigQuery (30 mins)
4
Troubleshooting Common SQL Errors with BigQuery
Topics
- Common SQL error patterns
- Debugging SQL queries
- Query optimization techniques
Learning Outcomes
- Identify and fix common SQL errors
- Debug problematic queries
- Optimize SQL queries for better performance
Activities
Lab: GSP408 - Troubleshooting Common SQL Errors with BigQuery (50 mins)
Get This Training
No public classes currently scheduled. Express interest below or request private training.
Course Details
- Course Code
- CH-BIGQUERYSK
- Duration
- 1 day
- Format
- On-Demand
- Level
- Introductory
- Modules
- 4
- Activities
- 4
- Price
- Loading...
Questions About This Course?
Contact us for custom scheduling, group discounts, or curriculum customization.
Contact UsStarting fromLoading...