October 21, 2020

How to make a Great Primary Key?

The primary key is in important factor for any relational database. It plays a vital role. It has numerous functionalities. On a table we can create a primary key in …

Read More

SQL Views

In SQL, a View is a virtual table that is generated based on a SQL statement. It has no own data, but it returns data from others table. This article …

Read More

SQL Join

In a relational database, SQL join is a very important feature. SQL Joins are used to get data from other tables. It is a part of SQL query that retrieves …

Read More

What is Database Schema?

The database schema is the logical view of the entire database. It is a set of database objects (tables, views, functions etc.). This article describes about the database schema and …

Read More

MySQL

MySQL is the world’s most widely used open source database management software. For its cost effective and high performance features it is commonly used with many programming language (especially PHP) …

Read More

What is Database Object?

The database objects are the core component for any database system. This help use to store and retrieve data easily. This article describes about basic overview of Database Object . Summary …

Read More

Relational Database Management System or RDBMS

Relational Database Management System is computer software/program that is developed based on relational model. At present most modern commercial and open-source database systems are using RDMS. This article explains what …

Read More

Database Management System or DBMS

DBMS is the process to store and retrieve information. This article describes about the basic overview of  DBMS or Database Management System. Summary of the article: What is Database? What …

Read More