1) Choice questions – assessing knowledge of Math, Probability, Soft Skills, SQL

2) Code gaps – assessing knowledge of MySQL, SQL

3) Task [level: Medium] – SQL | MySQL | Software House | Devs and their projects – The Head of the development team assigned you a task to create a list of developers with their role in the ongoing projects.

The post Middle Database Developer | MySQL | Devs and their projects appeared first on .

1) Choice questions – assessing knowledge of JavaScript, Node.JS

2) Code gaps – assessing knowledge of JavaScript, Node.JS, SQL

3) Programming task [level: Medium] – Node.JS | Rest API | News backend service – Implement a news backend service created in Node.JS with Vanilla JS including writing authorization and Rest APIs.

The post Middle Node.JS Developer | JavaScript, Rest API, SQL | News backend service appeared first on .

1) Choice questions – assessing knowledge of Logical thinking, Math, MySQL, SQL

2) Code gaps – assessing knowledge of SQL

3) Task [level: Easy] – SQL | MySQL | Stamps catalogue | AVG Function – Select the stamps (name and price) with price greater than or equal to the total average price.

The post Junior SQL Developer | MySQL | AVG Function appeared first on .

1) Choice questions – assessing knowledge of Logical thinking, SQL, MySQL

2) Code gaps – assessing knowledge of MySQL, SQL

3) Task [level: Easy] – SQL | MySQL | Stamps catalogue | A Self JOIN – Select stamps (name and location) that are in the same location.

The post Junior SQL Developer | MySQL | A Self JOIN appeared first on .

1) Choice questions – assessing knowledge of SQL, PostgreSQL

2) Code gaps – assessing knowledge of PostgreSQL, SQL

3) Task [level: Medium] – SQL | PostgreSQL | Music Store | Time function – Calculate the duration of all songs in each cd and output a list.

The post Middle SQL Developer | PostgreSQL | Music Store | Time Function appeared first on .

1) Choice questions – assessing knowledge of Logical thinking, SQL

2) Code gaps – assessing knowledge of SQL

3) Task [level: Easy] – SQL | PostgreSQL | Hotels – average prices – Prepare the report with the average prices in the cities.

The post Junior SQL Developer | PostgreSQL | Hotels – average prices appeared first on .

1) Choice questions – assessing knowledge of Logical thinking, SQL

2) Code gaps – assessing knowledge of SQL

3) Task [level: Easy] – SQL | PostgreSQL | Hotels – bookings – Prepare the booking list with a number of days, price per day and total price of the stay.

The post Junior SQL Developer | PostgreSQL | Hotels – bookings appeared first on .

1) Choice questions – assessing knowledge of Logical thinking, SQL

2) Task [level: Hard] – SQL | PostgreSQL | Hotels – cities and top hotels – Prepare a list of cities with the date of last reservation and a main photo (photos[0]) of the most popular (by number of bookings) hotel in this city.

The post Senior SQL Developer | PostgreSQL | Hotels – cities and top hotels appeared first on .

1) Choice questions – assessing knowledge of DevOps, Terraform, AWS

2) Code gaps – assessing knowledge of DevOps, Terraform, AWS

3) Programming task [level: Easy] – DevOps | Terraform, AWS | Create the EC2 instance using specific AMI – Create the EC2 instance using specific AMI in a default VPC with SSH access, using Terraform and AWS provider.

The post Junior DevOps Engineer | Terraform, AWS | Create the EC2 instance using specific AMI appeared first on .

1) Choice questions – assessing knowledge of Java, Spring Boot

2) Code gaps – assessing knowledge of PostgreSQL, SQL

3) Programming task [level: Medium] – Java | Spring Boot | Items Retriever Microservice – Implement a microservice to retrieve items from the shopping system.

The post Middle Java Spring Boot Developer | PostreSQL | Items Retriever Microservice appeared first on .