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

Save 43% on 1 Year of Coursera Plus

Learn More → CourseHorse Ad

Give the Gift That Unlocks Potential

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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.