***New TSQL Programming batch on 16th May***

we are going to start a new batch for TSQL Programming(PL/SQL in Oracle) on 16th May At 10-12PM ISD if any one interested comment me we will contact you,we will cover the below topics on this module

TSQL Programming (like PL/SQL in Oracle)

·         Drawbacks Of TSQL that leads to TSQL Programming

·         Introduction To TSQL Programming

·         Control statements In TSQL Programming

·         Conditional Control Statements

·         If

·         Case

·         Looping Control Statements

·         While

Cursors

·         Working With Cursors

·         Types Of Cursors

·         Forward_Only and Scroll Cursors

·         Static, Dynamic and Keyset Cursors

·         Local and Global Cursors

·         Cursors with functions, procedures and triggers(will be dealt at the end)

Stored Sub Programs

·         Advantages Of Stored Sub Programs compared to Independent SQL Statements

·         Stored Procedures

·         Creating , Altering and Dropping

·         Optional Parameters

·         Input and Output Parameters

·         Permissions on Stored Procedures

·         User Defined Functions

·         Creating, Altering and Dropping

·         Types Of User Defined Functions

·         Scalar Functions

·         Table Valued Functions

·         Inline Table Valued Functions

·         Multi Statement Table Valued Functions

·         Permissions On User Defined Functions

·         Diff between fucntions and procedures

·         Triggers

·         Purpose of Triggers

·         Differences Between Stored Procedures and User Defined Functions and Triggers

·         Creating, Altering and Dropping Triggers

·         After Triggers

·         Magic Tables

·         Instead Of Triggers

·         Updating the complex view using instead of triggers

·         Exception Handling

·         Implementing Exception Handling

·         Try –catch mechanism

·         Adding and removing User Defined Error Messages To And From SQL Server Error Messages List

·         Raising Exceptions Manual

·         Generating Errors through throws key word

Thanks

SQL Srinivas