Databases

• Databases are crucial in Web Development or IT. They are responsible for holding sensitive information.

• You may ask, why do we not hold data in text files? The answer is simple, databases are designed for storing data securely. Text files or other types files not.

What does a Database look like?:

1. Databases = On the left we have databases. We can have databases for multiple projects or multiple purposes.

2. Tables = Tables are inside databases, this is where information is separated and stored in tables. We can have multiple tables.

   1. Users Table store user data

   2. Posts Table may store posts data that is posted by users (think of Social Media website)

3. Columns = Columns are inside Tables, this is where each column has it's own space and it's isolated from each other for storing data.

4. Records / Rows = This is our data, for example ->

   1. Id 1 is admin, [e-mail], with role 1 and is active = This is our 1st record