Connecting to Database

Database

Is an organized collection of structured information, or data, typically stored electronically in a computer system.

1. Business

2. Track Customers

3. Health Information

4. Personal Data

What are databases used for?

1. Relational

2. NoSQL Databases

3. Cloud Databases

Types of Databases

Relational

Are comprised of tables and data is placed into predefined categories in those tables.

NoSQL Databases

Databases that store data in non-tabular formats like JSON, key-value pairs, graphs, or documents. Designed for flexibility and scalability.

1. Documented-Oriented

2. Key-Value Store

3. Column-Family Store

4. Graph Database

Types of NoSQL

Document-Oriented

Stores data as documents (usually JSON or BSON).

Key-Value Store

Stores data as key-value pairs.

Column-Family Store

Stores data in columns rather than rows.

Graph Database

Stores relationships between data using nodes and edges.

Cloud Databases

Databases that are hosted on cloud platforms and accessible via the internet

MySQL

Is an open-source relational database management system (RDBMS) that stores data in structured tables using SQL (Structured Query Language).