Skip to content

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

 
 
 

Contributors