Exam 70-761: Program Database by using Transact-SQL

In this course, you will learn-

• Working With Views

• Index

• Programming using T-SQL

• Implementing Stored Procedure

• Implement Error Handling and Transaction

Sub-topics:
Working with View

• Introduction & Advantages of Views

• Creating, Altering, Dropping Views

• Advance Options while Creating a View

• SQL Server Catalogue Views

• Using View Designer

Index

• Introduction

• Index Structure(B-Tree, Heap)

• Types of Index(Clustered/Non-clustered)

• Guidelines

• Example

Programming Using T-SQL

• Introduction to T-SQL

• Scripts and Batches

• Local Variables and Statements

• Global Variables

• Keywords

• Controlling Program Flow

• Working with Temporary tables

• Checking Existence of Database Objects

Implement Stored Procedure

• Introduction to stored procedures

• Benefits of Stored Procedures

• Understanding Execution Plan

• Creating, Executing, Modifying , Dropping Stored Procedure

• Input – Output and Optional Parameters

• Using RaisError and Throw

• System defined Stored procedures

Implement error handling and transactions

• Introduction to Error handling

• Using RAISERROR

• Using THROW

• Using @@Error

• Using TRY –CATCH

• Catchable and Non -catchable Errors

• Difference between RAISERROR AND THROW

• Transaction management in SQL Server

• USING XACT_STATE()

• USING XACT_ABORT