1. Understand How Data Stored in Tables
A database is an organized collection of structured information, or data, typically stored electronically in a computer system. … The data can then be easily accessed, managed, modified, updated, controlled, and organized. Most databases use structured query language (SQL) for writing and querying data.
The DBMS manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs. Some DBMS examples include MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBASE, Clipper, and FoxPro.
The correct way to see a database is like a folder. And in that folder, you have text files with information. In the case of a database, these files with information are actually the tables that contain data. So, the table is just like a file with text inside a folder.