Python

Have you ever created and executed SQL queries during your work?

What is the difference between executing a separate thread and a full process in an operating system?

What methods can be used to improve the efficiency of SQL query execution?

What is the role of threads in Python and why are they used in software development?

What tools or methods allow monitoring the operation of RabbitMQ?

Explain the working principle of generators in Python and their main advantages

Junior — Middle

EvappsКриптонитArendadata+16

Is it possible to call synchronous operations inside an asynchronous function without errors or deadlocks?

Can you explain what an alias means in SQL and in what cases it is used?

Share your professional experience and skills that you believe are relevant for this position.

Intern — Junior

Black Wall GroupVisionLabsМой Офис+39

Can you explain the purpose and use of the iter object in SQLAlchemy?

Can you explain what is meant by the concept of a parent class in object-oriented programming?

Have you created your own mixins in your projects?

Can interfaces be used in Python and how is it implemented?

Do standard streams in Python ensure safety when working in multithreaded mode?

Have you had experience working with the SQLAlchemy Core library for database management?

How do Python versions 3.10 and 3.11 differ in features and capabilities?

What libraries or modules are available for data type validation in FastAPI?

What are the main components included in the HTTP protocol?

In what cases is it appropriate to apply multithreading in software applications?

What methods of data transfer from server to client do you know?