Database Management and Core Application Development

Heat up your career this summer with courses from Google, IBM, and more for £190/year. Save now.

Database Management and Core Application Development

This course is part of Complete ASP.NET Core and Entity Framework Development Specialization

Instructor: Packt - Course Instructors

Included with Coursera Plus

Learn more

6 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

14 hours to complete

3 weeks at 4 hours a week

Flexible schedule

Learn at your own pace

6 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

14 hours to complete

3 weeks at 4 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Learn how to set up and manage databases in ASP.NET Core using Entity Framework Core
Implement CRUD operations using scaffolding and View Models for efficient data management
Understand user authentication and authorization, and integrate ASP.NET Core Identity into your application
Develop a Leave Allocation module with database relationships, service layers, and employee allocation logic

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Complete ASP.NET Core and Entity Framework Development Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 6 modules in this course

Updated in May 2025.

This course now features Coursera Coach! A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. 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.

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.

What's included

11 videos2 readings1 assignment1 plugin

11 videosTotal 53 minutes

Section Overview0 minutesPreview module
What is Entity Framework Core?5 minutes
Review EF Core in Project (Visual Studio and Visual Studio Code)5 minutes
Review Database Context Class4 minutes
Understanding Connection Strings8 minutes
What are Migrations?2 minutes
Adding a Migration3 minutes
Create Database from Migration6 minutes
Resource: Setup Microsoft SQL Server with Docker9 minutes
Best Practices and Recommendations4 minutes
Section Review1 minute

2 readingsTotal 20 minutes

Introduction to the Course 'Database Management and Core Application Development'10 minutes
Full Specialization Resources10 minutes

1 assignmentTotal 15 minutes

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

1 pluginTotal 15 minutes

Introduction to EF Core and Migrations15 minutes

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.

What's included

16 videos1 assignment1 plugin

16 videosTotal 104 minutes

Section Overview1 minutePreview module
Module Overview and Requirements1 minute
Create Leave Type Table (Model, Migration, and Database Update)14 minutes
Explore Scaffolding and Functionality6 minutes
Review Scaffolded Index View and Action11 minutes
Understanding Dependency Injection3 minutes
Understanding Asynchronous Programming4 minutes
Review Scaffolded Create View and Action9 minutes
Understanding Form Bindings and Controls5 minutes
Review Scaffolded Details View and Action6 minutes
Review Scaffolded Edit View and Action8 minutes
Review Scaffolded Delete View and Action6 minutes
Activity: Complete Full End to End CRUD Testing12 minutes
Activity: Beautify Module Pages10 minutes
Review and Add Changes to GitHub0 minutes
Section Review2 minutes

1 assignmentTotal 15 minutes

Leave Type Management Module - Assessment15 minutes

1 pluginTotal 15 minutes

Building an ASP.NET Core Module with CRUD Operations15 minutes

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.

What's included

13 videos1 assignment1 plugin

13 videosTotal 87 minutes

Section Overview0 minutesPreview module
What are View Models?2 minutes
Refactor Index with View Model11 minutes
Why Use a Mapper?2 minutes
Setup and Use AutoMapper11 minutes
Refactor Details with View Model5 minutes
Understanding Validation3 minutes
Refactor Create with View Model10 minutes
Adding Validation Rules12 minutes
Refactor Edit with View Model8 minutes
Activity: Setup Base Class and Change Labels6 minutes
Activity: Validate If Name Already Exists in Database10 minutes
Section Review1 minute

1 assignmentTotal 15 minutes

Using View Models and Mappers - Assessment15 minutes

1 pluginTotal 15 minutes

Implementing View Models and Mapping15 minutes

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.

What's included

10 videos1 assignment1 plugin

10 videosTotal 47 minutes

Section Overview0 minutesPreview module
What is a Service Layer?2 minutes
Service Layer vs Repository and Unit of Work Patterns5 minutes
Adding the Service Layer (Implementation)11 minutes
Adding the Service Layer (Contract and Implementation)6 minutes
Understanding Dependency Injection Methods4 minutes
Refactor Controller to Use Service9 minutes
Activity: Test Refactored Application5 minutes
Review and Add Changes to GitHub2 minutes
Section Review0 minutes

1 assignmentTotal 15 minutes

Implementing a Service Layer - Assessment15 minutes

1 pluginTotal 15 minutes

Working with Service Layers and Dependency Injection15 minutes

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.

What's included

17 videos1 assignment1 plugin

17 videosTotal 127 minutes

Section Overview0 minutesPreview module
Module Overview and Requirements2 minutes
Understanding Authentication and Authorization2 minutes
Understanding ASP.NET Core Identity Features4 minutes
Activity: Testing Registration and Login8 minutes
Seeding Default Data14 minutes
Scaffolding Identity Pages8 minutes
What are Razor Pages?2 minutes
Activity: Review Login Razor Page10 minutes
Customize User Record and Update Database13 minutes
Customize Registration Process14 minutes
Assign Roles to Users at Registration15 minutes
Bug Fix: Null Exception from Invalid Registration5 minutes
Implement Email Service13 minutes
Restrict Features Based on User6 minutes
Review and Add Changes to GitHub1 minute
Section Review2 minutes

1 assignmentTotal 15 minutes

User Authentication and Authorization - Assessment15 minutes

1 pluginTotal 15 minutes

Expanding ASP.NET Core Identity15 minutes

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.

What's included

21 videos1 reading3 assignments1 plugin

21 videosTotal 188 minutes

Section Overview1 minutePreview module
Module Overview and Requirements1 minute
Database Relationships Overview2 minutes
Entity Framework Core and Relationships3 minutes
Create Leave Allocation Module Data Models9 minutes
Create Migration and Update Database3 minutes
Add Period Management Module6 minutes
Setup Leave Allocation Service6 minutes
Setup Employee Allocation Logic13 minutes
Setup Employee Allocation at Registration7 minutes
Setup Leave Get Allocation Logic8 minutes
Setup Leave Allocation Controller9 minutes
Implement Employee Leave Allocation Queries12 minutes
Setup Employee Leave Allocation View12 minutes
Activity: Test and Refactor Employee Allocations11 minutes
Setup Employee Leave Allocation Admin View - Part 118 minutes
Setup Employee Leave Allocation Admin View - Part 218 minutes
Activity: Test and Refactor Admin Allocation10 minutes
Setup Employee Leave Allocation - Admin Override14 minutes
Activity: Test and Refactor Admin Allocation Edit11 minutes
Section Review3 minutes

1 readingTotal 10 minutes

Conclusion to the Course 'Database Management and Core Application Development'10 minutes

3 assignmentsTotal 90 minutes

Full Course Practice Assessment15 minutes
Leave Allocation Module - Assessment15 minutes
Full Course Assessment60 minutes

1 pluginTotal 15 minutes

Implementing Leave Allocation Logic for New Signups15 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Packt - Course Instructors

Packt

752 Courses152,892 learners

Offered by

Packt

Explore more from Software Development

Status: Free Trial
Microsoft
Database Integration and Management
Course
Packt
Master C# and SQL by Building Applications
Course
Status: Free Trial
University of Colorado System
Database Management Essentials
Course
Status: Free Trial
EDUCBA
Introduction to Modern Web Development with ASP.NET Core
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.

If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.

Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.