What is a Database? What is SQL? What is MySQL?

What is a Database? What is SQL? What is MySQL?

Among the things that are sometimes asked by new webmasters are “What is MySQL?”, “What is SQL” and “What is a database?”. These questions arise because such terms tend to surface all over the place in connection with the creation of a website.

What is a Database?

Database is a systematic collection of data. Databases support storage and  manipulation of data. Databases make data management easy. Let’s discuss few examples. An online telephone directory would definitely use database to store data pertaining to people, phone numbers, other contact details, etc. Your electricity service provider is obviously using a database to manage billing , client related issues, to handle fault data, etc. Let’s also consider the facebook. It needs to store, manipulate and present data related to members, their friends, member activities, messages, advertisements and lot more.

What is SQL? What is MySQL?

Structured Query language (SQL) is actually the standard language for dealing with Relational Databases. SQL programming can be effectively used to insert, search, update, delete database records.

That doesn’t mean SQL cannot do things beyond that. In fact it can do lot of things including, but not limited to, optimizing and maintenance of databases.

SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use.

MySQL is a database management system, like SQL Server, Oracle, Informix, Postgres, etc. MySQL is a RDMS (Relational Database Management System). MySQL is an essential part of almost every open source PHP application. Good examples for PHP & MySQL-based scripts are WordPress, Joomla, Magento and Drupal.