Im interested in the topic because I want to learn on how to use databases.
NoSQL vs SQL. SQL VS NOSQL VIDEO. Mongoose API. React Router.
NoSQL(Not Only SQL). It’s a type of database system that is designed to handle large amounts of data and provide flexibility in storing and retrieving that data.
NoSQL allows you to store data in different formats unlike traditional databases (SQL).
In NoSQL you don’t have to define a specific structure in advance.
NoSQL databases are good at scaling. It distributes data across multiple servers, making it easier to handle the increased load.
SQL(Structured Query Language). Its a type of database system that uses a structured approach to store and organize data. Data is organized into tables, which are like grids with rows and columns. Each table has a predefined structure, meaning you need to define the columns and their data types before storing data.
SQL databases are good for applications where you need to maintain strict data consistency and integrity. They ensure that your data follows specific rules, and any changes to the data are carefully controlled.
SQL databases provide a standardized way to retrieve, insert, update, and delete data using the SQL language, which is widely supported and understood by developers.
In summary, NoSQL databases are flexible, scalable, and suitable for handling large amounts of rapidly changing data, while SQL databases have a structured approach, enforce data integrity, and are commonly used in applications where maintaining strict relationships and consistency is important.
SQL gives a way for us to not only select data from a database but also add data.
Ex. SELECT id,name,price FROM products (The bold are SQL Syntax and the rest are data/parameters)
The Database Structure: Its a relational database that works in certain ways.
They follow a Schema which outlines the fields, and records for our database.
All records have to follow this Schema.
Ex. Id, Name, Price, Description.
Each record have to follow this.
Usually with a database, you have multiple tables, which share relations.
Ex. User table, products table, orders table
The orders table would connect the relations for our tables.
Relational Databases allow us to connect different tables and use data in each.
Different types of relations are: One-To-One: One table to one table One-To-Many: One table to many Many-To-Many: Connects different tables from one center table.
I want to understand the differences between NoSQL and SQL more detailed.
How do you use databases in a daily project.
How important is having a database for a personal project.