Test yourself and improve your SQL skills

The course contains eighty–five questions of medium and high complexity on the Transact SQL language, the dialect of SQL for the Microsoft SQL Server database. The questions are related to fundamental topics, but sometimes underestimated or of which one is not fully aware, for those who work daily with the SQL language and the SQL Server database.

This is a Practice test course , there are not videos, but the answers are carefully commented and in many cases there is code to test the results and experiment.

Please, after completing the test, read all explanations, even if your answers are correct.

I spent a lot of time writing the explanation and executable code, especially when the question says There is an example in the explanation of the answer . I suggest you to create a database for test. Obviusly DON’T use your production installation!!! :–)

The tests are divided into six sections:

Query a database with T–SQL (20 questions)

Questions about DQL operations to query the database. We will see constructs related to the from, where, group by, order by, union and SQL Server Data Types

T–SQL functions (9 questions)

In this test we enter the world of T–SQL functions like Replace, concat, concat ws, convert, len, datalength, coalesce, newid(), non deterministic and deterministic function.