Database Management System
DBMS (Database Management System) is a database program for creating and maintaining a database on a computer.
MySQL, PostgreSQL, Microsoft Access, Oracle, Microsoft SQL Server, DB2 and Sybase are some of the popular DBMS software.
Relational Databases store data or information in separate tables, that are related through the use of a common column.
A table stores refers to a two-dimensional representation of data using rows and columns.
The row/tuple/record is the horizontal subset of table that is a collection of data about one particular person, place or thing.
The column/attribute/field is the vertical subset of table that has a unique name and stores the content of the same type.
A primary key is a field in a table that has unique value for each record. Its purpose is to uniquely identify each record in a table.
A candidate key is an attribute (or set of attributes) that uniquely identifies a row. A table may have multiple candidate keys, but only one primary key.
Only one of the candidate keys is selected as a primary key for a table. All other candidate keys are called alternate keys.
Introduction to MySQL
MySQL is a relational database management system (RDBMS). It was originally founded and developed in Sweden by David Axmark, Allan Larsson and Michael Widenius.
Characteristics of MySQL
- MySQL is released under an open-source license.
- It is fast, easy to use, and reliable.
- Uses standard form of the ANSI-SQL standards.
- It is platform independent.
- MySQL is also easy to install, and it can handle large data sets.
You can download MySQL from here. Choose your platform and download the MySQL Community Server setup.
You can access the installation instruction from here.
During installation, you’ll be prompted to set the password for MySQL. Enter a suitable password and remember it because it will be needed every time you login into MySQL.
The command to login to MySQL:
mysql -h localhost -u username -p password
In the above command,
username is referring to the username in your MySQL system, and
password is referring to the password that you provided for that particular username.
The command to exit from MySQL: