Skip to content

SQL Window Functions Cheatsheet vs Redis Data Structures & Use Cases

Compare these two topics side by side to decide which to study first — or tackle both!

📚

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 →
📚

Redis Data Structures & Use Cases

Databases

120

Cards

~60m

Study time

Advanced

Difficulty

Sample questions

  • ▸What does the acronym Redis stand for?
  • ▸In which language is Redis written?
  • ▸What is the default port number for Redis?
  • ▸How is Redis primarily classified architecturally?
  • ▸Which is the most basic Redis data type, storing a single binary-safe value per...
Study Redis Data Structures & Use Cases →

🤔 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:

SQL Window Functions Cheatsheet

223 cards · ~112 min · Advanced

Redis Data Structures & Use Cases

120 cards · ~60 min · Advanced

⭐ Quicker to complete

📊 More comparisons

VS Postgresql Performance Tuning vs SQL Window Functions Cheatsheet VS PostgreSQL Indexing Strategies vs SQL Window Functions Cheatsheet