🗃️
SQL & Database Interview Questions
90+ database interview questions covering SQL queries, NoSQL systems, and cutting-edge vector databases. Essential for any data-related role.
📊 90+ Questions ⏱️ ~20 hours of study 🏢 Asked at: Amazon, Google, Meta, Flipkart, Uber
1
SQL Queries
Joins, subqueries, window functions, CTEs, optimization, and advanced query patterns
Intermediate 50 Q
2
NoSQL & Firebase
MongoDB, Redis, Firebase Realtime DB, document modeling, when to use NoSQL
Intermediate 25 Q
3
Vector Databases
Pinecone, Weaviate, ChromaDB, embeddings storage, similarity search, RAG integration
Advanced 15 Q
💡 Study Tips for Databases
- • Practice writing queries by hand — many interviews are on whiteboard/paper
- • Master JOINs, Window Functions, and CTEs — these come up in 90% of interviews
- • Understand query execution plans and indexing strategies
- • Vector databases are increasingly asked in AI/ML interviews
- • Know when to choose SQL vs NoSQL — this is a common system design question