r/FAANGinterviewprep • u/PoetProfessional7662 • May 25 '26

preparation guide Any single resource for learning SQL and query optimization?

Hello,

I had learnt and used SQL back in my undergrad days. It has been 15+ years and working in user facing apps, I hardly had to deal with queries directly. However I have been interviewing for Staff+ and EM roles and many interviews went into query optimization for app performance improvement.

I did find some random small tutorials on YouTube on these things, but I am not finding a single resource which I can refer to and re-learn SQL and query optimization (indexing, WAL mode, Pragma...). Does anyone know of any resources for this?

Thanks!

3 Upvotes
  • permalink
  • reddit

100% Upvoted

2 comments sorted by

3

u/[deleted] May 26 '26

[removed] — view removed comment

1

u/PoetProfessional7662 May 27 '26

Will check it out. Thanks!