• 0

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

What is MySQL

MySQL is free and open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). MySQL was owned by Sun Micro Systems but currently owned by Oracle. It can be installed on the majority of available operating systems like Windows, CentOS, Ubuntu, Depian, etc…
With MySQL you can create and manage databases using SQL. MySQL is just one for many RDBMS available. Other examples are Microsoft SQL Server, Oracle and PostgreSQL. However MySQL is quite popular among web applications.

What is a Database

Database from its name means a center or base to store data in a structured way to be able to query and manipulate it in a speedy manner. Database consist of tables, tables is composed of columns and rows. Each row consist of fields corresponding to those columns. A database is mostly a relational database which means it is composed of tables related or linked together using “Primary keys” and “foreign keys”. Speaking in a little bit more detail, a primary key is a unique number (i.e. serial number) stored in a column in a table and optimized for high speed lookup. A foreign key is another number in a different table that each one of it matches a number from primary keys list mentioned earlier. This way a database engine can combine a table containing primary key and table containing foreign key by matching those keys together, which is called JOIN process. Speaking in terms on speed when correctly configured, a good database engine can combine a tables of millions of records in just a matter of few seconds.
relational database

What is SQL

SQL is a short for Structured Query Language which is according to ANSI (American National Standards Institute), it is the standard language for relational database management systems to to search, update, delete and insert data into a database in a highly optimized speed.

Leave a Reply

%d bloggers like this: