How Do I Get Started with Learning Databases?

Don't stress too much about the terms right now; they will make more sense as you get into it. SQL is the language you'll be using for most relational databases, and while MongoDB is a good alternative, it's more niche. I recommend you check out some YouTube tutorials on MySQL or MariaDB to ease into it, especially if you're dealing with relational data.

A good way to get into databases is to think about creating a project that requires one. MySQL is definitely one of the easiest ones to start with. Try building a simple application where you can manage and store some data. It's a practical way to learn and make it less overwhelming!

I suggest starting with SQL and using SQLite for tutorials. It's straightforward and covers the basics really well, including how to install and run queries on a sample database. Once you're comfortable with that, look into designing database schemas and get familiar with concepts like normalization and primary/foreign keys. From there, MySQL and PostgreSQL will feel more manageable since they share many features. Hold off on exploring NoSQL databases until you see a specific need for them.

When it comes to learning databases, it's all about what you want to do with them. Every programming language can connect to a database for storing information. I recommend starting with an SQL-based database since it's widely used. Check out 'A Manga Guide to Databases'—it’s surprisingly helpful! Also, instead of focusing solely on learning databases, think about creating projects that combine front-end and database knowledge to make it engaging.

If you're just starting, focus on SQL databases first. MySQL and PostgreSQL are great to study. Make sure you understand data management concepts and relationships, like one-to-many interactions. Once you've got that down, start creating databases and querying the data using JOINS. There are sample databases available online which can really help with practical learning—no need for Python right off the bat since SQL can pretty much stand alone.