SkillSoft SQL Server 2005 Database Performance and Optimization Training 英文正式版(培訓課程軟體)
Skill Soft 發佈的針對各項內容的培訓課程。
發佈說明：對應培訓課程分別是：《Flash 8 中的動畫製作》《ABAP 程式設計 II》
《ABAP 程式設計 I》《ABAP 基礎原理》《SQL Server 2005 數據庫效能和優化》
《SQL Server 2005 備份和還原》《SQL Server 2005 中的數據獲取和查詢執行》
《水晶報表 XI 的報告基礎》《管理和維護 SQL Server 2005 數據庫》
《安裝 SQL Server 2005》《建立和應用 SQL Server 2005 中的數據庫對像》
《Check Point NGX 安全策略》《工作流導航和在 Flash 8 中的發佈》
Overview/Description
To monitor and optimize database performance using SQL Server
utilities
Target Audience
Professionals typically pursuing a career as a Database
Administrator, Database Developer or Business Intelligence Developer;
individuals who do not work with SQL Server as a part of their
primary job but wish to show their breadth of technology experience,
including developers and systems administrators among others
Prerequisites
This is a high-level technical path and candidates for the exam, and
hence learners should be expert in the following areas: Tools usage
UI navigation Wizards usage Writing code in the appropriate language
(Transact-SQL, CLR Language, other scripting languages, etc.) Code
debugging or syntactic issue resolution Troubleshooting Accomplishing
specific focused tasks through the use of code or UI navigation
Expected Duration
155 Minutes
Objectives :
SQL Server 2005 Database Performance and Optimization
configure SQL Server Profiler Trace files in a given scenario.
configure System Monitor to monitor SQL Server performance in a given
scenario.
use SQL Server Profiler and System Monitor to monitor an instance of
SQL Server 2005.
recognize the features and functionality of Database Engine Tuning
Advisor.
use Database Engine Tuning Advisor to tune a SQL Server database in a
given scenario.
tune a SQL Server database using Database Engine Tuning Advisor.
retrieve SQL Server state information using dynamic management views
(DMVs) in a given scenario.
query dynamic management views and functions.
|
|
您現在的位置：
專業知識教學
