I recently started reading "Think Like a Programmer" (http://www.amazon.com/dp/1593274246) and I find it quite helpful.

Does anyone know a good time in one's career to take time out and spend it on going through SICP and videos lectures with it?

I have a STEM (non-CS) degree but very recently, started working as a programmer. Doing my first internship at a 'techy' corporate company. One of the things I'd be doing on the side is to go through https://mitpress.mit.edu/books/elements-computing-systems. The video introduction to it just gives me goosebumps to this day. I don't know why. It's fascinating.

Than there is other paradigm books such as "pragmatic programmer", "Thinking Like A Programmer", "Design Patterns: Elements of Reusable Object-Oriented Software", etc.

So far, I've done plenty of reading on Algorithm & Design Structure and leetcode here and there. In the past, I didn't qualify for internship at Google, Amazon or M$ as a software developer/engineer. I feel the reason why I didn't was because I didn't have a "computer science" keyword mentioned anywhere on my resume. Hence, my hope is after getting through "Element of Computing System" & Design Pattern, I'll be able to shove in "computer science" keyword one way or another on my resume.

there is a series of books by this woman named Barbara Oakley, she studied languages while she did military service because all throughout her schooling she felt bad at math and science, now she has a PHd in Engineering, you might get something out of reading them, the first one (or at least the more influential one) is called "A Mind for Numbers"

there are also other books you might get something out of, thinking about pursuing a career in web development, which is related to computer science and programming, too many to list, but a couple I've read recently and think are really worth reading are "How to Solve it" by G. Polya, and "Think Like a Programmer" by V. Anton Spraul

also, don't feel to down for flunking, or get the idea that vocational school is less worthwhile than University (short them, maybe, but if you're good, it doesn't matter if you didn't get a University Degree, I myself have a job as a Software Developer and haven't gotten a degree)

do be honest from now on, and stay disciplined, there was this guy (can't remember the name right now) who said that we aren't truly free unless we are disciplined, for we are slaves to our bodily urges, and to our laziness, or something to that effect

asking for help is a start, stay motivated!