Database Basic Terms

This short article describes certain database terms that you would hear thrown around a lot if you work with software developers.

Computers make accessing data easy and faster, so storing information on computers is a no-brainer.

There are two types of databases in relation to your computer system:
1.⁠ ⁠SQL (STRUCTURED QUERY LANGUAGE) databases or Relational databases; which stores data in tables ( if you are familiar with Excel, it's sort of illustrates the data storage format ) and uses some form of SQL in data manipulation operations.
e.g MYSQL, POSTGRES

2.⁠ ⁠Non SQL or non relational databases ; a blanket term for databases that do not store information in a table format and does not use any for of SQL for querying data i.e, creating, reading, deleting or updating information on the database.
e.g MONGO DB

A database management system allows the user to interact with the databases. For CRUD ( create, read, update, delete ) operations If you have heard of POSTGRES, MYSQL, and MONGO DB, these are examples of database management systems.

Lastly you most probably are wondering what QUERYING is or what a database query is ?
Well a database query is the process of carrying out operations (usually but not limited to CRUD) in your database via your database management system.
This term is usually used with relational databases.

Keep an eye out. I would be sharing more on databases and other things relating to coding as I learn.