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…
Important Big Data Terms Everyone Should Know
When someone works with Big data, they need to have knowledge of many concepts and terms. I will introduce some of the important data terms everyone working with Big data should know.
Why Do Organizations Need Data Analysts?
The basic job of a data analyst is to collect, store, and analyze data and draw some insights from it. Size/Volume/Complexity of data depends upon the type of company/industry in…
Types of Table in Apache Hive
Apache Hive has mainly two types of tables: Managed and External tables. Managed Table: When hive creates managed (default) tables, it follows the "schema on read" principle and loads the…
What is Columnar Data Storage and its Types?
In recent modern Big Data applications, numerous databases (NoSQL) have introduced columnar data storage, which provides several benefits over traditional row-oriented databases. Many Hadoop vendors like Cloudera, Hortonworks, and MapR…
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…
Skills Needed For Data Scientist
By the name “Data Scientist” itself, one needs to understand and feel the data. For this, one needs a certain set of technical skills that will provide you with 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.