SQL online tests

Devskiller SQL online tests were written by our dedicated team to assess SQL developer skills for various positions. Our SQL coding tests are the perfect solution for all of your technical screening and online interview needs. 

Powered by the RealLifeTesting™ methodology, you can use Devskiller to test candidates for junior, middle, and senior positions.

Technologies covered:

Programming language: SQL

SQL frameworks and libraries: MySQL, PostgreSQL, Oracle, MSSQL and others

Build tools: MSBuild

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.

Available in Team and Enterprise plans

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

Available in Team and Enterprise plans

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

Available in Team and Enterprise plans

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

Available in Team and Enterprise plans

Create account
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 Team and Enterprise 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 Team and Enterprise 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 Team and Enterprise plans

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

Available in Team and Enterprise plans

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

Available in Team and Enterprise plans

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

Available in Team and Enterprise plans

Create account
Python
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 Team and Enterprise 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 Team and Enterprise plans

Create account

The right SQL online tests to screen SQL developers

Recommended roles for our SQL online tests

  • Data analyst
  • Database administrator 
  • SQL developer
  • Database engineer
  • Database specialist
  • Junior SQL developer
  • Middle SQL developer
  • Senior SQL developer
  • Data entry technician
  • Data quality specialist

How our SQL online tests work

The RealLifeTesting™ methodology powers Devskiller SQL coding tests. Our selection of coding tests will help you analyze your applicants’ knowledge of various SQL versions. In addition to that, our coding tests will help you assess applicants’ coding skills, problem-solving ability, and time management.

Key features

  • Devskiller SQL coding tests measure applicants’ coding ability and not just their academic knowledge
  • Remote testing that gives you the freedom and convenience of testing candidates from all over the world
  • The RealLifeTesting™ methodology creates a better user experience where candidates can use their own IDE, clone to GIT, run unit tests and access Stack Overlow/Github/Google for research
  • Strict anti-plagiarism tool that ensures accurate test results
  • Automatically generated results that non-tech professionals can understand
  • SQL coding tests available for junior, middle, and senior-level positions

What to look for in SQL developers

SQL is the most popular 4GL (Fourth Generation Programming Language), which means that programmers only declare what the result looks like, rather than how the database should calculate the result. SQL is embedded in other, more general-purpose programming languages like Java to access data from central databases.

A qualified SQL developer should possess well-versed abilities with SQL performance. In addition to this, your successful candidate should possess SQL design skills with demonstrated knowledge of relational theory. Finally, SQL refactoring skills can prove quite useful in larger teams where the SQL is more complex.

Skills covered in our SQL online tests

  • HSQLDB
  • Mongo
  • MongoDB
  • MSSQL
  • MySQL
  • NoSQL
  • Oracle
  • PostgreSQL
  • SQL
  • CSS
  • ES6
  • HTML
  • Javascript
  • PDO

Looks good, but want more?

Do you want to run coding tests in a predefined environment? Perhaps you want to test applicants using your own codebase? At Devskiller, you can build custom tests using our online task wizard. Solve all of your technical screening needs with our SQL coding tests today.