This directory is to house all the work I have to learn about databases.
See: https://trello.com/c/LRB6uZnF/282-consolidate-a-list-of-sandboxes for info on using repl.it It seems to have a database component.
| ? | NoSQL | SQL |
|---|---|---|
| ? | stores data as files. | Normalized - they store data in a tabular form, arranged in a table with rows and columns. |
| Paragraph | ? | Use of primary keys - tables each have a primary key identifier. In a non-relational database, data is normally stored in hierarchical or navigational form, without the use of primary keys. |
| Paragraph | Since a non-relational database stores data as files, there is no relationship between the data values. | Data values relationships - Since data in a relational database is stored in tables, the relationship between these data values is stored as well. |
| Paragraph | Non-relational databases do not use integrity constraints. | Integrity constraints. In a relational database, the integrity constraints are any constraint that ensures database integrity. They are defined for the purpose of atomicity, consistency, isolation and durability, or ACID. |
| ? | Non-relational databases are better for unstructured data, which doesn't conform to a predefined data model and can't be stored in an RDBMS. Examples of unstructured data include text, emails, photos, videos and web pages. | Structured vs. unstructured data. Relational databases work well for structured data that conforms to a predefined data model and doesn't change much. |
| ? | not only SQL | Structured Query Language |
| ? | ? | ? |
| ? | ? | ? |
| ? | ? | ? |
| ? | ? | ? |
| ? | ? | ? |
| ? | ? | ? |
Information regarding the directories and files in this directory.
Navigate back to the Learning Directory README.md file.
Navigate back to the Meta/ directory README.md file.
Non-relational (NoSQL) data structure.
Relational (SQL) data structure.
This readme file.