SQL

SQL online coding tests & interview questions

Data Science
JUNIOR
Tested skills
Duration
45 minutes max.
Evaluation
Automatic
Test overview

Task - Level: Easy

SQL | Stamps catalogue | The three highest prices - Select three stamps (price and name) with the highest price.

Programming task - Level: Easy

Python | Pandas | HTML table parser - Implement a function to convert HTML table into a CSV-format file.

Python
MIDDLE
Tested skills
Duration
120 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of Python

Programming task - Level: Medium

Python | Vehicle sales report - Implement an application to create reports based on the vehicle sales data warehouse.

DevOps
SENIOR
Tested skills
Duration
66 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of DevOps, Docker

DevOps task - Level: Hard

DevOps | Master of Disaster Recovery (CentOS) - Recover data from broken MariaDB/MySQL database.

DevOps
SENIOR
Tested skills
Duration
66 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of DevOps, Docker

DevOps task - Level: Hard

DevOps | Master of Disaster Recovery (Ubuntu) - Recover data from broken MariaDB/MySQL database.

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.

PHP
MIDDLE
Tested skills
Duration
60 minutes max.
Evaluation
Automatic
Test overview

Code gaps

assessing knowledge of SQL

Choice questions

assessing knowledge of ES6, JavaScript, CSS, HTML, WCAG 2.0, Web Accessibility

Programming task - Level: Medium

PHP | Categories Repository - Implement PDO queries that will return valid results about movies to users.

PHP
SENIOR
Tested skills
Duration
88 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of SQL, ES6, JavaScript, AJAX, Web development

Programming task - Level: Hard

PHP | XML-CSV Converter - Implement filtering and data transformation methods to pass all the tests.

PHP
JUNIOR
Tested skills
Duration
41 minutes max.
Evaluation
Automatic
Test overview

Code gaps

assessing knowledge of SQL, CSS, HTML

Choice questions

assessing knowledge of JavaScript

Programming task - Level: Easy

PHP | Faker | Basic data manipulation - Implement all the methods in the app/Faker class.

MongoDB
SENIOR
Tested skills
Duration
56 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of SQL, MongoDB, NoSQL

Code gaps

assessing knowledge of MongoDB

Task - Level: Hard

SQL | Fill sparse table - Write a query that will return the list of all users with the creation date and return the date from the previous not-null row for the entries affected with the bug.

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

Choice questions

assessing knowledge of SQL, MongoDB, NoSQL

Code gaps

assessing knowledge of MongoDB, SQL

Task - Level: Easy

SQL | Stamps catalogue | CASE statement - Make a select statement, by which you will divide your stamps collection into 3 groups.

NumPy
MIDDLE
Tested skills
Duration
80 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of *SQL

Programming task - Level: Medium

Python | NumPy | Aircraft measurement data processing - Complete data processing application that aggregates and compresses data streams using NumPy, Python and Data Analysis.