What is SQL Alias?
What does alias mean in SQL? SQL (Structured Query Language) aliases are used for giving a temporary name to a column or a table for the purpose of a particular…
What is Database View?
A database view is like a subset/snapshot of tables that are stored logically in a database. It is a virtual table that contains rows and columns similar to a real…
What are Database Indexes?
What is a Database Index in SQL? An index in the database is a data structure that has content that can point to the location of the data in the…
What is Polyglot Persistence?
Polyglot persistence is a concept in which multiple persistent technologies are considered for different requirements of an application instead of using RDBMS as a default choice. In 2006, Neal Ford…
Important difference between SQL and NoSQL Database
This blog post will explain some of the differences between SQL and NoSQL databases.
SQL SELECT Operator
SELECT operator in SQL is used to select data from a database. Returned data from the SELECT operation is stored in a result table called the result-set.
What is NoSQL Database? NoSQL Database Explained
Non Relational or NoSQL Databases is a data storage system that was designed for unstructured data which does not follows a ACID property like a traditional RDBMS.Many of the NoSQL database provides flexibility in consistency in favour of availability and partition tolerance as explained by CAP theorem.
Stored Procedure in Database
A stored procedure is defined as a group of SQL (Structured Query Language) statements or subroutines that are stored inside the relational database management system (RDBMS) that performs a particular…
What are SQL Unions?
SQL Stands for Structured Query Language(SQL). SQL UNION combines the results of two or more queries into a single result set in a database that includes all the rows that…
What is the CAP Theorem?
The CAP theorem is also known as Brewer's theorem. It states that it is impossible for a distributed computer system to simultaneously provide all three (Consistency, Availability, and Partition tolerance)…