Exam 70-761: Program Database by using Transact-SQL
this course: Learn T-SQL programming with views, indexes, stored procedures, error handling, and transactions. Ideal for anyone with basic database knowledge.
What you’ll learn
- 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
Who this course is for:
- Anyone who has completed our courses Basic Database Concepts, Manage data with Transact-SQL and Query data with advanced Transact-SQL Components
User Reviews
Be the first to review “Exam 70-761: Program Database by using Transact-SQL”
You must be logged in to post a review.
There are no reviews yet.