Python

Why is denormalization needed in a database?

How does memory management differ between threads and processes in Python?

Does caching at the database level speed up system response?

How does the process of code interpretation differ from its compilation?

Table Customers: customer_id (INT), customer_name (VARCHAR), country (VARCHAR), signup_date (DATE) Table Orders: order_id (INT), customer_id (INT), order_date (DATE), order_amount (DECIMAL), status (VARCHAR) Task: Write a query to find the total order amount and the total count of orders for each customer from the 'USA' who has spent a total of more than 500 on 'Completed' orders. Sort the results by total order amount in descending order. Expected Output: customer_name (VARCHAR), total_spent (DECIMAL), total_orders (INT)

Have you had experience performing your duties while working remotely?

Can you tell us how the team process and interaction were organized in your previous company?

Junior — Middle

TevianСБЕРМой Офис

What approaches and resources have you used to develop your programming skills?

How do the concepts of domain complexity and introduced complexity differ in system design?

What is your experience with using cloud platforms AWS or Azure in practice?

Were there tasks where you lacked knowledge and had to figure things out on the job?

In which areas of Python development do you consider yourself to be the strongest specialist?

Who is responsible for issuing and issuing SSL certificates?

Which work mode do you prefer: remote, hybrid, or office?

What deployment strategies exist for services?

How do you assess your level of responsibility at work?

Why are you searching? What are you currently looking for?

Как работает hash-индекс в PostgreSQL?

How is reliable message delivery ensured in Redis Pub/Sub system?

When is it necessary to use transactions to ensure data integrity?