Skip to content

Postgresql Indexing Strategies vs SQL Window Functions Cheatsheet

Compare these two topics side by side to decide which to study first โ€” or tackle both!

๐Ÿ“š

Postgresql Indexing Strategies

Databases

120

Cards

~60m

Study time

Advanced

Difficulty

Sample questions

  • โ–ธWhat is an index in PostgreSQL?
  • โ–ธWhat is a B-tree index in PostgreSQL?
  • โ–ธWhich index access method is the default in PostgreSQL?
  • โ–ธWhat index types does PostgreSQL ship with for general use?
  • โ–ธWhat is the main trade-off of any index?
Study Postgresql Indexing Strategies โ†’
๐Ÿ“š

SQL Window Functions Cheatsheet

Databases

223

Cards

~112m

Study time

Advanced

Difficulty

Sample questions

  • โ–ธRunning total of <i>amount</i> by <i>user_id</i> ordered by <i>ts</i>?
  • โ–ธDifference between ROW_NUMBER, RANK, DENSE_RANK?
  • โ–ธTop N rows per group?
  • โ–ธPrevious row's value in same partition?
  • โ–ธNext row's value?
Study SQL Window Functions Cheatsheet โ†’

๐Ÿค” Which should you study first?

Both topics are in the Databases category, so they complement each other well. We suggest starting with the smaller deck to build momentum:

Postgresql Indexing Strategies

120 cards ยท ~60 min ยท Advanced

โญ Quicker to complete

SQL Window Functions Cheatsheet

223 cards ยท ~112 min ยท Advanced

๐Ÿ“Š More comparisons