What is the best database to use for teaching a beginner?

Question

Java

Main programming language: Java

Answer 1

If you do not delve into the context of using the database, then absolutely any. PostgreSQL flashes more often than others in vacancies.

Answer 2

Start with SQLite
When you move to Linux and/or start doing some serious stuff - PostgreSQL

Answer 3

Basically all lessons are done with mysql. But in the future it is impossible to stop only on it.

Answer 4

H2 database
1. Written in java and easily integrated as an external, or Embedded, or Memory database;
2. Supports many dialects;
3. Ease of creation;
4. Convenience of archiving (it is enough to archive the directory where the database is located);
5. Ease of portability, you can transfer the directory.
Of the minuses: if you change the version of the H2 Database library, be prepared to recreate the databases.

Answer 5

It seems to me that it is better to learn from the database that is often used in real solutions, since learning "on the table" is also not the best. In addition, the database should be closer to the standards and to the "big brothers" - paid DBMS. And here, in fact, even options are not visible - PostgreSQL. It is actually used in combat systems, at least it is one of those used in Yandex (besides it, only self-written NewSQL is used there)! In terms of SQL standard coverage, it is ahead of the same MSSQL. The threshold for entering it is only a little higher than in MySQL, but the knowledge gained will be much more valuable!
And yes - MySQL and SQLite will be a little simpler, but this simplicity is due to a departure from the standards or cutting back on certain features. That is, for greater ease of learning, you will pay with more limited knowledge, much like the greater complexity of retraining to any other database.

Answer 6

Well, I'll join. In fact, by default, any JDK comes with an embedded Apache Derby (Java DB) database, SQL compatible with DB2. It can work both in the server version and in the built-in version. I recommend starting with it.
https://ru.wikipedia.org/wiki/Apache_Derby
Why with her? It's already there, it's simple, it's SQL, it works.