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.
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.
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.