Posts

Showing posts from November, 2021

SQL VS NOSQL

Image
SQL   is a standard language for storing, manipulating and retrieving data in databases. SQL is used to communicate with a database. SQL is an easy-to-learn language specifically designed to work with databases. The biggest decision while you choosing a database to which one to select Relational Database you have to select or Non-Relational Database you have to select. Which the database are more capable of becoming actual or useful. Users or Developer must keep in mind while choosing Database. Key Highlights - SQL RDBMS (Relational Database Management System) SQL Database contains predefined schema/fixed schema/static schema Its not compatible for Tree (Hierarchical) based Data Storage. SQL is more suitable for Complex queries. SQL is vertically Scable (Which means that you can increase the load on a single server by increasing components like RAM, SSD, or CPU) This Database follows the ACID Property (Atomicity, Consistency, Isolation and Durability.) Key Highlights - NoSQL Non-Relati