Welcome to my SQL journey repository

SQL Practice and Exercises

This repository documents my learning and practice of SQL using MySQL in Jupyter Notebook.
It includes topic-based exercises and a small database project to strengthen SQL query writing and database design skills.

---

Contents

1. Select Statement Practice

File: Select_Statement.ipynb

• Covers SQL fundamentals using the world database.
• Focus areas:
  • SELECT queries
  • WHERE and BETWEEN filters
  • IN and LIKE conditions
  • Logical operations (AND, OR, XOR)
• Each query includes clear examples with executed outputs for better understanding.

---

2. Exercise 1 – The Computer Store

File: The Computer Store.ipynb

• A complete database exercise adapted from
  Wikibooks – SQL Exercises: The Computer Store.
• Demonstrates:
  • Creating a relational database and tables
  • Defining primary and foreign keys
  • Inserting, updating, and deleting records
  • Writing queries for joins, filters, and aggregations
• Serves as a small real-world project to apply SQL concepts.

---

Tools Used

• MySQL - Database creation and queries
• Jupyter Notebook - For interactive SQL execution and documentation

---

Goal

To practice and document SQL concepts through simple exercises and real-world database examples, while continuously tracking my progress.