• 課程時長

    26 小時 22 分

  • 課程級別

    初級

  • 授課語言

    中文

這堂課你將會學到

  • 完整的TSQL觀念攻略
  • Create Database and Tables (DDL)
  • Select...From ... Group By ... (DML)
  • Stored Procedure
  • String Function
  • DateTime
  • Cast V.S. Convert V.S. Parse
  • Math Function
  • User Define Function
  • Temp Table
  • Index
  • View
  • DML Trigger
  • CommonTableExpressions(CTE)
  • Pivot and Unpivot
  • Transaction and TryCatch
  • Cursor, Create Large Sample Data, Check if object exist, Merge
  • Concurrent Transactions, Dead Lock, Find the blocking process
  • Joins, Cross Apply, Outer Apply
  • DDL Triggers, Login Triggers, Select Into
  • Debug Tools, Grouping, Over Clause
  • IFF, Offset PageNumber, Sequence Object, Guid
  • DynamicSQL, SQLInjection, SearchWebPage_AspNet, QueryPlanCache, QuoteName(), DynamicTableName, DynamicOutputParameter, DynamicTempTable

章節目錄