Homeschooling mom of 3 boys who are moving into high school and I need a challenge to occupy me while they ignore me. I think I could learn SQL but am wondering if this is the best use of my education or should I be learning a different datamodel such as Casandra or another type of noSQL. Any advise? I did VFX before kids so used to the "Learn the program on your own" model.
I have a love for SQL Server but Postgres seems to be gaining a huge amount of popularity.
As with any language, learn the basics first and then concentrate on the functions because that's where the real power of the language is. Also, when working with databases, you need to change your mind set and make a huge paradigm shift if you know any other language when it comes to SQL...
"Stop thinking about what you want to do to a ROW and start thing about what you want to do to COLUMNS".
If you don't already know the basics, the following link will take you to a good free site to get you started. Remember that it's teaching more than one "flavor" of SQL. It seems like every bloody database engine has its own take on what SQL should do and the syntax varies, as well, especially for the functions and similar "beyond beginner" functionality.
https://www.w3schools.com/sql/
If you take their test, you can even get a certificate out of it and it's a fairly well respected site so the certificate will actually carry more weight than some of the toilette paper that some other free sites offer.
18 People are following this question.
