> Mentioning SQL means backend which implies they need to understand that a network connection is incoming to a server bound on a port with a method, URL, list of cookies/headers, etc. with the purpose of serving a request with a response

HTML pages will be served over HTTP too, so that's already necessary to understand how web works.