This video walks through the options for building mapping applications. It talks through the stack; client, server, database. And discusses some of the tools...
Spatial data and web mapping with Python
Basic Options for Building Web Map Applications
Easy web mapping with Web Map Layers.mp4
How To Start Mapping Out Your Website
Le webmapping sans programmation ;)
Web Map Service (WMS) With QGIS