Window functions, CTEs, indexing, transactions, and optimization
What is a Window Function in SQL?
What is the purpose of ROW_NUMBER() function?
What is the difference between ROW_NUMBER(), RANK(), and DENSE_RANK()?
What is a CTE (Common Table Expression)?
What is a recursive CTE used for?
What is an INDEX in SQL?
What is the difference between clustered and non-clustered indexes?
What is a transaction in SQL?
What does ACID stand for in database transactions?
What are the different isolation levels in SQL?
What is a deadlock in SQL?
What is the purpose of EXPLAIN / EXPLAIN ANALYZE?
What is a View in SQL?
What is a Stored Procedure?
What is a Trigger in SQL?
What is database sharding?
What is the N+1 query problem?
