SQLite is a really good one because - at least for SELECT features - it feels to me like a very clean subset that works across most other databases.

I'd recommend digging into PostgreSQL as well, since it's "larger" than SQLite and will expose you to a bunch more concepts.

If you're familiar with both SQLite and PostgreSQL you should find other dialects very easy to pick up when you need them.