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
Boot.dev Ad

The Most Addictive Python and SQL Courses

Learn More → DataCamp Ad

PowerBI Data Analyst - Create visualizations and dashboards from scratch

Learn More →

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
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.