Re:Mathematics for Programmers [pdf]
by chombier on Thursday September 24, 2020 @05:05PM
(#24583650)
Seven Sketches is a nice introductory read, giving examples of how CT may be used model practical problems and introducing concepts along the way.
"Programming with Categories" [0] is probably the best resource to start, the course notes are great and the videos are easy to follow.
Also yes, Awodey is much more in-depth and technical.
Category Theory for Programmers is just that, for programmers. In fact, if I recall correctly its preface explicitly answers the question 'Why write this when Category Theory by Steve Awodey exists?', with the answer being what I summarise above. If you're a computer scientist, programmer, or otherwise a non-mathematician first, Awodey is not for you and this book I believe should serve you very well instead. I haven't read it, mind.
I haven't come across Seven Sketches in Compositionality, but hopefully that helps compare the other two. It's mostly about your intention (e.g. theoretical mathematics vs practical application) and background.