A database is systematically organized storage of information, and it allows easy insertion, updating, analysis, and retrieval of data.
A database can be defined as a collection of a coherent, meaningful set of data. The term - 'collection of coherent data needs to have a point of reference to be understood. A simple point of reference would be the example of postal address, which usually contains:
- Building name
- Flat number
- Road name
- State name
- Pin code
- Country name
SQL is a standard database programming language used for accessing and manipulating data in a database. SQL is used by many databases like MySQL, Oracle, SQL Server, PostgreSQL, etc.
There are lots of different database systems, or DBMS (Database Management Systems), such as:
- Microsoft SQL Server
- Enterprise, Developer versions, etc.
- Express version is free of charge
- Oracle database
- MySQL (Oracle, earlier name as Sun Microsystems) - MySQL is used for free of charge (open source license); examples of those websites that use MySQL are YouTube, Wikipedia, Facebook
- Microsoft Access
- IBM DB2