What database should I learn first?

Question

MySQL and PostgreSQL are the leaders from the open-source and free database. If we talk about commercial databases Oracle is gaining popularity. In NoSQL databases, MongoDB, Redis, and Cassandra are the leaders. Depending on the project requirements industries are using it. 19 февр. 2021 г.

Which database should I learn as a beginner?

SQLite is the easiest database for beginners to learn. It is a powerful relational database management system (RDBMS) with a light and easy design. It is also the simplest database, that is perfect for practicing joins and simple queries.

What should I learn first SQL or MySQL?

Should I learn SQL or MySQL? To work on any database management system you are required to learn the standard query language or SQL. Therefore, it is better to first learn the language and then understand the fundamentals of the RDBMS.

What should I learn first SQL or NoSQL?

Without knowing SQL/RDBMS you will not fully appreciate the pros/cons of these “alternatives”. In addition many so called NoSQL databases are “hybrids” that incorporate some features of both approaches - and these databases usually offer SQL anyway. So, definitely SQL first.

Should I learn SQL or Python first?

You should learn Python fundamentals first, then add some SQL to that and how to manipulate SQL with Python and then follow it up with some R and see how you can intermix all three. I'd go with SQL first (it's easy and you can call it from python and R).

Expert · Answer