Data Engineer

What types of JOINs do you know? Tell 2-3 main ones.

What is GIL (Global Interpreter Lock) and how does it work in Python?

How to apply a function to all rows or elements in pandas?

How does Greenplum differ from PostgreSQL?

What is the difference between WHERE and HAVING in SQL?

Чем отличается EXPLAIN ANALYZE от обычного EXPLAIN? Почему его нежелательно запускать на DELETE/UPDATE запросах?