Skip to content

README.md

Latest commit

 

History

History
44 lines (33 loc) · 1.44 KB

README.md

File metadata and controls

44 lines (33 loc) · 1.44 KB
Raw

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.