This will cover 90% of what you need to know and it uses SQL for most examples: https://www.amazon.com/Data-Warehouse-ETL-Toolkit-Techniques-Extracting/dp/0764567578/.
I'd look to supplement this with your ETL stack of choice, e.g., Azure, Databricks, AirFlow etc.