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.
相關商品:
SkillSoft Creating and Implementing Database Objects in SQL Server 2005 Training 英文正式版(培訓課程軟體)
SkillSoft SQL Server 2005 Backup and Restores Training 英文正式版(培訓課程軟體)
SkillSoft Managing and Maintaining SQL Server 2005 Databases Training 英文正式版(培訓課程軟體)
SkillSoft Retrieving Data and Running Queries in SQL Server 2005 Training 英文正式版(培訓課程軟體)
Digital Press Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook Apr 2007 英文正式版(Digital Press Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook 電子書)
CBT Nuggets Exam Pack 70-433 Microsoft SQL Server 2008 Database Development Training 英文正式版(CBT Nuggets考試教程軟體)
CBT Nuggets Exam Pack 70-451 Microsoft SQL Server 2008 Designing Database Solutions And Data Access 英文正式版(SQL Server 08 數據庫教程軟體)
