For a long time I thought some knowledge of PostgreSQL will be enough to handle Amazon Redshift.
Today I came to realization I was wrong. I'm in desperate need for good books about Redshift. I'd love to get a book that would touch on designing tables but also troubleshooting queries.
At the moment I am checking on books listed here https://bookauthority.org/books/best-amazon-redshift-ebooks
Thanks!
Note I'm pretty sure about half of them are admin-type guides, not developer guides; they'll be superficial, and do things like walking you through the screens to start a cluster.
One note : in my view, the official docs are harmful, because they are so poorly written, and so are misleading. I am absolutely certain, from what I have seen documented and then what I have found Redshift is actually doing, that no one technical reviews the official docs. By all means read them, but have your paranoia turned up to 11.
I maintain a web-site where I research Redshift internals and publish white papers. High on the to-do list is a "Introduction to the Fundamentals" paper, which will be exactly what you need. In the meantime, the existing white papers may be of use to you.