Core differences between relational and NoSQL databases including document, key value, and column family stores.
28 cards · basic cards · AI-written, checked twice. Edit anything.
- What does SQL stand for?
Show answer
Structured Query Language- What is a primary key in a relational database?
Show answer
A unique identifier that distinguishes each row from all others- What is normalization in database design?
Show answer
The process of organizing data to reduce redundancy and improve integrity- Name three common SQL commands
Show answer
SELECT, INSERT, UPDATE (also acceptable: DELETE, CREATE, DROP)- What is a foreign key?
Show answer
A column that references the primary key of another table- What does ACID stand for?
Show answer
Atomicity, Consistency, Isolation, Durability- What does a JOIN clause do in SQL?
Show answer
Combines rows from two or more tables based on a related column- What does NoSQL mean?
Show answer
Not Only SQL, a database approach that does not rely on relational tables- Name three main types of NoSQL databases
Show answer
Document stores, key-value stores, column family stores- What is schema-less storage?
Show answer
A database design where the structure of data does not need to be defined upfront- What is a document store database?
Show answer
A NoSQL database that stores data as documents, typically in JSON or BSON format- What is JSON in the context of document databases?
Show answer
JavaScript Object Notation, a text format for storing structured data with key-value pairs- Name a popular document database
Show answer
MongoDB- What is a collection in MongoDB?
Show answer
A group of documents, similar to a table in a relational database- How are nested data structures handled in document stores?
Show answer
Documents can contain nested objects and arrays directly, with no need to join separate tables
FlashKeepers