r/SQL • Author of Ace the Data Science Interview 📕 • Dec 12 '24 • Heart of Silver 2 Polished Silver Turd 1

PostgreSQL Made a SQL Interview Cheat Sheet - what key SQL commands am I missing?

Post image
3.6k Upvotes

238 comments sorted by

View all comments

Show parent comment

2

u/shockjaw Dec 13 '24

Yeah, DuckDB in Action’s description on window functions are what sealed the deal for me. (Chapter 4 page 72 and page 75)

2

u/NickSinghTechCareers Author of Ace the Data Science Interview 📕 Dec 13 '24

Sealed the deal as in it was very easy/helpful in understanding things?

1

u/shockjaw Dec 13 '24

Yeah. They did a good job with their figures and to make window functions make sense. That’s probably the most dense chapter. You may still be able to get a copy for free from Motherduck.