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

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