Medium-hard SQL interview questions (quip.com)

Article summary

The article appears to be a study guide for medium-hard SQL interview questions, focusing on self-joins and window functions. The author shares a Quip doc with SQL problems and invites feedback. The discussion reveals that the guide aims to fill a gap in available resources for SQL interview prep. The resource is intended for analytics and product/business purposes, rather than system monitoring.

Main themes

• SQL interview prep
• Declarative vs Imperative languages
• Database management systems
• Query performance and optimization
• Testing and debugging
• Locking and concurrency

What commenters say

• Some commenters find Leetcode's SQL problems useful for interview prep, but others think they are hit-or-miss without curation.
• Adding analysis or explanations to the problems would make the study guide more beneficial.
• Locking and concurrency topics are considered important but tricky to recreate in a local test environment.
• Declarative languages like SQL can be challenging to understand, but proficiency comes with time and practice.
• Some argue that declarative languages are more efficient, while others prefer imperative approaches for finer control.
• Tests should focus on user intent and expectations rather than implementation details.
• The choice of database management system and configuration can significantly impact query performance and behavior.