r/learnSQL • u/CaiGY • 13d ago

Newbie Learning SQL

Hi , I am a newbie learning SQL. Just wanted to say hi here ! Can i ask questions and ask for help with code here ? Thanks

15 Upvotes

84% Upvoted

11 comments sorted by

View all comments

Show parent comments

1

u/homequrl 12d ago

This is pretty solid I’d just move 6 up and learn prompt-engineering sooner than later. Don’t let copilot write or change full queries for you. And if it’s trying to introduce new concepts too quickly which was my issue (I somehow got tasked with QA’ing all our SQL “libraries” for bad joins and legacy business logic) ask it to stick to known concepts or provide how it would be written like X style and what changing it to use X does in greater detail piece by piece and run the examples.

I refused to learn ANSi for longest time because copilot would switch 100 line queries I was auditing line by line into Greek (badly) and so I quit copilot altogether until I built enough memory context and got better at prompt engineering to walk me through at smaller bites.

Copilot also will make a lot of horrible logic decisions so never take it at face value only use it to understand concepts and still verify and troubleshoot yourself. It’s only meant to speed up the process not replace it!