I will answer this question in two ways: one, I will tell you how I learned, and two I will tell you how I would have liked to have learned with the benefit of hindsight. Different people will value one more than the other, but both are more valuable than a giant list of resources with zero guidance where to start.
How I learned:
I started out like you, in possession of an undergraduate education in computer science. I began reading Quantum Computer Science: An Introduction[0] by N. David Mermin. This is a very good textbook, but I absolutely could not skim it. I had to ensure I understood every single line before moving onto the next. I had the impression I wasn't learning very quickly, when in fact (due to the textbook's density) I was taking in a huge amount of information.
After a few weeks with the Mermin textbook, I bought Quantum Computing for Computer Scientists[1] by Yanofsky & Mannucci. This is a much softer introduction than Mermin, almost too soft: I skipped the first few chapters on linear algebra and complex numbers. However, in combination with the Mermin textbook, I acquired a good understanding of quantum computing basics. It was at this point I reached my own personal threshold for feeling I "understood" quantum computing.
People often recommend Quantum Computation and Quantum Information by Nielsen & Chuang (also called "Mike & Ike") for beginners. I believe this is not good advice. Had I tried to learn from that textbook, I would have failed. However, it is an excellent textbook after you already understand the basics. Anecdotally, I knew two people who tried to learn quantum computing at the same time as me: one used Mike & Ike, and the other used a book called Quantum Computing: A Gentle Introduction. Neither of those people understand quantum computing today.
How I wish I had learned:
My experience learning quantum computing required a huge amount of mental effort, and in the end what I learned wasn't actually complicated! So, I created a lecture called Quantum Computing for Computer Scientists[2] which is the lecture I wish I'd had access to before trying to read any textbooks. The lecture is popular and well-received, and I think it covers all the stuff that's really conceptually tricky; once you're over those conceptual hurdles, you can apply your regular computer science skills to learn everything else about quantum computing you need (how specific algorithms work, etc.) Thus my "hindsight" study guide is as follows:
1. Watch the lecture I created.
2. Watch Professor Umesh Vazirani's lectures on quantum computing; they flesh out my lecture and he is a tremendously effective explainer of concepts (these are scattered around YouTube but you can find a full playlist at [3])
3. Concurrently, work through the first few chapters of either the Mermin or Yanofsky textbooks
4. After you feel you understand the quantum computing basics, pick topics which interest you from the Nielsen & Chuang textbook
5. Stick around quantumcomputing.stackexchange, reading questions & answers, asking your own, and maybe eventually answering your own!
Good luck!
P.S. I've also heard good things about the Quantum Katas: https://www.amazon.com/Quantum-Computer-Science-David-Mermin...
We wrote our O'Reilly book, "Programming Quantum Computers", precisely to fit your use case. It assumes no advanced mathematics, doesn't shy away from really delving into how algorithms work, and also has an online simulator to let you experiment with actual code. I am of course biased, but I would say that it's the resource out there requiring the least mathematics needed to get some practical knowledge and a chance to experiment in code:
Shameless plug dealt with, the text I'd next point you to for being grounded more in the Real world rather than Hilbert space is Mermin's. Modulo his insistence on using the term QBit rather than qubit, it's a great pedagogical work by someone with a very deep understanding of quantum mechanics. It's also in hardcover, which also helps lend it more weight:
As others have recommended, anything by Scott Aaronson is gold. Computational complexity is his passion, and although I think his work is very thorough and accessible, I would suggest it's a little less hands-on. However for very, very deep insights there's nowhere better to go. Alongside his book, Aaronson's blog at https://www.scottaaronson.com/blog/ is also revered by both QC enthusiasts and professionals alike and a great place to follow debate on the latest developments in the field.
The most mathematically demanding text (or most thorough, depending on how you look at it) I'd consider is Nielsen and Chuang (a.k.a "Mike 'n' Ike", a.k.a "The bible"). It's slightly out of date in some more recent concepts regarding the implementation of quantum computing (not wrong, just a tad incomplete), but is still solid and indispensable for the core concepts and insights behind quantum computing.
If you're interested in the physical implementation of a quantum computer (i.e. what does it _look_ like inside), then Mike 'n' Ike is the only one that will come close to satisfying you. The real world is so damn messy, and quantum hardware is no exception. QC tech moves fast and the money is still on the table as to just what that tech might look like inside the million qubit quantum computer of the future. Mike 'n' Ike does discuss some specific types of qubits, but I'm not aware of a book providing a truly comprehensive and up to date description of today's most promising approaches.
How I learned:
I started out like you, in possession of an undergraduate education in computer science. I began reading Quantum Computer Science: An Introduction[0] by N. David Mermin. This is a very good textbook, but I absolutely could not skim it. I had to ensure I understood every single line before moving onto the next. I had the impression I wasn't learning very quickly, when in fact (due to the textbook's density) I was taking in a huge amount of information.
After a few weeks with the Mermin textbook, I bought Quantum Computing for Computer Scientists[1] by Yanofsky & Mannucci. This is a much softer introduction than Mermin, almost too soft: I skipped the first few chapters on linear algebra and complex numbers. However, in combination with the Mermin textbook, I acquired a good understanding of quantum computing basics. It was at this point I reached my own personal threshold for feeling I "understood" quantum computing.
People often recommend Quantum Computation and Quantum Information by Nielsen & Chuang (also called "Mike & Ike") for beginners. I believe this is not good advice. Had I tried to learn from that textbook, I would have failed. However, it is an excellent textbook after you already understand the basics. Anecdotally, I knew two people who tried to learn quantum computing at the same time as me: one used Mike & Ike, and the other used a book called Quantum Computing: A Gentle Introduction. Neither of those people understand quantum computing today.
How I wish I had learned:
My experience learning quantum computing required a huge amount of mental effort, and in the end what I learned wasn't actually complicated! So, I created a lecture called Quantum Computing for Computer Scientists[2] which is the lecture I wish I'd had access to before trying to read any textbooks. The lecture is popular and well-received, and I think it covers all the stuff that's really conceptually tricky; once you're over those conceptual hurdles, you can apply your regular computer science skills to learn everything else about quantum computing you need (how specific algorithms work, etc.) Thus my "hindsight" study guide is as follows:
1. Watch the lecture I created.
2. Watch Professor Umesh Vazirani's lectures on quantum computing; they flesh out my lecture and he is a tremendously effective explainer of concepts (these are scattered around YouTube but you can find a full playlist at [3])
3. Concurrently, work through the first few chapters of either the Mermin or Yanofsky textbooks
4. After you feel you understand the quantum computing basics, pick topics which interest you from the Nielsen & Chuang textbook
5. Stick around quantumcomputing.stackexchange, reading questions & answers, asking your own, and maybe eventually answering your own!
Good luck!
P.S. I've also heard good things about the Quantum Katas: https://www.amazon.com/Quantum-Computer-Science-David-Mermin...
[1] https://www.amazon.com/Quantum-Computing-Computer-Scientists...
[2] https://youtu.be/F_Riqjdh2oM + slides https://speakerdeck.com/ahelwer/quantum-computing-for-comput...
[3] https://www.youtube.com/playlist?list=PLDAjb_zu5aoFazE31_8yT...
https://www.amazon.com/Programming-Quantum-Computers-Essenti...
Shameless plug dealt with, the text I'd next point you to for being grounded more in the Real world rather than Hilbert space is Mermin's. Modulo his insistence on using the term QBit rather than qubit, it's a great pedagogical work by someone with a very deep understanding of quantum mechanics. It's also in hardcover, which also helps lend it more weight:
https://www.amazon.com/Quantum-Computer-Science-David-Mermin...
As others have recommended, anything by Scott Aaronson is gold. Computational complexity is his passion, and although I think his work is very thorough and accessible, I would suggest it's a little less hands-on. However for very, very deep insights there's nowhere better to go. Alongside his book, Aaronson's blog at https://www.scottaaronson.com/blog/ is also revered by both QC enthusiasts and professionals alike and a great place to follow debate on the latest developments in the field.
The most mathematically demanding text (or most thorough, depending on how you look at it) I'd consider is Nielsen and Chuang (a.k.a "Mike 'n' Ike", a.k.a "The bible"). It's slightly out of date in some more recent concepts regarding the implementation of quantum computing (not wrong, just a tad incomplete), but is still solid and indispensable for the core concepts and insights behind quantum computing.
If you're interested in the physical implementation of a quantum computer (i.e. what does it _look_ like inside), then Mike 'n' Ike is the only one that will come close to satisfying you. The real world is so damn messy, and quantum hardware is no exception. QC tech moves fast and the money is still on the table as to just what that tech might look like inside the million qubit quantum computer of the future. Mike 'n' Ike does discuss some specific types of qubits, but I'm not aware of a book providing a truly comprehensive and up to date description of today's most promising approaches.