How many years did it take for people to be comfortable with intermediate/advanced SQL for work projects? I took a course in SQL but that wasn’t enough to cover most of what I needed to know for a real world project SQL seems to have a steep learning curve.
Leetcode.
If you can't pick up SQL in a few days you need a new field.
Basic SQL is that easy yes
Gay answer that only clueless professors give
Zero, it's pretty simple, you just google anything you don't remember.
Don't stress much. SQL is big, you may be a rock star SQL DA but struggle at first as a SQL dev but you will get there. Don't give up, you got it
I always feel like I don’t know enough. Imposter syndrome is a real issue with SQL
Yea I feel like it takes me an hour to solve something that takes an expert 10 minutes
That feeling never goes away lol
Of course YMMV and I have no vested interest here but I felt a lot better with SQL after hands on work with this course https://www.udemy.com/course/master-sql-for-data-science
Go online and practice sql on leetcode like websites. That helps you become faster at least. I was bad at window functionsand subqueries, but it became natural after that. Theres more to it but it covers 1 aspect
Don’t worry, LLMs will automate lot of sql generation before you master it. Look into text to sql generation using LLMs
Basic SQL takes a day. Advanced SQL is very difficult to learn without actually working with it heavily on the job, but at that point only takes a few months under the correct guidance. I wouldn't sweat it.
Learn SQL fundamentals then live and breath SQL for 3 months and you'll be set. There's a "specific way" that the language wants you to think. If you feel no progress after living and breathing it over a month, then supplement it with Python Pandas. The way that the Pandas package wants you to think is similar to the way that SQL wants you to think. Once you capture the essence of that logic, all SQL will look the same to you. Wish you the best of luck!
Thank you sensei