• views: 89
• date: 20 March 2024
• posted by: voska89

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
Homepage

https://www.udemy.com/course/t-sql-training/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.