What is Data Quality?

Post author:nitendratech
Post category:Database
Post comments:4 Comments
Post published:November 22, 2018

Managing Data quality is one of the important aspect in a IT company.Accurate,consistent and timely available quality data in the relational database that organization use are essential to the management of organization today.

What is Database Normalization?

Post author:nitendratech
Post category:Database
Post comments:1 Comment
Post published:November 15, 2018

Normalization is the process of successively reducing relations with anomalies to produce smaller, well-structured relations.This blog post contains tutorials for database normalizations and First Normal Form, Second Normal Form, Third Normal Form, BCNF and Fourth Normal Form

What is Slowly Changing Dimensions?

Post author:nitendratech
Post category:Database
Post comments:2 Comments
Post published:November 10, 2018

A Slowly Changing Dimension is a dimension that stores and manages both current and historical data over time in a data warehouse.

What are Joins in SQL?

Post author:nitendratech
Post category:Database
Post comments:1 Comment
Post published:September 16, 2018

SQL join and Unions are the most common techniques in combining data data from two or more tables.

What is Enterprise Data Warehouse(EDW)?

Post author:nitendratech
Post category:Database
Post comments:9 Comments
Post published:July 7, 2018

An Enterprise data warehouse usually contains historical data that is derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables a business to consolidate data from several sources.

What is an ACID property in the Database?

Post author:nitendratech
Post category:Database
Post comments:9 Comments
Post published:June 11, 2018

In a relational database, multiple transactions are used in SQL (Structured Query Language) which can be one or multiple statements. A transaction is a single logical unit in which database…

What is Structured Query Language(SQL)? Definitions of SQL

Post author:nitendratech
Post category:Database
Post comments:31 Comments
Post published:April 18, 2018

SQL or Structured Query Language is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS). It provides various ways of manipulating and creating…

Most Useful Database Queries

Post author:nitendratech
Post category:Database
Post comments:1 Comment
Post published:December 14, 2017

A query is a request for data or information from a database table or combination of tables. This data may be generated as results returned by Structured Query Language (SQL) or as pictorials, graphs or complex results, e.g., trend analyses from data-mining tools.This blog post gives an introduction to some of the useful database queries.

What is a Relational Database Management System(RDBMS)? Definitions and Types

Post author:nitendratech
Post category:Database
Post comments:23 Comments
Post published:October 18, 2017

Relational database is a computer-software application that interacts with end-users, other applications, and the database itself to capture and analyze data. A general-purpose DBMS allows the definition, creation, querying, update, and administration of databases.

What is a Database and Why it is Important? Facts and Types

Post author:nitendratech
Post category:Database
Post comments:25 Comments
Post published:October 1, 2017

What is Data? Before we learn about databases, we need to first understand what data is. Data is information or facts related to an object that is under consideration. In…