T-SQL Training with Real World Scenarios:Tricks of the Trade
7.5% 購買約可得229點
前往賣場
更多
※注意事項:
1.需透過LINE購物前往並在同一瀏覽器於24小時內結帳才享有回饋,點數將於廠商出貨後,隔天起算之90個日曆天陸續確認發送。
2.國際商家之商品金額及回饋點數依據將以商品未稅價格為準。
3.國際商家之商品金額可能受匯率影響而有微幅差異。
4.若於商家App下單,不符合LINE購物導購資格。
商品描述
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)