Exploring Backend

Node js

Node Js is not a programming language, It is a javascript runtime which runs on the server side. It provides an event driven, non-blocking(asynchronous) input-output and cross-platform runtime environment for building highly scalable server-side applications using javascript.

SQL and Nosql database

Differences between sql and nosql database:
SQL database relational database, NoSQL database is non-relational
SQL database uses structured query language and it has predefined schema, NoSQL database has dynamic schemas for unstructured data.
SQL databases are vertically scalable, NoSQL databases are horizontally scalable.
SQL databases are better for multi-row transaction, NoSQL databases are better for unstructured data documents or JSON

Relational Database

A relational database is a collection of data items with pre-defined relationships between them. RDMS tables with columns and rows. Tables are used to hold information about the objects to be represented in the database. Each column in a table holds a certain kind of data and a field stores the actual value of an attribute. The rows in the table represent a collection of related values of one object or entity. Each row in a table could be marked with a unique identifier called a primary key, and rows among multiple tables can be made related using foreign keys. This data can be accessed in many different ways without reorganizing the database tables themselves.

Express js

Express. js is a Node. js web application server framework, designed for building single-page, multi-page, and hybrid web applications. Express is a node js framework that makes using node js easy. It helps to navigate routes so easily that we can run all the data easily. Express gives us different types of middleware to integrate with json data and make node file module systems easy.

CRUD Operation

CRUD stands for Create, Read, Update, and Delete, which are four primitive database operations. This operation is most frequently used.

Create: Create operation makes new data in database.
Read : This data is visible to the website view. Use pagination, sorting and filtering to navigate big lists
Update: This operation helps to update an existing data in the database and sometimes creates new one.
Delete: Delete operation removes data from the database.