Solved with a bit of discovery. I clicked “index advisor” for my query out of curiosity and it recommended a new index. Created and built that and the query now takes 21ms - awesome!
Luckily the solution I needed was front and center, but what if it wasn’t there? I wouldnt know what to do, so i’m still very interested in recommendations for practical learning materials.
Thanks again