Skip to content

PostgreSQL

SQL
MIDDLE
Tested skills
Duration
53 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of SQL, PostgreSQL

Code gaps

assessing knowledge of PostgreSQL, SQL

Task - Level: Medium

SQL | PostgreSQL | Music Store | Time function - Calculate the duration of all songs in each cd and output a list.

SQL
JUNIOR
Tested skills
Duration
26 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of Logical thinking, SQL

Code gaps

assessing knowledge of SQL

Task - Level: Easy

SQL | PostgreSQL | Hotels - average prices - Prepare the report with the average prices in the cities.

SQL
JUNIOR
Tested skills
Duration
27 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of Logical thinking, SQL

Code gaps

assessing knowledge of SQL

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.

SQL
SENIOR
Tested skills
Duration
52 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of Logical thinking, SQL

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.

Java
MIDDLE
Tested skills
Duration
57 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of Java, Spring Boot

Code gaps

assessing knowledge of PostgreSQL, SQL

Programming task - Level: Medium

Java | Spring Boot | Items Retriever Microservice - Implement a microservice to retrieve items from the shopping system.

PostgreSQL
MIDDLE
Tested skills
Duration
44 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of SQL

Code gaps

assessing knowledge of SQL

Task - Level: Medium

SQL | PostgreSQL | Hotels - hotels page optimization - Improve the performance of the the hotels listing page which currently uses ORM.

MongoDB
MIDDLE
Tested skills
Duration
51 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of SQL, MongoDB, NoSQL

Code gaps

assessing knowledge of MongoDB

Task - Level: Medium

SQL | Customer Data - Find all the customers whose first and last names are not unique in this database, as well as the number of times each first and last name pair appears in the database.

SQL
MIDDLE
Tested skills
Duration
40 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of SQL, MySQL

Task - Level: Medium

SQL | Customer Data - Find all the customers whose first and last names are not unique in this database, as well as the number of times each first and last name pair appears in the database.