What databases have you worked with?

In the work of a systems analyst, it is often necessary to interact with different types of databases, including:

• Relational databases (SQL): PostgreSQL, MySQL, Microsoft SQL Server, Oracle Database. Used for storing structured data with a clear schema.
• Document-oriented databases (NoSQL): MongoDB, CouchDB. Suitable for flexible schemas and storing JSON-like documents.
• Columnar databases: Apache Cassandra, ClickHouse. Effective for analytics and large volumes of data.
• Graph databases: Neo4j, JanusGraph. Used for modeling and analyzing complex relationships.

Experience with specific databases depends on the project, but knowledge of the main principles and capabilities of different types of databases helps to analyze and design systems effectively.