Installing .NET stacks including Runtime, SQL Server is a nightmare to me. When an error occurs during installation process, you got stuck , hopeless and depressed. Hey MS, fix your installation process first.
Don't get me wrong though, I worked to integrate it into Yocto because I love .NET/C#, but the build system needs a lot of love.
See https://github.com/dotnet/source-build#net-core-build-script... and https://github.com/dotnet/arcade#arcade
.NET Core has self contained deployments so you can bundle it with your app in a .zip.
For development or continuous integration SQL Server comes in a container now.
They first bundled (1.0) with xp, and every OS since. I don't know why they bothered considering practically every app has had to bundle newer versions with the installer. They could have at least pushed newer versions with windows update.