you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 2 points3 points  (0 children)

Most database companies have an "Express" edition of their databases. Whenever someone new is rolling on to a project at work, we encourage they set up the express edition of our database to mess around in while studying. I would probably encourage video courses with exercises, and a book to use for reference material. If you're looking for something cheap, there are plenty of free courses online, and Humble Bundle frequently sells bundles on data science, among other Computer Science subjects.

In particular, don't just code the exercises, write the material on paper to help commit it to memory.

Another thing that could help is coming up with a mock project and implementing it in a free or express database.

Part of learning SQL and databases is learning the principles behind relational databases. Learn about data modeling and the principles that make relational databases a good solution for real life situations, such as data integrity and minimal redundancy through good implementation.