What is a user defined function (UDF)
Different types of UDF's
Scalar Functions
Table valued Functions
Inline Table Valued Functions
Multi statement Table Valued Functions
Properties of UDF's
How develop and execute UDF's
Advantages
Limitations
How to use Scalar Udf's in computed columns
What are Deterministic functions and Non Deterministic functions how do they effect UDF's
How do they effect performance of the UDF's
Creating indexes on the Computed columns
![](https://i.ytimg.com/vi/R2zbu3HG7CU/maxresdefault.jpg)