BootCamp by Dr.Angela
1. Databases Explained: SQL vs NoSQL
- Why Do We Need Databases?
- Databases provide persistent data storage.
- Unlike variables in memory, data stored in a database remains available even after the application stops running.
- Databases allow applications to store, retrieve, update, and manage large amounts of information efficiently.
- Types of Databases
- SQL(Structured Query Language) Databases : typically relational databases, where data is organized into tables with predefined schemas.
- Structured data, Fixed schema, Relationships between tables, Strong consistency, Uses SQL for querying
- ex) PostgreSQL, MySQL, Oracle Database, SQLite, ...
- NoSQL Databases : designed for flexibility and scalability.
- Flexible schema, Horizontal scalability, Suitable for large-scale or rapidly changing data, Multiple data models (document, key-value, graph, etc.)
- ex) MongoDB, Redis, Amazon DynamoDB