PostgreSQL

MIDDLE

Middle SQL Developer | PostgreSQL Music Store | Time Function

Tested skills

Middle SQL Developer | PostgreSQL Music Store | Time Function

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.

Talk to Sales

JUNIOR

Junior SQL Developer | PostgreSQL Hotels – average prices

Tested skills

Junior SQL Developer | PostgreSQL Hotels – average prices

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.

Talk to Sales

JUNIOR

Junior SQL Developer | PostgreSQL Hotels – bookings

Tested skills

Junior SQL Developer | PostgreSQL Hotels – bookings

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.

Talk to Sales

SENIOR

Senior SQL Developer | PostgreSQL Hotels – cities and top hotels

Tested skills