MySQL Archive

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 uniquely but there is some difference between them. This article explains a comparison between primary key and unique key. Summary of the article: What is

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 different ways. But it is very important to choose an appropriate primary key. This article describes about the primary key and how to make a

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 successful carrier. What’s MySQL? MySQL is an open source SQL Database Management System. It is built, distributed, and supported by MySQL AB (Now Oracle Corporation). 

Standard Naming Conventions for 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 we follow when naming database, database naming standards. Summary of the article: What is Naming Convention for Database? Standard Naming Convention for Tables Standard Naming

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 describes about SQL views or creation of SQL views. Summary of the article: What is SQL View? How to create SQL View? How to Drop

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 rows from two or more tables. This article describes about SQL joins and what are the types of join in SQL. Summary of the article:

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 the creation of a database schema. Summary of the article: What is a Database Schema? How to create a Database Schema? What is a Database

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) to developed powerful and dynamic web applications. This article describes an introduction to MySQL database server. Summary of the article: What is MySQL History of

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 of the article: What is Database Object? What are the Types of Database Object? What is Database Object? A database object in a relational database

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 a RDBMS is? It also describes the basic overview of RDBMS. What is Relational Database Management System (RDMS)? Examples of RDMS What is Relational Database