The SQL online test assesses SQL skills using live coding tasks that require writing CRUD operations in order to extract, combine, and manipulate data.

The MySQL online test assesses knowledge of MySQL features and SQL skills using live coding tasks that require writing MySQL stored procedures, triggers, and SQL queries.

Our test will be a SQL select query, with the following structure: a test name and a case statement catenated together. The test name is just an arbitrary string. The case statement is just case when …

All TestDome tests and questions grouped by skill.

Jun 13, 2012 · 138 In some cases, running an UPDATE statement in production can save the day. However a borked update can be worse than the initial problem. Short of using a test database, what …

The MS SQL Server online test assesses knowledge of MS SQL Server features and SQL skills using live coding tasks that require writing T-SQL stored procedures, SQL queries, and using features …

Many database connection pooling libraries provide the ability to test their SQL connections for idleness. For example, the JDBC pooling library c3p0 has a property called preferredTestQuery, which...

The Oracle PL/SQL online test assesses knowledge of PL/SQL with live coding tasks that require writing SQL queries and using features specific to the Oracle SQL Engine.

I'd like to write a SELECT statement that uses just one test to return columns with no value (null, empty, or all spaces). I thought this would work: SELECT column_name from table_name WHERE

The Python online test assesses knowledge of programming in the Python language and commonly used parts of the Python Standard Library.