Musician Database

During my internship, I had the opportunity to create a remarkable project from scratch, even though I started with zero prior knowledge. The result was the Musician Database, a versatile and comprehensive web API project. This project serves a variety of purposes; helping venues discover talented artists, connecting bands with the perfect musicians, and offering an array of live music events for listeners to enjoy. The Musician Database was a valuable learning experience and allowed me to develop essential collaborative skills as I closely observed the professional software development team.

Technologies Used

In the development of the Musician Database project, I used a diverse set of cutting-edge technologies and tools. This web API project, powered with ASP.NET Core 6 and Entity Framework Core, was a useful project built for learning purposes. The database backend was powered by Microsoft SQL Server 2019, which's security can be managed using an authorization system. An authentication process is applied to a method to demonstrate the system.

• ASP.NET Core 6: Utilized to build the web API, providing a scalable and high-performance framework for the project.
• Entity Framework Core: Employed as the ORM (Object-Relational Mapping) tool for seamless database interactions.
• Visual Studio 2022: Used as the primary integrated development environment (IDE) to streamline coding and development tasks.
• Microsoft SQL Server 2019: Served as the backbone for data storage, ensuring data integrity and reliability.

This combination of technologies and tools along with mechanisms such as logging and caching allowed the Musician Database project to offer versatile RESTful endpoints; connecting various users within the live music scene while ensuring data security and scalability.

The project was used for educational purposes at Caretta while training a front-end development intern. You can try it out here. You can also check out its GitHub Repository.