Library SQL Query Project (MySQL)

📌 Project Overview

This project demonstrates SQL querying and reporting skills using a realistic library books dataset.

It focuses on:

• Extracting data using SELECT queries
• Filtering and sorting results
• Using DISTINCT and aliasing
• Creating reusable SQL views
• Simulating real-world reporting

---

🧱 Database Structure

Table

• books

---

⚙️ Features

✔ Structured table design
✔ Realistic dataset insertion
✔ DISTINCT & filtered queries
✔ Sorted and limited results
✔ SQL views for saved reports

---

📁 Project Structure

Library_SQL_Project/ │ ├── schema/ │ └── 01_create_books_table.sql │ ├── data/ │ └── 01_insert_books.sql │ └── analysis/ ├── 01_basic_queries.sql └── 02_create_views.sql

---

📊 Example Reports

• Unique book genres
• Top rated books
• Books by publication year
• Saved view of high-rated books

---

🛠 Technologies Used

• MySQL
• SQL Workbench

---

📈 Skills Demonstrated

• SQL querying
• Filtering & sorting
• Data extraction
• SQL views
• Reporting logic

---

Author

Tinyiko Patience Mathebula Junior SQL / MySQL Database Administration Portfolio GitHub: https://github.com/Tinyiko-Mathebula