See no Evil is excellent as it covers both CIA training and what intelligence officers actually spend their time doing:

https://en.wikipedia.org/wiki/See_No_Evil_(Baer_book)

Something like Paddy Ashdown's auto biography covers how he got into MI6 (Royal Marines and SBS) and what his cover story was but carefully avoids the intelligence side of his work.