From the course: MySQL for Non-Programmers

What’s a database? - MySQL Tutorial

From the course: MySQL for Non-Programmers

Start my 1-month free trial Buy for my team

What’s a database?

“

- [Instructor] To effectively run about any program you need to store data. Data is stored in order to retrieve it later and view, edit, and otherwise manipulate it. One of the best examples of data storage is a file system. Other storage types include databases, optical drives, flash drives, spreadsheets, et cetera. A database is an electronic system of holding data, like store inventory or contact information typically organized into tables where columns identify the type of data stored. For example, if it is contact information, one of the columns would be first name and the rows indicate the actual data. This kind of database is called a relational database. Relational database is the most popular form of database used today. The data is organized and accessed using a database management system or DBMS. Examples of popular DBMSs are relational database management systems, RDBMSs, like SQL Server, Oracle, and of course MySQL. RDBMSs use structured query language or SQL in order to query and/or update the data stored in databases. An example of SQL query is selecting all columns from the contact table that is storing contact information. I recommend viewing the course SQL for Non-programmers. Databases are used for storing your data. RDBMSs are used to organize your data into tables and access the data stored there through SQL.

Contents