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)…
How to Improve Data Quality in an Organization?
As data is frequently updated within an organization, achieving quality data requires constant monitoring and measurement as well as improvement actions. In addition to defect correction for quality data, it…
What is Entity and Table Relationship in Database?
When we design tables in a relational database, different tables can hold different information. This information is held in the form of an entity. So an entity can be defined…
What are Database Constraints?
Database Constraints are rules/restrictions that are applied to the database table columns to limit the type of data that can be persisted in a table. It provides a way to…
Enterprise Data Warehouse Layers
There are many layers in Enterprise Data warehouse(EDW) such as Integration/Semantic/Performance which serve their own purpose. In this blog post, we would go into detail about each of these layers.…
What is Metadata in a Data Warehouse?
Metadata is the information that describes other data or, simply, it is data about the data. It is the descriptive, administrative, and structural data that defines a firm’s data assets. It…
How to Run SQL Query Using Bash Script and Command-Line?
While working as a developer, one needs to automate some of the existing SQL Queries using bash script without accessing the interactive MySQL prompt. In this blog post i will show the different ways to run sql queries using Bash Script.I will be using MySQL database in this Blog.
Analyze retail DB using Structured Query Language(SQL)
In this blog post we will load the retail data into MySQL instance and analyze it using Structured Query Language.SQL is one of the most popular languages among developers,data engineers,data scientists and DBAs.