Database

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
  • Sybase

Courses
Subscribe Updates via Email

Join 49,000+ W3schools lovers and get all the latest tutorials, programs, algorithms in your inbox.