Tell about your experience working with database management systems.

In my experience working with database management systems (DBMS), I have used both relational and non-relational databases. For example, I have worked with MySQL and PostgreSQL for storing structured data, writing SQL queries for data retrieval, updates, and deletions, as well as creating indexes to optimize performance.

I also have experience with MongoDB — a document-oriented database where data is stored in JSON-like documents. This is convenient for flexible data structures.

In the context of test automation, I wrote scripts to verify data correctness in the database, checked the integrity of relationships, and used transactions to test the atomicity of operations.

An example of a simple SQL query to select users over 18 years old:

SELECT * FROM users WHERE age > 18;