70-461 Session 7: Querying Microsoft SQL Server (T-SQL code)
About this course
This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012/2014". Please note - this certificate is no longer being offered by Microsoft. However, the exam requirements allow you to have a good understanding of T-SQL.Welcome to Session 7 of this T-SQL course. In this session:We will be looking at transactions, seeing how to explicitly start and end them, and finding out how they can block other users in the database. Then we'll see about how to create clustered and non-clustered indexes and heaps, and their role in optimising queries. We'll also see how we can use Dynamic Management Views to see how we can improve our use of indexes. We'll then look at how to write a cursor, and when to use this row-based operation, and The impact of using scalar UDFs.No prior knowledge other than what we covered in Sessions 1 to 6 is required. This course builds on the knowledge previously gained in those previous sessions.There are regular quizzes to help you remember the information.Once finished, you will know what how to create transactions, indexes, cursors, XML data and more, and we'll have expanded on our current knowledge of T-SQL.
56/100
CourseAsk score
- What the provider tells you
- 32/45
- Who stands behind it
- 8/35
- How complete the listing is
- 16/20
Scores how much the provider publishes and who stands behind it — not how well it is taught.
What you'll learn
- create and manage transactions
- design clustered and non-clustered indexes
- write and utilize cursors
- use XML data effectively
- improve query performance with Dynamic Management Views
Price shown by Udemy — confirm on their site.
Enroll on UdemyYou'll be redirected to Udemy to complete enrollment.
- Listed & compared by CourseAsk
- English · 0
Udemy
![[마이크임팩트 GMC] 결핍 없이 욕망할 수 있는가](https://i.udemycdn.com/course/480x270/4490290_0e54_3.jpg)
Compared on these lists
Where this course ranks against the alternatives.