5  1 reviews on Udemy

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

This course follows our course Exam 70-761: Query data with advanced Transact-SQL Components
Course from Udemy
 16 students enrolled
 en
Working With Views
Index
Programming using T-SQL
Implementing Stored Procedure
Imeplement Error Handling and Transaction

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

Exam 70-761: Program Database by using Transact-SQL
$ 34.99
per course
Also check at

FAQs About "Exam 70-761: Program Database by using Transact-SQL"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.

SOCIAL NETWORK