SQL

SQL online tests

Devskiller SQL online tests were written by SQL specialists to assess SQL developer skills for various positions. Our SQL online tests are an excellent choice for technical screening and online interviews.

Devskiller SQL online tests are powered by RealLifeTesting™ methodology which allows you to select developers with the right skill set.

Technologies covered:

  • Programming language: SQL
  • SQL frameworks and libraries: MySQL, PostgreSQL, Oracle, MSSQL and others
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.

Available in premium plans

Create account
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.

Available in premium plans

Create account
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.

Available in premium plans

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

Choice questions

assessing knowledge of SQL, MongoDB, NoSQL

Code gaps

assessing knowledge of Mongo, 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.

Available in premium plans

Create account
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.

Available in premium plans

Create account
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.

Available in premium plans

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

Choice questions

assessing knowledge of SQL, MongoDB, NoSQL

Code gaps

assessing knowledge of Mongo, 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.

Available in premium plans

Create account
JUNIOR
Tested skills
Duration
54 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of SQL

Programming task - Level: Easy

Python | DNA Analyzer - Implement a method in Python that generates DNA statistical report.

Available in premium plans

Create account
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.

Available in premium plans

Create account
SENIOR
Tested skills
Duration
45 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of SQL

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.

Available in premium plans

Create account