課程簡介
為了迎接 Microsoft 新產品的推出，以及最新微軟專業認證架構，我們已為大家準備了最新的 SQL Server 2008 綜合技術課程，幫助大家盡快掌握 SQL Server 2008 的技術精髓。然後快人一步考取微軟新一代證書 MCITP - SQL Server 2008，讓您在企業中站在領導位置。
我們的課程能夠讓同學在應用 SQL Server 2008 上能夠有多方面的管理知識，包括從安裝設定、配置、管理、以及系統安全。並介紹 SQL 在性能監視，數據傳輸和遷移，自動化任務和數據庫高可用性等方面的功能和配置。完成整個課程後，更可參加 MCITP - SQL Server 2008 考試，獲取專業資格。
適合人仕:
有志投身
I.T. 界的人仕資料庫管理員，系統管理人員系統支援專家，電腦技術員對最新的
Microsoft 產品技術有興趣修讀條件:具有
Windows Server 操作經驗擁有互聯網及 TCP/IP 的基本概念對數據庫管理及運作有濃厚與趣課程包括:導師精心編製
MCITP for SQL Server 2008 課程筆記Sybex
Microsoft MCITP for SQL Server 2008 電子書課本Exchange
Server 2008 試用版光碟一隻課程實習
CD-ROM 一隻一人一機實習，針對各科考試要點溫習再配合不同層次的
Lab Test 練習全新
3 月份更新的模擬試題連參考答案 (模擬試題 "一年" 免費更新保證，考試更有彈性)課程由
Microsoft Certified Trainer (MCT) 親自教授課程電腦設備:2GB DDR2 記憶體、500GB SATA II Hard Disk 及 17" LCD Display，加上每部電腦均連接上 100/1000 Mbps Fast Ethernet 高速網絡，在學習過程中保證 "暢通無阻"。
授課語言:
課程全長:
開課日期:
課程費用:
匯豐信用卡可享 12 個月
免息分期優惠
(每月只須 $ 240)舊生或舊生介紹可享
95 折 優惠 (請預早致電留位時登記作實)舊生在報名表上獲導師簽名推薦更可享 9 折 優惠 (有關詳情請向您的導師查詢)
完成本課程後可參加的相關考試:
試題數量: 44-50 題
考試時間: 120 分鐘
合格分數: 700 / 1000 分
模擬試題參考
(70-450) PRO: Designing and Maintaining a Database Server using SQL Server 2008
試題數量: 44-50 題
考試時間: 120 分鐘
合格分數: 700 / 1000 分
模擬試題參考
成功通過考試後獲得的國際認可證書及資格:
Installing and Configuring SQL Server 2008Install SQL Server 2008 and related services.
Configure SQL Server instances.
Configure SQL Server services.
Configure additional SQL Server components.
Implement database mail.
Configure full-text indexing.
Maintaining SQL Server InstancesManage SQL Server Agent jobs.
Manage SQL Server Agent alerts.
Manage SQL Server Agent operators.
Implement the declarative management framework (DMF).
Back up a SQL Server environment.
Managing SQL Server SecurityManage logins and server roles.
Manage users and database roles.
Manage SQL Server instance permissions.
Manage database permissions.
Manage schema permissions and object permissions.
Audit SQL Server instances.
Manage transparent data encryption.
Configure surface area.
Maintaining a SQL Server DatabaseBack up databases.
Restore databases.
Manage
and configure databases.
Manage
database snapshots.
Maintain
database integrity.
Maintain
a database by using maintenance plans.
Performing
Data Management TasksImport
and export data.
Manage
data partitions.
Implement
data compression.
Maintain
indexes.
Manage
collations.
Monitoring
and Troubleshooting SQL ServerIdentify
SQL Server service problems.
Identify
concurrency problems.
Identify
SQL Agent job execution problems.
Locate
error information.
Optimizing
SQL Server PerformanceImplement
Resource Governor.
Use
the Database Engine Tuning Advisor.
Collect
trace data by using SQL Server Profiler.
Collect
performance data by using Dynamic Management Views (DMVs).
Collect
performance data by using System Monitor.
Use
Performance Studio.
Implementing
High AvailabilityImplement
database mirroring.
Implement
a SQL Server clustered instance.
Implement
log shipping.
Implement
replication.
70-432: Configuring SQL Server 2008 課程內容 :
Designing
a SQL Server Instance and a Database SolutionDesign
for CPU, memory, and storage capacity requirements
Design
SQL Server instances
Design
physical database and object placement
Design
a migration, consolidation, and upgrade strategy
Designing
a Database Server Security SolutionDesign
instance authentication
Design
instance-level security configurations
Design
database, schema, and object security paramaters
Design
a security policy and an audit plan
Design
an encryption strategy
Designing
a Database Solution for High AvailabilityDesign
a failover clustering solution
Design
database mirroring
Design
a high-availability solution that is based on replication
Design
a high-availability solution that is based on log shipping
Select
high-availability technologies based on business requirements
Designing
a Backup and Recovery SolutionDesign
a backup strategy
Design
a recovery strategy
Design
a recovery test plan
Designing
a Monitoring StrategyDesign
a monitoring solution at the operating system level
Design
a monitoring solution at the instance level
Design
a solution to monitor performance and concurrency
Designing
a Strategy to Maintain and Manage DatabasesDesign
a maintenance strategy for database servers
Design
a solution to govern resources
Design
policies by using Policy-Based Management
Design
a data compression strategy
Design
a management automation strategy
Designing
a Strategy for Data DistributionAdminister
SQL Server Integration Services (SSIS) packages
Design
a strategy to use linked servers
Design
a replication strategy for data distribution