What databases have you worked with and what SQL queries can you write?

Worked with relational databases such as PostgreSQL and MySQL, as well as with NoSQL solutions like MongoDB.

I can write SQL queries for:

• data selection (SELECT with JOIN, WHERE, GROUP BY, HAVING, ORDER BY)
• insertion (INSERT)
• updating (UPDATE)
• deletion (DELETE)
• creating and modifying tables (CREATE TABLE, ALTER TABLE)
• using subqueries and window functions

Example of a simple query to select users over 18 years old:

SELECT id, name, email FROM users WHERE age > 18 ORDER BY name ASC;

In Go, I usually use the database/sql package with drivers for database connection and write queries manually or with ORM, such as GORM.