In this online T-SQL training course , a lot of real life scenarios are included which i learnt by practicing on Microsoft SQL Server Technology over the years. I believe this Transact SQL Programming & Development video tutorial will deepen the understanding on T-SQL developer and participant will feel more confident in handling real life scenarios. I have covered not only the course contents but also i have covered the real life situations for every topic.
Real Life situations are as follow
How to view the structure of a table
How to create your own shortcuts in SSMS
Dropping multiple tables in one go having a fixed pattern
Guidelines while performing DML Operations
How to create Solution File in SSMS and what is the need for it
How to insert a row with old identity value which was deleted
How to reset table identity
How to delete duplicate records from a table
How to select only duplicate records from a table
How to produce Date Dimension using Recursive CTE Query
How to Merge New Changes to an Existing Table
What are the advantages of Stored Procedure
BEGIN AND COMMIT TRANSACTION IS NOT SUFFICIENT
How to produce running totals or cumulative totals using sql server query
How to compare current year sales with the previous year sales
How to compare current year sales since the start of the business year sales
How to switch between different SQL Servers within a query window in SSMS
How to use a single sql script file for different SQL Servers
Reducing Roundtrips using Table Valued Stored Procedure
Pagination in SQL Server using OFFSET-FETCH
BEGIN AND COMMIT TRANSACTION IS NOT SUFFICIENT
Relevance of Batch in SQL Server
How to create and store customized errors
Guidelines of writing a Stored Procedure
Following are the major topics covered
Deep dive into Window Functions
Ranking Functions - (Rank, Dense_Rank Row_Number, NTile )
Aggregate Functions - (Sum,Min,Max,Avg,Count)
Analytical Functions-(Lead , Lag, First_Value, Last_Value)
Stored Procedures
Input Parameters
Output Parameters
Default Parameters
Return
Table Valued Parameters
Common Table Expressions
Recursive Common Table Expressions
Synonyms
Identity Columns
Transactions
Raiserror/Throw
Error Handling (Try….Catch)
