Database Design and Management expanded significantly on foundational database concepts. This course covered relational databases, SQL, database management systems, object-relational mappers (ORMs), and NoSQL databases. It focused on analyzing, designing, creating, and querying databases, as well as building database-driven applications using DB Browser for SQLite.
One of the most impactful projects was designing a tutoring app. For this assignment, we interviewed a tutor to understand their needs for organizing tutoring sessions. The app allowed tutors to manage topics, schedules, and student attendance for multiple sessions. We started by creating an ER diagram and schema, implemented the database in SQLite, and eventually developed APIs to interact with the database.
This course helped me understand how to design and manage databases effectively. I gained hands-on experience in SQL, database schema design, and API development. The project-based learning approach enhanced my skills in requirements gathering, database modeling, and building real-world database-driven applications.