The 80/20 split you mention is exactly what I needed to hear. I've been stuck in tutorial hell trying to memorize every sintax detail when I should be writing queries instead. Your ChatGPT prompt for iterative challenges is really clever, turns AI from a crutch into actualy a training partner. How long does it usualy take to feel comfortable with window functions?
I don’t it will become as good as software devs and data analysts. I just dealt with this today, I have a client is e-commerce and logistics, compared my hand drawn diagrams to Clause Sonnet 4.5, and by models had less redundancy and reflected the business domain better, even after I gave it the same notes I had from the meeting with the client. Don’t underestimate human intelligence! 😉
I just picked up SQL for dummies all in one, I know it’s not the normal brand for tech but as an engineer who’s worked in tech over a decade this book is GOLD.
Hey, this is awesome! I just bought SQL for dummies a couple weeks ago and it’s been great. Today I was reading the section that covered sub/super entity types and entity relationship modeling for databases, I even started drawing up the modeling relationships by hand.
Totally aligned with it, I have also followed the same while learning SQL. Syntax I still struggle sometimes but I also know eventually you become better at it as more on similar implementation and problems. Findings correct functions is skill, you just need to figure out the correct strategy to approach the problem. And with use of AI, making your basic solution/query, a super optimised query has become easier than ever. Plus I think to practice, AI is great tool, but Leetcode 50 SQL or Hackerrank SQL problem are still gold standards to understand the SQL workings deeply and do well in interviews and work.
The 80/20 split you mention is exactly what I needed to hear. I've been stuck in tutorial hell trying to memorize every sintax detail when I should be writing queries instead. Your ChatGPT prompt for iterative challenges is really clever, turns AI from a crutch into actualy a training partner. How long does it usualy take to feel comfortable with window functions?
I feel you on tutorial hell, I’m still getting better with subqueries, but if you keep at it you’ll get better!
Brilliant. But AI will get good at SQL reivew, too!
I don’t it will become as good as software devs and data analysts. I just dealt with this today, I have a client is e-commerce and logistics, compared my hand drawn diagrams to Clause Sonnet 4.5, and by models had less redundancy and reflected the business domain better, even after I gave it the same notes I had from the meeting with the client. Don’t underestimate human intelligence! 😉
SQL always fascinated me. After this post I feel more motivated and can’t find a reason not to started learning it.
Do you have any recommendations for website/software to start with it (mysql, dbfiddle…)?
I just picked up SQL for dummies all in one, I know it’s not the normal brand for tech but as an engineer who’s worked in tech over a decade this book is GOLD.
It seems very precise. Congratulations.
Your 30 hours SQL course is a life saver!
Hey, this is awesome! I just bought SQL for dummies a couple weeks ago and it’s been great. Today I was reading the section that covered sub/super entity types and entity relationship modeling for databases, I even started drawing up the modeling relationships by hand.
Totally aligned with it, I have also followed the same while learning SQL. Syntax I still struggle sometimes but I also know eventually you become better at it as more on similar implementation and problems. Findings correct functions is skill, you just need to figure out the correct strategy to approach the problem. And with use of AI, making your basic solution/query, a super optimised query has become easier than ever. Plus I think to practice, AI is great tool, but Leetcode 50 SQL or Hackerrank SQL problem are still gold standards to understand the SQL workings deeply and do well in interviews and work.