Training Syllabus

Durasi : 5 hari

  • Data Retrieval (Querying, Joining, Aggregate Queries, Combining Datasets)
  • Modifying Data Using Insert, Update, Delete and Merge Statements
  • Tables, Data Types, and Declarative Data Integrity
  • Using Additional Query Techniques (CTE, Subqueries, Ranking)
  • Programming MS SQL Server with T-SQL (UDF, Functions, Triggers and Views)
  • Techniques to Improve Query Performance (Tuning Queries and Index)
  • Using XML, SQLCLR and Filestream
  • Using Spatial, Full-Text Search and Service Broker
  • Integrating Database Mail
  • Using Windows PowerShell and SQL Server Managements Objects (SMO)
  • Track Data Changes