Database Management and Core Application Development

Overview

Coursera Plus Monthly Sale: All Certificates & Courses 40% Off!

Grab it

This course offers a comprehensive guide to database management and core application development using ASP.NET Core and Entity Framework. You'll learn to set up and manage databases, implement key design patterns, and build robust web applications. By the end of the course, you’ll have practical experience in database setup, migration handling, CRUD operations, and more. The course begins by introducing you to Entity Framework Core and database management, covering database setup, migrations, and data seeding. You'll explore Visual Studio and Visual Studio Code integration, understand connection strings, and learn how to work with migrations to update the database schema. Additionally, you’ll set up Microsoft SQL Server using Docker and explore best practices in managing EF Core databases. You will then dive into core application development by building modules such as Leave Type Management, where you’ll implement CRUD functionality, understand asynchronous programming, and work with dependency injection. You'll also learn how to scaffold views, implement user input validation, and manage the frontend design. This section will help you develop the full stack skills needed for web application development. Familiarity with basic web development concepts and C# is recommended. This course is perfect for developers looking to expand their knowledge of web development with ASP.NET Core and Entity Framework, particularly those with a foundation in C# and basic web development.

Syllabus

Database Setup (Entity Framework, Tables, and Migrations and Data Seeding)

In this module, we will introduce the process of setting up a database using Entity Framework Core in an ASP.NET Core project. You'll learn how to configure connection strings, create migrations, and seed data into the database, while also exploring best practices for managing database changes over time.

Leave Type Management Module

In this module, we will guide you through building a Leave Type Management system where you will create and manage leave types in an ASP.NET Core application. We will cover CRUD operations, advanced techniques like dependency injection and asynchronous programming, and how to refactor views using View Models for cleaner, more maintainable code.

Using View Models and Mappers

In this module, we will explore the concept of View Models and how they improve the separation of concerns in ASP.NET Core applications. You'll learn how to use AutoMapper to handle data mapping efficiently and refactor your views for enhanced data management and validation.

Implementing a Service Layer

In this module, we will introduce the Service Layer pattern and demonstrate how to implement it in an ASP.NET Core application. You'll learn how to refactor your code for better maintainability and organization, including testing the changes and committing them to GitHub.

User Authentication and Authorization

In this module, we will guide you through implementing user authentication and authorization in your ASP.NET Core application. You’ll learn how to manage users, roles, and secure pages using ASP.NET Core Identity while also customizing the registration and login processes.

Leave Allocation Module

In this module, we will explore how to build a Leave Allocation system in your ASP.NET Core application. You'll learn how to set up data models, manage relationships, and implement logic for allocating and managing leave for employees, with features for both employees and administrators to view and edit allocations.