My favorite has been https://pgexercises.com/. Instead of going through theory, you practice writing progressively more complex queries to achieve a specific result.