Greetings
Here, I learn Database.
database intro - medium.com
mysql download, there are a lot, maybe useful
Imagine you are managing a library, let's list systematically.
Core:
I.
Data, like each book name
Database(DB), a place to put these book name
Database Manage System(DBMS), the way to put these book name systematically,
or software to manage these book name, like MySQL, PostgreSQL and SQLite, a DBMS can manage multiple kind of database.
II.
There are two kind of database, SQL and NoSQL, The main different between them is the flexibility.
Which means, the SQL use fixed table structure, more standardized, and the NoSQL are not.
And there also have multiple kind of DBMS, like RDBMS(Relational Database Management Systems),
HDBS(Hierarchical Database Systems), NDBS(Network Database Systems), OODBS(Object-Oriented Database Systems),
NSQL-DBS(NoSQL Database Systems).
III.
Whatever which way I choosed, the SQL(structured query language) is classical in all way.
Let's meet the CRUD (basic four operations)
Create: INSERT INTO books VALUES ('LudvikoDatabase', 'Schneelein');
Read: SELECT * FROM books WHERE author = 'Schneelein';
Update: UPDATE books SET title = 'IntroDatabase' WHERE id = 1;
Delete: DELETE FROM books WHERE id = 1;