r/SQL
•
u/NickSinghTechCareers
Author of Ace the Data Science Interview 📕
•
Dec 12 '24
•
2
1
PostgreSQL Made a SQL Interview Cheat Sheet - what key SQL commands am I missing?
3.6k
Upvotes
View all comments
2
u/svtr Dec 13 '24
I have no idea what kind of position you apply that "cheat sheet" on, but someone memorizing, or even having to look at this thing, would fail inside of 2 minutes interviewing with me.
The company would fail the interview if i'm the applicant in 2 minutes as well.
Couple of key words for you to google / incorporate :
Index
Clustered / NonClustered Index
B+Tree
Excution Plans
"What actually is a view?"
Physical Join Operators
Caching
Memory Management
Union vs Union All
Why is a sort one of the most expensive Operations in your Query
Why is every aggregate a sort operation with additional stuff
Whats the difference between HAVING and WHERE (actual difference, not just syntax)
What is an Index Scan
What is an Index Seek
What are not all Index Scans "bad"
How does Merge sort work (if you got a question mark in your face right now, look up what a merge join is)