- DBMS
- database management systems
Features of DBMS:
- Easy management large amount of data
- Secure
- Backups
- Import/Export Data
- Concurrency
- Interact with software application
The stuff you mostly do with database:
C.R.U.D
- Create
- Read
- Update
- Delete
Two big categories of DBMS-es:
- relational - data ordered in tables
- non-relational - data not ordered in tables
- RDBMS
- Relational DBMS
RDBMS in the market:
- MySQL
- Postgres
- Oracle
- Microsoft SQL Server
- MariaDB
- SQLite
What is SQL?
- The language to interact with rdbms.
- Used to perform CRUD.
- Used to define tables and structures.
What is a query?
request made to the dbms for info.