Skip to content

This repository contains my SQL practice exercises solved on Kaggle, covering both standard SQL and Google BigQuery SQL.

Notifications You must be signed in to change notification settings

shivharebhupendra/SQL-BigQuery-practice-sets

Repository files navigation

🗄️ SQL Practice Sets (Kaggle – SQL & BigQuery)

📌 Overview

This repository contains my SQL practice exercises solved on Kaggle, covering both standard SQL and Google BigQuery SQL.

I already have prior exposure to SQL, and this repository is maintained for regular practice, revision, and strengthening query-writing skills using real-world style datasets and problems.


🎯 Purpose of This Repository

  • Practice SQL queries regularly to stay consistent
  • Improve query logic, optimization, and readability
  • Strengthen understanding of real-world datasets
  • Prepare for technical interviews, assessments, and case studies
  • Gain hands-on experience with BigQuery SQL dialect

🧠 Topics Covered

  • SELECT, WHERE, ORDER BY
  • Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
  • GROUP BY & HAVING
  • JOINs (INNER, LEFT, RIGHT)
  • Subqueries & Nested Queries
  • Common Table Expressions (CTEs)
  • Window Functions
  • Date & String Functions
  • Query Optimization Basics
  • BigQuery-specific SQL syntax

🚀 Source of Practice

All exercises are taken from Kaggle Learn – SQL Courses:

  • Intro to SQL
  • Advanced SQL
  • BigQuery Basics

Each file/notebook contains:

  • Kaggle problem context
  • My SQL solution queries
  • Clean and readable formatting

🛠️ Tools & Technologies

  • Query Language: SQL
  • Platform: Kaggle Learn
  • Database Engine: Google BigQuery
  • Editor: Kaggle Notebooks / VS Code

📈 Practice Progress

This repository is updated regularly to:

  • Maintain SQL consistency
  • Practice diverse query patterns
  • Improve performance and clarity

🤝 Contributions

This is a personal practice repository. Suggestions, optimizations, and alternative approaches are welcome.


📬 Connect With Me

👨‍💻 Author

Bhupendra Shivhare

Aspiring Data Scientist | Deep Learning Enthusiast

If you are practicing SQL or preparing for Data/Data Engineering roles, feel free to connect.

⭐ If you find this repository useful, consider giving it a star!


Happy Querying! 🚀

About

This repository contains my SQL practice exercises solved on Kaggle, covering both standard SQL and Google BigQuery SQL.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published