Joining and aggregations. Aggregations are immensely powerful. And learning how to do stuff in SQL (or pandas) without using for loops. It's the same as when you start using numpy. As long as you can write it as an expression or query, it's superfast.