I have two goals:
-to be able to set up and run my own website which requires use of databases (not just static web pages)
-to learn any specific marketable skill well enough to get an entry-level job
I have taken CS50, MIT's Python courses, and courses on web development by HKUST and Uni of London. I've set up basic sites by following these courses and tutorials, using frameworks meteor, React, Ruby on Rails...
The result has been a bunch of disconnected knowledge that hasn't helped me achieve my two goals. None of the courses have been comprehensive enough to get a site up and running. I haven't gained enough experience in any specific area (frontend/UI, backend, testing, coding for mobile, etc) to get a job.
If anyone has advice, or can point me towards resources that I've overlooked, you will be a lifesaver. Thank you.
Really, my advice is to just CODE. Try to finish a project. Don't get discouraged when it's not happening as fast as you'd like. Take things slow, and focus on one implementation at a time.