70-461 Session 7: Querying Microsoft SQL Server (T-SQL)

70-461 Session 7: Querying Microsoft SQL Server (T-SQL)

70-461 Session 7: Querying Microsoft SQL Server (T-SQL). With the help of this course you can Transactions, DMVs and Cursor. For SQL Server 2012, 2014, 2016 and 2017. For exams 70-461 and 70-761..

This course was created by Phillip Burton. It was rated 4.7 out of 5 by approx 7353 ratings. There are approx 36874 users enrolled with this course, so don’t wait to download yours now. This course also includes 4.5 hours on-demand video, 1 Supplemental Resource, Full lifetime access, Access on mobile and TV & Certificate of Completion.

What Will You Learn?

  • Learn about transactions, why they are important, and how you can use this.

  • Optimise queries, so that your database runs faster

  • Evaluate the use of row-based operations vs. set-based operations

  • Learn what XML data is, how to import and export it, and how to query and manage XML data.

This course is the foundation for the Microsoft Certificate 70-461: “Querying Microsoft SQL Server 2012”.

In Sessions 1 and 2, we learned all about dates, strings and number data types and DML statements. In sessions 3 and 4, we created views, procedures, triggers, constraints and combining datasets, and in session 5 and 6 we learned about ranking and aggregate functions, sub-questions, functions and dynamic SQL.

In this session we’ll 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 indexes 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. Finally, we’ll investigate XML data – how to convert SQL Server data into XML and vice versa.

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.

Rating:
4.3

Download Links

Get Download Link

Related Courses

Writing Advanced SQL Queries on Microsoft SQL Server

Microsoft SQL Server 2012 Certification Training Exam 70-461

Microsoft 70-464 Developing Microsoft SQL Server 2012 Da…

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Sub Query Magic: Write T-SQL Subqueries Using SQL Server

T-SQL For Beginners: Learn to Query SQL Server Databases

Learn Advanced Transact-SQL (T-SQL) : Using SQL Server 2017

Querying Microsoft SQL Server For Beginners

Microsoft SQL Server 2016 Certification (70-764)

Microsoft SQL Server 2016 Certification (70-765)

70-461 Session 2: Querying Microsoft SQL Server (T-SQL)

70-461 Session 2: Querying Microsoft SQL Server (T-SQL)

70-461 Session 6: Querying Microsoft SQL Server (T-SQL)

70-461 Session 6: Querying Microsoft SQL Server (T-SQL)

70-461 Session 4: Querying Microsoft SQL Server 2012 (T-SQL)

70-461 Session 4: Querying Microsoft SQL Server 2012 (T-SQL)

70-461 Session 3: Querying Microsoft SQL Server 2012 (T-SQL)

70-461 Session 3: Querying Microsoft SQL Server 2012 (T-SQL)

70-461 Session 5: Querying Microsoft SQL Server 2012 (T-SQL)

70-461 Session 5: Querying Microsoft SQL Server 2012 (T-SQL)

70-461 Session 1: Querying Microsoft SQL Server ’12-16 T-SQL

70-461 Session 1: Querying Microsoft SQL Server ’12-16 T-SQL

Microsoft MCSA 70-461 Querying Microsoft SQL Server Test

Microsoft MCSA 70-461 Querying Microsoft SQL Server Test

Microsoft 70-461: Querying SQL Server 2012

Microsoft 70-461: Querying SQL Server 2012

Querying Microsoft SQL Server 2012 – (Exam No. 70-461)

Querying Microsoft SQL Server 2012 – (Exam No. 70-461)

Querying Microsoft SQL Server Databases using T-SQL

Querying Microsoft SQL Server Databases using T-SQL
Go To Top