Utilizing Databases Course

Overview

This course was designed to provide an introduction to databases and SQL using C# with the Entity Framework and MS SQL Server. The course is designed to be hands-on and interactive, with a focus on practical applications of database concepts. Note: This was my first time ever working with C# and Entity Framework, so I had to learn a lot of new things in a short amount of time. I am proud of the work I did in this course, but I know that my code can be optimized and improved alot.

Table of Contents

1. Course Structure
2. Projects
   • Library Management
   • Student Management
   • Car Dealership
   • Event Calendar
3. Resources
4. Tools and Technologies

Course Structure

The course is divided into four projects, each of which focuses on a different aspect of database design and implementation. Each project focuses on a different scenario and set of requirements.

Projects

Library Management

• Description: Manage a library system with books, loans, and users.
• Technologies: C#, Entity Framework, MS SQL Server.

Student Management

• Description: Manage a students and student groups.
• Technologies: C#, Entity Framework, MS SQL Server, Windows Forms.

Car Dealership

• Description: Manage a car dealership with cars, models, and brands.
• Technologies: C#, Entity Framework, MS SQL Server, WPF.

Event Calendar

• Description: Manage an event calendar with events, attendees, and locations.
• Technologies: C#, Entity Framework, MS SQL Server, ASP.NET, Blazor.

Resources I used

• C# Documentation
• Windows Forms Documentation
• WPF Documentation
• ASP.NET Documentation
• Blazor Documentation

Tools and Technologies

• Programming Languages: C#, SQL
• Frameworks: .NET, Entity Framework Core, Blazor
• Database: MS SQL Server
• IDE: Visual Studio Code, Visual Studio