Tech2BI

29.SQL Server - Table Valued Functions (TVF) | Inline Table Valued Functions

15.SQL Server - STRING_AGG | CAST | CONVERT and Numeric Data Types

7.SQL Server - How to Create Primary Key | Composite Key

33. SQL Server Exception Handling | TRY | CATCH Blocks

2. SSIS - Working with Flat Files

28.SQL Server - UDF Scalar Valued functions WITH Examples

38. SQL SERVER - PIVOT | UNPIVOT

27.SQL Server - User Defined Functions (UDF)

39.SQL SERVER - CROSS APPLY | OUTER APPLY

12.SQL SERVER - DATE FUNCTIONS

34. SQL SERVER EXCEPTION HANDLING | RAISE ERROR | THROW

32.SQL Server Indexed Views /Materialized views

30.SQL Server - UDF | Multi Table Valued Functions

5. SSIS - Muti Flat File Connection Manager

5.SQL Server DCL Commands | GRANT | DENY | REVOKE

17.SQL Server Operators - PART 2 | LOGICAL OPERATORS LIKE | EXISTS | ANY | ALL | BETWEEN

6.SQL Server TCL Commands and Constraints

36. SQL SERVER - CURSORS