In today's data driven world, how an organization manages its data directly impacts its success. Many institutions have moved away from traditional pen-and-paper record-keeping toward modern database solutions that secure information and uncover critical operational insights.
This weekend, I got to see this play out in real-time. Greenwood Academy, a model school in Nairobi, Kenya, decided to switch from ordinary bookkeeping to an operational database system to manage their data efficiently.
I was tasked with building a robust system to help them store, update, and query their records. For this project, I used a PostgreSQL database hosted on Aiven.
Here is a breakdown of the process:
1. Database Schema Design
The first step was designing a schema
2. Table Creation
Next, I created multiple structured tables—including a students table and an exam_results table—to ensure data integrity.
3. Data Ingestion
Once the architecture was ready, I populated the tables with realistic school records.
4. Solving Real-World Pain Points with SQL
Finally, I wrote and executed SQL queries to solve some of the major administrative pain points the school faced. Key questions answered included the following:
- How can the administration rank students based on their performance?
- How can they quickly track the total number of students enrolled per class?
Key Takeaway:
This project reinforced the importance of structured execution in product delivery. By breaking the building process down into 6 distinct steps, I was able to work faster, maintain deep focus on each component, and minimize errors.
Check out my GitHub repo here: https://github.com/Bethuel369/sql-week2-assignment-Bethuel-Ngetich
Top comments (0)