T-SQL Training with Real World Scenarios:Tricks of the Trade

Transact SQL Query Programming & Developer Advanced Microsoft SQL Server Online Video Training Course by Vikas Munjal


What you'll learn
Feel more confident in handling real life scenarios and writing complex codes

Requirements
Basic knowledege of T-SQL is required such as Select , Join , Group By ,Primary Key, Foreign Key

Description
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)




Who this course is for:
Anyone who wants to enhance his/her knowledge to handle real life situations in T-SQL

More Info