The right database for your project depends your app needs, what you're comfy with, and the pros and cons of each choice.
For example, Postgres is solid but isn't built for write heavy workloads, while Cassandra is great for fault tolerance but needs tweaking for consistency.
Think of a database as a tool that handles data, letting you focus on your app's important parts.
SQL queries are the usual way to connect with databases.