Project: Library Tracker
Explore how to analyze library data by applying SQL techniques such as JOINs, COUNT aggregation, filtering, and handling NULLs. Learn to identify top borrowers, track checked-out books, and find inactive members, preparing you to handle real-world data scenarios with SQL.
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 library activity and generate insights using SQL.