In this video, we continue our BigQuery SQL tutorial series and focus on real-world data exploration using the wisdom_pets.products table.
You will practice SQL step by step and learn how to:
Explore tables using SELECT *
Sort data with ORDER BY (ASC, DESC, multi-level sorting)
Filter rows using the WHERE clause
Apply conditional logic with equal, not equal, less than, greater than
Use BETWEEN, IN, and NOT IN conditions
Perform fuzzy string matching using LIKE, wildcards (%), LIKE ANY
Handle case sensitivity with UPPER() and LOWER()
Use COUNT(*), COUNT(column), and COUNT(DISTINCT)
Work with aggregation functions such as MIN, MAX, AVG, ROUND, and STDDEV
Apply calculation formulas like wholesale price and discount amount
Analyze product pricing, ratings, discounts, and categories
At the end of the video, you will solve a hands-on SQL challenge, followed by a full walkthrough of the correct solution in BigQuery.
This tutorial is perfect for data analyst beginners, SQL learners, and anyone preparing for BigQuery interviews.
To follow along and practice, you can access all the SQL codes shown in this video using the link below:
https://github.com/shbnm93/Mentoring-Resources/blob/main/Big%20Query/BigQuery%20SQL%20Data%20Exploration
📌 Previous video: https://youtu.be/EBShnc1MaxA?si=zLdS8FpwObcpRADj
Don’t forget to like, subscribe, and practice along 🚀
