60% of SQL Developers Fail Competence Test
SQL trainer and developer Markus Winand announced the results of his 3-minute SQL quiz, which 28,000 SQL developers have taken since he launched the quiz in 2011. According to Winand, 60% of participants failed the test.
The test was created for education purposes, and Winand acknowledges the limitations with using it for statistical analysis. The test consists of 5 questions, most of which offer the simple choice of only two possible answers. Thus, a random choice is correct around 50% of the time. Some questions barely beat the "guessing" score of 50%; one had only 53.6% of participants answering correctly. Some of the questions have "trick" answers, meaning the obvious choice is not correct and the participant has to understand why.
Overall, only around 12% got all the questions right, and only 38.2% received what Winand considered a passing score by answering 4 of the 5 questions correctly.
Winand also tracks the results by database vendor (MySQL, Oracle, PostgresSQL, SQL Server), leading to some interesting observations about the relative competence of the developers and which types of queries are most important within each of the database options.
Related content
-
Optimizing SQL with Execution Plans
Understanding database execution plans is the key to assessing effectively the optimum potential of an SQL query or estimating your future resource requirements.
-
Automated compliance testing with InSpec
Don't equate compliance through certification with security, because compliance and security are not the same. We look at automated compliance testing with InSpec for the secure operation of enterprise IT. -
Test mechanisms for best practices in cloud design
Develop resilient and efficient cloud infrastructures for enterprise applications with the AWS Well-Architected Framework. We show you how to implement the solutions from the framework in practical terms by providing an introduction to the AWS Well-Architected tool with an example. -
Dispatches from the world of IT
-
LibreOffice in the workplace
How can LibreOffice be used in a corporate environment and what difficulties have to be considered? In particular, you cannot underestimate acceptance by your employees.
Subscribe to our ADMIN Newsletters
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Most Popular
Support Our Work
ADMIN content is made possible with support from readers like you. Please consider contributing when you've found an article to be beneficial.
