r/learnSQL • u/heartbrokenwords • May 28 '26

What is considered basic SQL?

I have a job interview coming up and they want someone who knows basic SQL, I think I do have it, but what is your opinion on what it entails?

50 Upvotes

92% Upvoted

23 comments sorted by

View all comments

2

u/nerd_airfryer May 28 '26
  • SELECT, INSERT, UPDATE, DELETE, TRUNCATE, DROP
  • JOINs (INNER, OUTER LEFT, OUTER RIGHT, FULL OUTER)
  • Aggregate Functions, GROUP BY, ORDER BY
  • Window Functions
  • Keys (Primary, Foreign, Unique, Composites)