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.
•Advanced T-SQL (21 questions)
We explore advandec T-SQL construct like Pivot and Unpivot, management of the Json format, Try/Catch block and Transaction
•DML and DDL operation (9 questions)
Deep questions about TRUNCATE, DELETE, UPDATE, ALTER TABLE
•Program a database (21 questions)
In this test we deal with more advanced topics of T-SQL: relationship between cte and derived table, limitations of UDFs, Stored Procedures, ITVF and VIEW.
•Query Execution Plan (5 questions)
I have added five new Query Execution Plan questions! To enter the meanders of SQL Server and understand the main factors that impact the performance of a query. Due to the nature of the arguments, the questions will always be asked in the same order.
Test yourself, test your knowledge and discover new topics and your areas of improvement about Microsoft SQL Server.