YoVDO

Troubleshooting Common SQL Errors with BigQuery

Offered By: Google via Google Cloud Skills Boost

Tags

BigQuery Courses Data Warehousing Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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.

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!

Tags

Related Courses

SAP Business Warehouse powered by SAP HANA
SAP Learning Relational Database Support for Data Warehouses
University of Colorado System via Coursera Data Warehouse Concepts, Design, and Data Integration
University of Colorado System via Coursera Business Intelligence Concepts, Tools, and Applications
University of Colorado System via Coursera Design and Build a Data Warehouse for Business Intelligence Implementation
University of Colorado System via Coursera