Day 31 of #100DaysOfCode — SQL + NoSQL Basics

There are two methods for organizing a database: a structured approach using tables and rows, and an unstructured approach using collections and documents. The structured method employs SQL (Structured Query Language) , whereas the unstructured method is known as NoSQL (Not Only SQL) . On Day 31, I explored both methods for writing a database, understood the differences between them, and identified the use cases for each. Structured way (Tables and Rows) It is what is called a Relational Database — a way of organizing data into tables, where: Table → represents one entity (e.g., Users, Orders) Row → one record/entry in that table (e.g., one user) Column → an attribute/field (e.g. name, email, age) Cell → the actual value where a row and column intersect It looks exactly like a spreadsheet: id name email 1 John john@gmail.com 2 Saad saad@gmail.com 🔑 Key Concepts Schema — the overall structure/blueprint of all your tables Primary Key — a unique identifier for each row Foreign Key — a col