Microsoft often buries the true offline link. They prefer you use the "Download Center" media flow.
When you download the (usually found as an .exe or .cab file roughly 300MB to 800MB in size, depending on the included features), you aren't just downloading the database engine. You are capturing the entire ecosystem required to make it run. sql express 2022 offline installer
Unfortunately, I couldn't find a direct link to the SQL Server Express 2022 offline installer. However, you can try the following links: Microsoft often buries the true offline link
The offline package bundles these prerequisites. It allows for what IT pros call a "silent install" using configuration files. You can craft a simple .ini file, point the offline installer to it, and walk away. The machine doesn't need to know the internet exists; it has everything it needs on the local drive. You are capturing the entire ecosystem required to
The offline installer won’t break if Microsoft changes a URL or if your network proxy blocks the download. Perfect for automated scripts and mass deployments via Group Policy or SCCM.