When will I receive my Course Certificate?

If you complete the course successfully, your electronic Course Certificate will be added to your Accomplishments page - from there, you can print your Course Certificate or add it to your LinkedIn profile.

Why can’t I audit this course?

This course is currently available only to learners who have paid or received financial aid, when available.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Database Management and Core Application Development

Database Management and Core Application Development

本课程是 Complete ASP.NET Core and Entity Framework Development 专项课程的一部分

位教师：Packt - Course Instructors

包含在 Coursera Plus 中

了解更多

6个模块

深入了解一个主题并学习基础知识。

中级等级

推荐体验

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

6个模块

深入了解一个主题并学习基础知识。

中级等级

推荐体验

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将学到什么

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

您将获得的技能

要了解的详细信息

可分享的证书

添加到您的领英档案

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

积累特定领域的专业知识

本课程是 Complete ASP.NET Core and Entity Framework Development 专项课程专项课程的一部分

在注册此课程时，您还会同时注册此专项课程。

向行业专家学习新概念
获得对主题或工具的基础理解
通过实践项目培养工作相关技能
获得可共享的职业证书

该课程共有6个模块

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.

涵盖的内容

11个视频2篇阅读材料1个作业1个插件

11个视频总计53分钟

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

2篇阅读材料总计20分钟

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

1个作业总计15分钟

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

1个插件总计15分钟

Introduction to EF Core and Migrations15分钟

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.

涵盖的内容

16个视频1个作业1个插件

16个视频总计104分钟

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

1个作业总计15分钟

Leave Type Management Module - Assessment15分钟

1个插件总计15分钟

Building an ASP.NET Core Module with CRUD Operations15分钟

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.

涵盖的内容

13个视频1个作业1个插件

13个视频总计87分钟

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

1个作业总计15分钟

Using View Models and Mappers - Assessment15分钟

1个插件总计15分钟

Implementing View Models and Mapping15分钟

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.

涵盖的内容

10个视频1个作业1个插件

10个视频总计47分钟

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

1个作业总计15分钟

Implementing a Service Layer - Assessment15分钟

1个插件总计15分钟

Working with Service Layers and Dependency Injection15分钟

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.

涵盖的内容

17个视频1个作业1个插件

17个视频总计127分钟

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

1个作业总计15分钟

User Authentication and Authorization - Assessment15分钟

1个插件总计15分钟

Expanding ASP.NET Core Identity15分钟

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.

涵盖的内容

21个视频1篇阅读材料3个作业1个插件

21个视频总计188分钟

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

1篇阅读材料总计10分钟

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

3个作业总计90分钟

Full Course Practice Assessment15分钟
Leave Allocation Module - Assessment15分钟
Full Course Assessment60分钟

1个插件总计15分钟

Implementing Leave Allocation Logic for New Signups15分钟

获得职业证书

将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。

位教师

Packt - Course Instructors

Packt

971 门课程231,340 名学生

提供方

Packt

从 Software Development 浏览更多内容

状态：免费试用
Microsoft
Database Integration and Management
课程
Packt
Master C# and SQL by Building Applications
课程
状态：免费试用
University of Colorado System
Database Management Essentials
课程
状态：免费试用
EDUCBA
Introduction to Modern Web Development with ASP.NET Core
课程

人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

自 2018开始学习的学生

''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'

Jennifer J.

自 2020开始学习的学生

''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'

Larry W.

自 2021开始学习的学生

''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'

Chaitanya A.

''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'

通过 Coursera Plus 开启新生涯

无限制访问 10,000+ 世界一流的课程、实践项目和就业就绪证书课程 - 所有这些都包含在您的订阅中

了解更多

通过在线学位推动您的职业生涯

获取世界一流大学的学位 - 100% 在线

探索学位

加入超过 3400 家选择 Coursera for Business 的全球公司

提升员工的技能，使其在数字经济中脱颖而出

了解更多

常见问题

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.