

That’s right, the TV show has practically nothing to do with the books other than some character and place names and the general idea of a declining emprire and its emerging remote colony.
The first two books are really great, but I feel the quality starts dropping at the third, but the series is pretty good as a whole (never got to reading Forward the Foundation though). Asimov’s writing is a bit cringe sometimes, especially about women and children (although there are some strong female characters).
That’s very unfortunate but hopefully you developed skills that will help you in your future career.