This test aims to test knowledge of MS SQL Server and includes questions almost from any aspect of MS SQL Databases such as:

1. Querying, sorting, filtering data
2. Subqueries and joins
3. Grouping and aggregation
4. Window functions
5. Set operators
6. DDL, DML
7. Transactions
8. Indexes
9. Temporary objects
10. Stored procedures, functions and error handling
11. Cursors, loops, dynamic SQL
12. Database administration

There are 20 questions in the quiz and 1 hour to answer all of them. Good luck!