In this lab, you use BigQuery to troubleshoot common SQL errors, query the data-to-insights public dataset, use the Query Validator, and troubleshoot syntax and logical SQL errors.
Overview
Syllabus
- GSP408
- Overview
- Setup and requirements
- Task 1. Open BigQuery and Pin a project to the Resource tree
- Task 2. BigQuery Query editor
- Task 3. Find the total number of customers who went through checkout
- Task 4. List the cities with the most transactions with your ecommerce site
- Task 5. Find the total number of products in each product category
- Congratulations!
