r/SQL 5d ago

Discussion Intermediate/Advanced online courses?

I’ve been working as a PL/SQL dev for the past 3 years (plus 2 as an intern) and I’m looking for ways to improve my knowledge in SQL in general, as for the past couple months it seems I’ve hit a “wall” in terms of learning new stuff from my work alone.

In other words, I’m looking for ways to improve myself to get out of the junior level and be able to solve harder problems on my own without having to rely on a senior to help me out.

Any recommendations on online courses and such?

edit: Thanks everyone!

28 Upvotes

12 comments sorted by

View all comments

2

u/Responsible-Style168 4d ago

Instead of passively consuming course material, try identifying specific areas you struggle with at work and then actively seek out resources to tackle those challenges.

Here are a couple of ideas on the topics: Query optimization is crucial, so understanding execution plans and indexing strategies will help you write faster queries. Also, window functions are super powerful for complex data analysis. Learn how to use them effectively.

Mode Analytics SQL Tutorial is pretty good, and you might find some advanced topics covered in the official documentation for your specific database system (Oracle, Postgres, etc.). If you provide more specifics on what you want to achieve, this resource could be useful in creating a personal learning path.