Same question: SICP of neuroscience?
I found On Intelligence by Jeff Hawkins very enlightening.
Some books I enjoyed (but which don't necessary achieve that status) are:
- Theoretical Neuroscience by Dayan & Abbott (this has math - but it's quite polite about it, and remains readable if you skip the equations)
- Handbook of Brain Theory and Neural Networks:http://mitpress.mit.edu/0262011972
But those are more theory than biology - would be really interested in a "nuts & bolts" presentation of the brain that is readable and engaging (i.e. nice exercises spread throughout the text, if such a thing is possible)
Principles of Neural Science by Eric R. Kandel, J.H. Schwartz, and Thomas M. Jessell