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.
In the latest update, five new questions about the query execution plan have been added.
The answers are carefully commented and in many cases there is code to test the results and experiment.
We will talk about stored procedures, views, try / catch constructs, transactions, temporal table, cross apply, pivot, merge and much more.
Test yourself, test your knowledge and prepare for the Microsoft 70-761: Querying Data With Transact SQL exam.