Blog

Your dream job? Lets Git IT.
Interactive technical interview preparation platform designed for modern developers.

XGitHub

Platform

  • Categories

Resources

  • Blog
  • About the app
  • FAQ
  • Feedback

Legal

  • Privacy Policy
  • Terms of Service

© 2025 LetsGit.IT. All rights reserved.

LetsGit.IT/Categories/Databases
Databasesmedium

SQL vs NoSQL?

Tags
#sql#nosql#comparison#database-type
Back to categoryPractice quiz

Answer

SQL databases are relational with fixed schemas, joins and strong ACID transactions. NoSQL databases are non‑relational (document, key‑value, column, graph), often with flexible schemas and easier horizontal scaling, sometimes trading strict consistency for availability/performance.

Related questions

Databases
Why can `LIKE '%term%'` be slow and what are common alternatives?
#sql#like#indexes
Databases
SQL NULL: why is `col = NULL` not true and what should you use?
#sql#null#three-valued-logic
Databases
Why is `SELECT *` risky in production queries?
#sql#best-practices#performance
Databases
What is a window function in SQL and a typical use case?
#sql#window-functions#row_number
Databases
GROUP BY vs HAVING — what’s the difference?
#sql#group-by#having
Databases
INNER JOIN vs LEFT JOIN — what’s the difference?
#sql#join#inner-join