How Duolingo Plans to Reach 100M Users

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
DataCamp Ad

AI Engineer - Learn how to integrate AI into software applications

Learn More → Corporate Finance Institute Ad

Finance Certifications Goldman Sachs & Amazon Teams Trust

Learn More →

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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.