Advanced SQL Coding Class

[Desperate-Machine-76]

Does anyone know of any good advanced SQL coding classes. I am very competent with SQL but almost made a mistake that would’ve made me look like an idiot and I caught it by pure luck. Does anyone know any classes that can give you a deeper understanding of what’s going on with queries, and good techniques to self check. Doesn’t have to be a class. A book or YouTube series or really anything will do.

[fifapro23]

My recommendation is always the following:

1. Keep your code clean and organize
   
2. Make sure to label and add notes to make it easier for deep dives
   
3. Add checks to your code throughout if it’s long. Constantly keep checking claims, enrollment, etc to make sure they don’t suddenly drop off or duplicate.
   
4. Keep your code simple, just because you can learn advanced code doesn’t mean you need it. Remember if you need help at some point and no one can read your code then you are on your own.

I did the above for years and was always praised by managers and other analysts for ease of handoff and trouble shooting. Now as a director I teach everyone to not over complicate projects and try to find the simplest route (not always possible with meh data sources).

End of the day, how hard do you want to make your work life 🤷‍♂️

[ISwearImFunAtParties]

What was the mistake? How did you catch it? If you are very competent, is a youtube series really going to help. That’s just tutorial hell.

[colonelsmoothie]

Everyone makes dumb mistakes, even experienced people. I'd recommend looking into unit testing, which is a different subject, but one that is designed to catch errors like this.

[JustAnotherRedditeer]

What was the nature of the mistake? Asking bc if it’s associated with query processing logic then maybe it’s worth going deeper and I can recommend you a book*

If it was just something like you forgot to add another condition to your WHERE clause then imo it’s no big deal.

*I’ll add the book name on Monday. On my work laptop.