Project: Library Tracker
Explore a practical SQL project by analyzing data from a community library system. Learn to connect tables, count borrowings, identify active and inactive members, and track currently borrowed books. This lesson helps you apply filtering, JOINs, and aggregation to draw meaningful insights and manage real-world data effectively.
You’ve learned SQL essentials like filtering, joining, grouping, and summarizing data. Now it’s your turn to apply your skills to a real-world scenario: managing a small library system.
Library tracker
In this project, you’ll analyze data from a community library system using SQL. You’ll work with two related tables:
The members table
ID | Name | MembershipDate |
1 | Ayesha | 2022-05-10 |
2 | Bilal | 2023-01-15 |
3 | Clara | 2021-11-20 |
4 | David | 2022-09-05 |
5 | Emma | 2024-02-18 |
The borrowed_books table
MemberID | BookTitle | BorrowDate | ReturnDate |
1 | The Alchemist | 2024-04-01 | 2024-04-10 |
2 | Atomic Habits | 2024-04-03 | 2024-04-12 |
1 | 1984 | 2024-04-15 | NULL |
3 | Thinking, Fast & Slow | 2024-03-20 | 2024-03-30 |
4 | The Lean Startup | 2024-04-18 | 2024-04-28 |
2 | The Alchemist | 2024-05-01 | NULL |
Let’s explore ...