End-to-End ASP.NET Core - PostgreSQL Data Stores & Azure Services

Packt via Coursera

Go to class Write review

Overview

Coursera Flash Sale

40% Off Coursera Plus for 3 Months!

Grab it

This course 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. In this comprehensive course, you will learn how to build modern web applications using ASP.NET Core, PostgreSQL, and Microsoft Azure services. The course covers everything from setting up your development environment to deploying an application in the cloud. You will gain hands-on experience in creating dynamic web applications with Razor Pages, integrating a PostgreSQL database, and applying multi-tenant architectures for efficient data handling. With a focus on real-world application, this course equips you with the tools and knowledge needed to develop and deploy scalable applications. Throughout the course, you will follow a step-by-step guide that covers key areas like connecting to PostgreSQL using EF Core, implementing customer relationship management (CRM) functionality, and provisioning multi-tenant databases. You will also learn how to deploy the application to Microsoft Azure, ensuring your project is production-ready. Each section builds upon the last, allowing you to develop progressively more complex skills. This course is ideal for developers who want to master full-stack development using modern tools and services. Whether you are looking to sharpen your skills in web development or aim to build scalable cloud-based solutions, this course will guide you through all the critical stages of web application development. By the end of the course, you will be able to create and deploy full-featured ASP.NET Core applications, integrate and manage a PostgreSQL database, implement multi-tenant systems, and deploy to Microsoft Azure.

Syllabus

Introduction

In this module, we will introduce the structure and objectives of the course, providing an overview of the essential technologies like ASP.NET Core, EF Core, and PostgreSQL. You’ll gain a foundational understanding of how these technologies work together to build scalable and efficient web applications.

Getting Started with ASP.NET Core Razor Pages

In this module, we will guide you through the process of setting up your development environment and creating your first Razor Pages project. You’ll learn how to test and run the application, as well as how to find and customize an admin theme to enhance the user interface. By the end of this section, you’ll have a fully functional Razor Pages web application with a professional design.

Integrating Neon PostgreSQL (Cloud Database)

In this module, we will explore how to integrate Neon PostgreSQL with your application using EF Core. You will learn how to set up your database models, create migrations, and seed initial data. Additionally, we’ll introduce Neon.tech, guiding you through provisioning and applying migrations to create a cloud-based PostgreSQL database for your application.

Building the CRM Functionality

In this module, we will build key customer relationship management (CRM) functionalities into your application. You will learn to implement user registration and login systems, manage customer data, and create pages for handling customer bookings. Additionally, we’ll integrate email features to facilitate notifications and confirmations, completing a robust CRM system.

Implementing Multi-Tenant Database Provisioning

In this module, we will dive into the implementation of multi-tenant database provisioning. You will learn how to design and configure your application to handle multiple tenants, with separate databases for each. We’ll walk you through using the Neon API for provisioning, automating database creation, and securely managing connection strings to ensure tenant data isolation and security throughout the application.

Deploying to Microsoft Azure

In this module, we will guide you through deploying your ASP.NET Core application to Microsoft Azure. You’ll learn how to set up your Azure account, configure an Azure App Service, and integrate Neon PostgreSQL for a fully cloud-based environment. We’ll also walk through the publishing process and help you fine-tune your configurations to ensure smooth and reliable application performance on Azure.

Conclusion

In this module, we will wrap up the course by reviewing the core concepts and skills you’ve acquired. We’ll suggest actionable next steps to help you apply your knowledge in real-world projects and continue building your expertise with ASP.NET Core, PostgreSQL, and Azure services. This conclusion will set you up for future success and continued learning.