How I Built an Advanced SQL Tutorial — and Self-Hosted It on My Own NAS

A few days ago I ran into a small frustration. There are tons of beginner SQL tutorials online… But when it comes to real-world, advanced queries used for data analysis, things get vague fast. So I decided to write one myself. Not on Medium. Not just here on Dev.to. But on a static site I built and host entirely from my own NAS. 🧠 The Goal I wanted to create a tutorial that covers: Multi-table JOIN strategies Window functions Conditional aggregations with CASE Common Table Expressions (CTEs) Practical data-analysis style queries Something useful for people who already know SQL basics — and want to level up. Here is the tutorial 🛠 Why I Self-Hosted It Instead of publishing only on big platforms, I built my own stack: Astro (static site generator) Docker Nginx Nginx Proxy Manager Everything running on my Synology NAS Why? Because I wanted: Full control No dependency on external CI services Automated rebuilds Zero-downtime static deployment A playground to learn real infrastructure It tur