Learn the stack

The Windows PC, Docker, Git, Blazor, PostgreSQL and database design, each as a complete series that assumes nothing and ends with you capable.

Start here

The series, in order

8 series, 72 parts in all, in the order we suggest reading them.

6 parts · ~38 min total · starts at Part 1

Set Up a Windows PC for .NET Development

Six hands-on parts for a Windows 11 PC used for .NET work: SDKs, runtimes and global.json, WSL, ports and the firewall, LocalDB and PostgreSQL in Docker, the Git for Windows settings that stop the warnings, and the HTTPS developer certificate. Every command was run on a real machine and every output is quoted.
8 parts · ~51 min total · starts at Part 1

Docker for .NET Developers on Windows

Eight hands-on parts that take a .NET developer on Windows from a fresh Docker Desktop to an app and its PostgreSQL database running from one compose file and shipped as an image: what Desktop actually runs, containers, bind mounts and volumes, ports and networking, PostgreSQL, Compose, building the image, and the daily loop. Every command was run on a Windows 11 PC and every output is real.
12 parts · ~74 min total · starts at Part 1

Database Design for Developers

Twelve hands-on parts from an ER sketch to a production schema, on SQL Server and PostgreSQL side by side: keys, relationships, column types, constraints, normalisation, naming, indexes, soft delete and history, migrations, and search. Every script was run on both engines; every output shown is real.
9 parts · ~63 min total · starts at Part 1

Student Projects: From Conversation to Database

Nine classic student projects, each designed from a conversation with the person who needs it: library, school, attendance, hostel, hospital, inventory, hotel, railway reservation and online shop. Entities, relationships, keys and CREATE TABLE scripts run on SQL Server and PostgreSQL, the viva questions answered with real output, the textbook mistake repaired, and an ER diagram for every one.

Also in this path

Standalone posts on the same ground, newest first. Each one stands on its own.