Asp.Net Core Development With Postgresql & Azure

Build a Full-Stack CRM with ASP.NET Core, EF Core, PostgreSQL, and Deploy to Azure Cloud Step-by-Step.

What you'll learn

Develop a real-world Customer Relationship Management (CRM) system for a travel agency using ASP.NET Core and Entity Framework Core.

Provision and manage a serverless PostgreSQL database with Neon, and connect it to your application with ease.

Deploy your ASP.NET Core application and PostgreSQL database to Microsoft Azure, using services like App Service and Azure Database for PostgreSQL.

Write clean, maintainable code and structure your project using industry-standard practices for scalable application development.

Requirements

Learners should be comfortable writing simple C# code and understand object-oriented programming concepts.

Previous exposure to ASP.NET Core will help, but the course will guide you step-by-step through key concepts.

You should know how tables, records, and simple SQL queries work, even at a beginner level.

Description

Are you looking to build a complete, real-world web application using modern Microsoft technologies and cloud-native tools? Whether you're just starting out or already have some experience with .NET development, this course will guide you through every step of building and deploying a fully functional Customer Relationship Management (CRM) system for a travel agency using ASP.NET Core Razor Pages, Entity Framework Core, PostgreSQL, and Microsoft Azure.This course is designed to be clear and beginner-friendly while delivering valuable insights and techniques for intermediate and advanced developers. You’ll learn to use ASP.NET Core Razor Pages. This page-focused framework simplifies full-stack development by allowing you to create web apps using C# without the complexity of APIs or JavaScript frameworks.You’ll start by setting up your development environment and building the application layer by layer. Using Entity Framework Core, you’ll model your database, apply migrations, and implement create, read, update, and delete (CRUD) functionality. You’ll also learn key concepts like model binding, form validation, layout templates, and page handlers.For the database, you’ll use PostgreSQL, connected via Neon, a modern serverless PostgreSQL platform that supports autoscaling, point-in-time recovery, and branching. You’ll see how to provision your database, connect it to your app, and manage it in a cloud environment.One of the unique aspects of this course is its focus on multi-tenancy—a must-have for scalable applications. You’ll learn how to design your app to support multiple tenants by provisioning and connecting to separate databases per tenant, using Neon’s powerful branching capabilities. This provides a solid foundation for developing scalable SaaS applications.Finally, you'll deploy the application to Microsoft Azure, using Azure App Service for hosting. By the end of this course, you’ll have:A complete, full-stack CRM application built with ASP.NET Core Razor PagesHands-on experience with PostgreSQL and Neon’s serverless database featuresKnowledge of how to support multi-tenancy in real applicationsThe ability to confidently deploy web applications to the cloud using AzureThis course is ideal for beginners and intermediate developers who seek hands-on experience with real-world development practices, utilizing tools and techniques in high demand within the software industry.Enroll today and build something that mirrors what modern developers do daily—design, build, and deploy scalable web applications with .NET and cloud technologies.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Introduction to ASP.NET Core, EF Core, and PostgreSQL

Section 2: Getting Started with ASP.NET Core Razor Pages

Lecture 3 Section Overview

Lecture 4 Setup Development Environment

Lecture 5 Creating and Tour a New Razor Pages Project

Lecture 6 Running and Testing The Web App

Lecture 7 Find and setup an Admin Theme

Lecture 8 Customizing the Admin Theme

Lecture 9 Section Review

Lecture 10 Section Source Code

Section 3: Integrating Neon PostgreSQL (Cloud Database)

Lecture 11 Section Overview

Lecture 12 Setting up Entity Framework Core

Lecture 13 Defining the Database Models

Lecture 14 Add Migrations

Lecture 15 Seeding Default Data

Lecture 16 What is Neon.tech, and why use it?

Lecture 17 Provisioning a Neon Database Project

Lecture 18 Applying EF Core Migrations and Creating the Database

Lecture 19 Section Review

Lecture 20 Section Source Code

Section 4: Building the CRM Functionality

Lecture 21 Section Overview

Lecture 22 Adjust Layout for User Buttons

Lecture 23 Complete User Registration Feature

Lecture 24 Complete User Login Feature

Lecture 25 Creating the Customer Management Pages - Part 1

Lecture 26 Creating the Customer Management Pages - Part 2

Lecture 27 Creating Booking Management Pages

Lecture 28 Add Email Features

Lecture 29 Section Review

Lecture 30 Section Source Code

Section 5: Implementing Multi-Tenant Database Provisioning

Lecture 31 Section Overview

Lecture 32 Neon Database Branching and API Basics

Lecture 33 What is Multi-Tenancy? Concepts and Design

Lecture 34 Implementing Neon API Service - Part 1

Lecture 35 Implementing Neon API Service - Part 2

Lecture 36 Storing Tenant Connection String

Lecture 37 Automating Tenant Database Creation During Runtime

Lecture 38 Configuring Dynamic Database Connections Based on Tenant

Lecture 39 Testing and Refactoring

Lecture 40 Refactoring CRUD Operations

Lecture 41 Encrypting Saved Connection Strings

Lecture 42 Section Review

Lecture 43 Section Source Code

Section 6: Deploying to Microsoft Azure

Lecture 44 Section Overview

Lecture 45 Setup Microsoft Azure Account

Lecture 46 Setting Up Azure App Service

Lecture 47 Neon with Azure Hosting

Lecture 48 Publishing the Application to Azure

Lecture 49 Add Configurations to Azure App Service

Lecture 50 Section Review

Section 7: Conclusion

Lecture 51 Conclusion and Next Steps

Aspiring .NET Developers,Developers Looking to Learn PostgreSQL with .NET,Anyone Interested in Building Real-World Web Applications