You have already seen and used these things but make sure you grasp the words before you read the next few pages:
- a database management system (DBMS) is the program which handles databases for you (for example Microsoft Access)
- a database server is just a DBMS running over a network (you used MySQL or MariaDB )
- a database is a named collection of data which is connected in some way (maybe data about products, people and purchases on an e-commerce site)
- tables hold data about particular things known as entities (maybe a table for people, one for products and one recording each sale)
- in each table will be fields which are the specific information held (personal names, towns, product prices etc.)
- each table will hold a number of rows of data (each row holding information about one person or product - one thing, one record)
There are also some other vital concepts which you were not told about but you now need to know.