Skip to content

Sql bookstore practice challenge

Latest
Latest

Choose a tag to compare

View all tags
@Kamoyaka Kamoyaka released this 05 Sep 20:15
Sql
b2d26cb
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

🚀 Upskill Portfolio

Welcome to my personal upskilling portfolio!
This repository showcases the projects and skills I have developed while actively learning and practicing modern technical skills.

📌 About This Portfolio

This portfolio documents my continuous learning journey.
It contains practical projects that demonstrate my understanding of:

  • SQL & Database fundamentals
  • Problem-solving with real-world scenarios
  • Clean code practices
  • Progressive skill building (from basic to intermediate)

🛠️ Projects

1. SQL Bookstore Challenge

Status: Completed
Level: Beginner → Intermediate

A complete hands-on SQL practice project built around a Bookstore database.

What I practiced:

  • Creating tables and inserting data
  • Basic SELECT queries
  • Filtering with WHERE, AND, OR, LIKE
  • Sorting (ORDER BY) and limiting results
  • Aggregate functions (COUNT, SUM, AVG, MAX, MIN)
  • GROUP BY
  • Basic JOINs
  • UPDATE, DELETE, and INSERT

Database used: SQLite (tested on SQLPhone Android app)

📁 Folder: /sql-bookstore-challenge

2. (Add your next project here)

Status: In Progress / Completed
Description: ...

🧰 Tech Stack & Tools

  • SQL (SQLite)
  • SQLPhone (Android SQL practice app)
  • Git & GitHub
  • Markdown

(You can expand this list as you add more skills: Python, Excel, Power BI, HTML/CSS, etc.)

📂 Repository Structure

upskill-portfolio/
├── README.md
├── sql-bookstore-challenge/
│   ├── setup.sql
│   ├── level-1-select.sql
│   ├── level-2-where.sql
│   ├── level-3-order-by.sql
│   ├── level-4-aggregates.sql
│   ├── level-5-joins.sql
│   └── bonus.sql
└── (future projects...)
<img width="2400" height="1013" alt="output1" src="https://github.com/user-attachments/assets/672f6cf9-772d-408a-bc22-40f360f2f1a6" />
Assets 2
Loading