BeginnerSQL Fundamentals
Your progress · 15 questions0%
15
Questions
0
Completed
0
To review
0
Favorites
Topics in recommended order
Learning path
Follow the stages top to bottom. Nothing is locked — the order is simply what works.
SQL Fundamentals
5 questionsBeginnerSQL Fundamentals
What's the difference between a primary key, foreign key, unique constraint, and index?
Not practiced yetPractice thisIntermediateSQL Fundamentals
How do INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN differ?
Not practiced yetPractice thisIntermediateSQL Fundamentals
What is normalization (1NF, 2NF, 3NF) and when would you denormalize?
Not practiced yetPractice thisBeginnerSQL Fundamentals
When do you choose SQL vs NoSQL?
Not practiced yetPractice thisTransactions
5 questionsBeginnerTransactions
What does ACID mean in databases?
Not practiced yetPractice thisIntermediateTransactions
What are transaction isolation levels and which anomalies do they prevent?
Not practiced yetPractice thisIntermediateTransactions
What's the difference between optimistic and pessimistic locking?
Not practiced yetPractice thisAdvancedTransactions
What is MVCC and how does it let readers and writers coexist?
Not practiced yetPractice thisIntermediateTransactions
What causes deadlocks and how do you prevent and handle them?
Not practiced yetPractice thisPerformance
5 questionsIntermediatePerformance
How do database indexes work and what are their trade-offs?
Not practiced yetPractice thisIntermediatePerformance
How do you diagnose and fix a slow SQL query?
Not practiced yetPractice thisIntermediatePerformance
What is the N+1 query problem and how do you fix it?
Not practiced yetPractice thisBeginnerPerformance
What is connection pooling and why does it matter?
Not practiced yetPractice thisAdvancedPerformance