Standard Naming Conventions for SQL Database Design
Naming Conventions is an important factors for any type of database design. It’s benefits are high. It makes a simple database generic for others. This article describes what standard should …
Category: MySQL
Difference Between Primary Key and Unique Key
In relational database system primary key and unique key are two important concepts. Both are used to uniquely identify a row in a table. Though both can identify a row …
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 …
MySQL Interview Questions with Answers
MySQL is the most famous relational database management system. It is open source. Here is some common important question and answer in MySQL. Hope it will help you to build …
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 …
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 …
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 …
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) …
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 …
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 …
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 …