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 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…
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 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…
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…
This blog post will explain some of the differences between SQL and NoSQL databases.
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.
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.
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…
SQL UNION combines the results of two or more queries into a single result set that includes all the rows that belong to all queries in the union. SELECT 1…
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)…