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