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.

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 …

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 …

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

Efficient SQL test query or validation query that will work across all (or most) databases Asked 15 years, 5 months ago Modified 4 years, 5 months ago Viewed 199k times

Mar 12, 2010 · Is there anything like this: TEST DELETE FROM user WHERE somekey = 45; That can return any errors, for example that somekey doesn't exist, or some constraint violation or anything, …