Re:Ask HN: Junior SQL developers – How do you learn SQL?
by s-stude on Thursday March 11, 2021 @02:06PM
(#26427725)
Thanks for sharing this. You are saying that there is a ton of stuff to learn....how do you solve this problem now?
Re:Ask HN: Junior SQL developers – How do you learn SQL?
by Jcowell on Thursday March 11, 2021 @02:45PM
(#26428178)
You just learn as you go. For something like SQL, unless they’re doing something doing a query that’s never been done before , the majority of one’s issues is a Google search away of a function or thing they didn’t know they could do before.
I never make it a task to know completely what a language could do. I just try to familiarize my self with the basics (syntax) it’s novelty features (the reason why it even exists as opposed to other solutions) and pray what I think the best solution for a given problem is doable via research (Google & Stackoverflow)
When I got hired as a SQL Developer with little experience. I got a rundown on my employers database and tables and then tried my best. Google and Stack was the best teacher and with each work assignment I learned something new or a better way to do what I did before. Often the SQL queries I wrote would require updates and I would put in better solutions.
There’s still a ton of stuff I don’t know and I made a lot of mistakes along the way , but I still feel like this was the best learning experience for me.