Introduction to Database Systems

Description

This course provided balanced coverage of database use and design, focusing on relational databases. I learned to design relational schemas, write SQL queries, access a database programmatically, and perform database administration. I gained a working knowledge of the algorithms and data structures used in query evaluation and transaction processing. I also learned to apply newer database technologies such as XML, NoSQL, and Hadoop.

Pharmacy Management System

Below is the Spring Boot driven web app I wrote, practicing database read, write, design, and management from this course.

  • Read the full write up here.

Database schema