Coursera Plus Annual is 40% Off — Ends July 13.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

Troubleshooting Common SQL Errors with BigQuery

Google via Google Skills

Go to class Write review
Noble Desktop Ad

NY State-Licensed Certificates in Design, Coding & AI — Online

Learn More → TrainSec Ad

Master Windows Internals - Kernel Programming, Debugging & Architecture

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
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

Reviews

Start your review of Troubleshooting Common SQL Errors with BigQuery

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.