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 turned into a fun DevOps + content hybrid project.

📊 Unexpected Bonus

After publishing, I started seeing:

Google Search Console impressions

Reddit traffic

Organic indexing beginning

Which is pretty motivating when you're running everything from your own hardware.

🔥 What You’ll Actually Learn In The Tutorial

This isn’t theory-heavy.

It walks through:

Complex analytical queries

Real aggregation patterns

SQL techniques used in reporting and dashboards

Clean examples you can run on any relational database

If you're into SQL for analytics, this might be useful.

Here it is again:

💬 Feedback Welcome

I’m continuously improving both the content and the infrastructure behind it.

If you’re into:

SQL

Self-hosting

Docker

Static site automation

Or just building things from scratch

I’d love to hear your thoughts.

What advanced topic should I cover next?