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.
Linguaggio di programmazione: SQL
SQL frameworks and libraries: MySQL, PostgreSQL, Oracle, MSSQL and others
Strumenti di costruzione:MSBuild
valutare la conoscenza di Anonymity, Blockchain, Decentralization, DLT, Leger, Ether, Accounts, Ethereum
Blockchain | Solidity | Lottery - Implement the one time raffle based on blockchain technology.
valutare la conoscenza di Matematica, Probabilità, Competenze trasversali, SQL
valutare la conoscenza di MySQL, SQL
SQL | MySQL | Software House | Devs and their projects - The Head of the development team assigned you a task to create a list of developers with their role in the ongoing projects.
valutare la conoscenza di JavaScript, Node.JS
valutare la conoscenza di JavaScript, Node.JS, SQL
Node.JS | Rest API | News backend service - Implementare un servizio di news backend creato in Node.JS con Vanilla JS, compresa la scrittura di autorizzazioni e API Rest.
valutare la conoscenza di Pensiero logico, Matematica, MySQL, SQL
valutare la conoscenza di SQL
SQL | MySQL | Stamps catalogue | AVG Function - Select the stamps (name and price) with price greater than or equal to the total average price.
valutare la conoscenza di Pensiero logico, SQL, MySQL
valutare la conoscenza di MySQL, SQL
SQL | MySQL | Stamps catalogue | A Self JOIN - Select stamps (name and location) that are in the same location.
valutare la conoscenza di SQL, PostgreSQL
valutare la conoscenza di PostgreSQL, SQL
SQL | PostgreSQL | Music Store | Time function - Calculate the duration of all songs in each cd and output a list.
valutare la conoscenza di Pensiero logico, SQL
valutare la conoscenza di SQL
SQL | PostgreSQL | Hotels - average prices - Prepare the report with the average prices in the cities.
valutare la conoscenza di Pensiero logico, SQL
valutare la conoscenza di SQL
SQL | PostgreSQL | Hotels - bookings - Prepare the booking list with a number of days, price per day and total price of the stay.
valutare la conoscenza di Pensiero logico, SQL
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.
valutare la conoscenza di DevOps, Terraform, AWS
valutare la conoscenza di DevOps, Terraform, AWS
DevOps | Terraform, AWS | Create the EC2 instance using specific AMI - Create the EC2 instance using specific AMI in a default VPC with SSH access, using Terraform and AWS provider.
valutare la conoscenza di Java, Spring Boot
valutare la conoscenza di PostgreSQL, SQL
Java | Spring Boot | Items Retriever Microservice - Implement a microservice to retrieve items from the shopping system.
SQL | MSSQL | Finding nulls - Write a query that returns the names of all items which are not available
SQL | MSSQL | Finding date ranges - Write a query that returns the names of all items added within the last 7 days.
SQL | MSSQL | Using aggregates - Write a query that returns the names of all items of a given category
SQL | MSSQL | Finding duplicates - Write a query that returns the names of all items which are duplicated
valutare la conoscenza di Grandi dati, PySpark, Pitone
valutare la conoscenza di SQL
Python | PySpark | Società di gestione delle flotte - Rilevare gli eventi di eccesso di velocità e verificare la correttezza di un predittore esistente.
JavaScript | TypeScript | Invoice application - frontend - Implement the front-end part for merging and aggregating the invoice data with currency exchange rates.
Java | Invoice application - backend - Implement the backend part for searching and aggregating invoice data with the service and the DAO methods.
SQL | Catalogo francobolli | I tre prezzi più alti - Seleziona i tre francobolli (prezzo e nome) con il prezzo più alto.
Python | Pandas | Parser di tabelle HTML - Implementa una funzione per convertire una tabella HTML in un file in formato CSV.
valutare la conoscenza di Pitone
Python | Rapporto sulle vendite di veicoli - Implementare un'applicazione per creare rapporti basati sul data warehouse delle vendite di veicoli.
valutare la conoscenza di DevOps, Docker
DevOps | Master of Disaster Recovery (CentOS) - Recover data from broken MariaDB/MySQL database.
valutare la conoscenza di DevOps, Docker
DevOps | Master of Disaster Recovery (Ubuntu) - Recover data from broken MariaDB/MySQL database.
valutare la conoscenza di SQL
valutare la conoscenza di SQL
SQL | PostgreSQL | Hotels - hotels page optimization - Improve the performance of the the hotels listing page which currently uses ORM.
valutare la conoscenza di SQL, MongoDB, NoSQL
valutare la conoscenza di MongoDB
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.
valutare la conoscenza di SQL
valutare la conoscenza di ES6, JavaScript, CSS, HTML, WCAG 2.0, Web Accessibility
PHP | Categories Repository - Implement PDO queries that will return valid results about movies to users.
valutare la conoscenza di SQL, ES6, JavaScript, AJAX, Sviluppo web
PHP | XML-CSV Converter - Implement filtering and data transformation methods to pass all the tests.
valutare la conoscenza di SQL, CSS, HTML
valutare la conoscenza di JavaScript
PHP | Faker | Basic data manipulation - Implement all the methods in the app/Faker class.
valutare la conoscenza di SQL, MongoDB, NoSQL
valutare la conoscenza di MongoDB
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.
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.
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.
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.
How can you be expected to understand how effective our screening tool is if you’ve never tried it? After all, our DevSkiller SQL online tests are different to the traditional algorithmic tests you will have encountered. Don’t take our word for it, have a look at what some of our past customers have to say:
"Abbiamo sostituito una soluzione interna ad alta manutenzione con DevSkiller. Il nostro processo è identico, ma il prodotto ci offre prestazioni migliori. I risultati sono anche molto più facili da valutare".
"DevSkiller ci ha aiutato a risparmiare tempo prezioso in loco per i candidati che sono già probabilmente adatti. Stiamo risparmiando 3 ore per ogni candidato: questo era il tempo che prima dedicavamo ai candidati su un compito tecnico".
"La durata del processo di reclutamento non è cambiata, ma spendiamo meno tempo e meno fatica per ogni candidato. Inoltre, non perdiamo tempo con i candidati sbagliati".
One of the main advantages of DevSkiller testing is that evaluation of our SQL online tests happens automatically. As soon as the candidate is finished, our screening tool gets to work on the solutions and automatically assesses how well each candidate has done. This saves recruiters countless arduous hours spent marking algorithm tests.
Candidates are assessed on whether or not the solution they came up with would run (an essential factor in all software development). How their solution would perform in edge cases and the content and quality of their code. Successful candidates are those who can best demonstrate their critical thinking skills in the time allotted.
Results are then compiled into concise, easy-to-follow reports, that non-technical professionals can understand regardless of their own level of technical skill.
Devskiller SQL online tests are accessed remotely and can be taken from anywhere in the world. Saving valuable time spent waiting until both the candidate and the interviewer have time to conduct a test. Remote-testing means once the test invites are sent, the recruiter just has to sit back and wait for the results to come in. Recruiters can even add time limits to each test to make sure they’re not left waiting around.
When it comes to the test itself, candidates have the option of using DevSkiller’s state-of-the-art in-browser IDE or they can complete the project on their favorite IDE and then clone the project to GIT. If they want, candidates can run unit tests to make sure their solutions work the way they are supposed to.
The duration of our SQL online tests is flexible and is left up to the recruiter. Each SQL test comes loaded with default settings, including a default duration, but these can be easily adjusted. Even individual questions within a test can be given time limits if required.
Developers’ reactions to our SQL online tests are by and large, very positive. The vast majority of candidates relish the chance to prove their software development skills. If occasionally, a developer’s reaction is not as we expect, this is usually just an initial reaction to having to take the tests at all. Many developer tests don’t reflect the real work that developers actually do, so they can grow wary of developer testing. Once they realize our tests are different, they’re overwhelmingly positive in their responses and love the chance to actually show what they can do.
Our SQL online tests allow developers to use normal coding tools and conventions like unit testing and cloning to GIT from a personal IDE.
