Test yourself and improve your SQL skills
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
0 students enrolled

Test yourself and improve your SQL skills

85 advanced T-SQL questions, complete with explanations and test codes, useful for preparing for the 70-761 exam
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
0 students enrolled
Created by Nicola Iantomasi
Published 3/2020
English
Test yourself and improve your SQL skills
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 Practice Tests
  • Full lifetime access
  • Access on mobile
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
Requirements
  • A good knowledge of SQL language and its constructs is necessary to understand the questions and the example codes shown in the solutions
Included in This Course
+ Practice Tests
3 Tests 85 questions

40 questions on how to manage data with T-SQL instructions.

Data management with T-SQL
40 questions

40 questions about advanced T-SQL constructs and how to program a database

Advanced T-SQL instructions and Programming a database with T-SQL
40 questions

Five New Questions on the Query Execution Plan! To understand the main factors that impact the performance of a query.

Due to the nature of the topics, questions will always be asked in the same order.

Execution plan of a query
5 questions
Description

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.

Who this course is for:
  • SQL developers, data analyst, web developer, data scientist, data engineer, who wants to prepare for the Microsoft 70-761 exam