| |
數據庫管理考試
(1 Required) | 70-228: Installing,
Configuring & Administering Microsoft SQL Server 2000 Enterprise Edition | 數據庫設計考試
(1 Required) | 70-229: Designing
& Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition | 網絡系統考試
(1 Required) | 70-290: Managing
& Maintaining a Microsoft Windows Server 2003 Environment | 自選科目考試
(1 Required) | 70-293: Planning
& Maintaining a Microsoft Windows Server 2003 Network Infrastructure |
適合人仕 :
有志投身 I.T. 界的人仕，程式設計員，資料庫管理員，系統工程師。
修讀條件 :
- 具有基礎 Windows 操作經驗
- 擁有資料庫設計的簡單概念
- 對資料庫系統及網絡具有濃厚與趣
課程包括 :
- Windows Server 2003
R2 & SQL 2000 筆記課本 (一共四本)
- 全套 MCDBA 多媒體電子教材及各科目 PDF 電子書
- 導師精心編寫的考試精讀筆記一套
- 最新模擬試題連參考答案
- (模擬試題 "半年"
免費更新保證，考試更有彈性)
- 課程實習 CD-ROM 一隻
- Windows Server 2003
R2 試用版
- 一人一機，理論與實習同時進行
- 課程由 Microsoft Certified Trainer (MCT) 親自教授 | 
Microsoft Certified Trainer
親自教授
|
授課語言 :
以廣東話授課為主，亦會以英語輔助。
課程全長 :
16 堂 / 48 小時
(每堂
3 小時)
開課日期 :
| MCDBA0930 |
09 月 30 日 (逢星期
二，
7 - 10 p.m) |
課程費用 :
原價 $6,880
特價
$
4,580
(只限9月)
匯豐信用卡分期
$
458 x 12 個月
完成課程及通過所有考試後，可獲取以下兩張國際認可證書及專業資格
|
|
從 4
月 1 日起，Microsoft
的 70-290 考試將加入 4
條 Simulation 題目，而 70-291
則有 3 條 Simulation
題目，考試要求考生在 Windows
Server 2003
的操作上有充分的管理能力，並能完成指定工作，目的旨在加強實務操作方面的能力。
為了讓 MCSE Windows 2003
課程之同學能夠應付 Microsoft
全新的 Simulation
考試模式，我們已經作好準備，除了在課程中加強這方面的實習外，還己經準備好一系列的模擬試題供同學參考，務求令每位同學都有足夠信心參加考試，本校的
MCSE
同學可向導師查詢有關考試細節。 |
每位成功考取
Microsoft
專業證書的同學，您必須在完成考試的
3
日後，登入微軟
MCP 網站登記及確認個人資料，然後便可在
4
至
6
星期內收到由
Microsoft 寄出的
Welcome Kit，當中包括印上閣下名字的證書、確認文件、MCDBA
Wallet Card，MCDBA
扣章，以及一系列優惠資訊。 |
|
課程內容 :
| 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 |
• Install SQL Server 2000. Considerations include clustering, default collation.
• Upgrade to SQL Server 2000.
• Upgrade to SQL Server 2000 from SQL Server 7.0.
• Create a linked server.
• Configure SQL Mail and SQLAgentMail.
• Creating SQL Server 2000 Databases
• Attach and detach databases.
• Expand and shrink a database.
• Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases
• Optimize files and filegroups.
• Manage database fragmentation.
• Modify the database schema.
• Perform disaster recovery operations.
• Perform integrity checks. Include configuring the Database Maintenance Plan Wizard
• Set up IIS virtual directories to support XML.
• Manage linked servers.
• Convert data types.
• Create and manage log ons.
• Managing, Monitoring, and Troubleshooting SQL Server 2000
• Configure alerts and operators by using SQL Server Agent.
• Monitor hardware resource usage by using System Monitor.
• Monitor SQL Server system activity by using System Monitor.
| 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 |
• Define entities. Considerations include entity composition and normalization.
• Specify entity attributes.
• Specify scale and precision of allowable values for each attribute.
• Implementing the Physical Database
• Specify space management parameters. Parameters include autoshrink and maxsize.
• Create and alter database objects. Objects include constraints, indexes.
• Alter database objects to support replication and partitioned views.
• Design a partitioning strategy.
• Design and create constraints and views.
• Retrieving and Modifying Data
• Retrieve, filter, group, summarize, and modify data by using Transact-SQL.
• Specify trigger actions.
• Design and manage transactions.
• Tuning and Optimizing Data Access
• Improve index use by using the Index Tuning Wizard.
• Designing a Database Security Plan
• Define object-level security including column-level permissions.
• Create and manage application roles.
| 70-290: Managing and Maintaining a Microsoft Windows Server 2003 Environment |
• Manage basic disks and dynamic disks.
• Monitor server hardware. Tools might include Device Manager
• Optimize server disk performance.
• Install and configure server hardware devices.
• Managing Users, Computers, and Groups
• Manage local, roaming, and mandatory user profiles.
• Create and manage computer accounts in an Active Directory environment.
• Create and manage user accounts.
• Troubleshoot computer accounts.
• Troubleshoot user authentication issues.
• Managing and Maintaining Access to Resources
• Troubleshoot Terminal Services.
• Configure file system permissions.
• Troubleshoot access to files and shared folders.
• Managing and Maintaining a Server Environment
• Manage servers remotely.
• Configure access to shared folders.
• Manage shared folder permissions.
• Monitor system performance.
• Monitor and optimize a server environment for application performance.
• Manage a Web server.
• Manage security for IIS.
• Managing and Implementing Disaster Recovery
• Manage backup procedures.
• Recover from server hardware failure.
• Restore backup data.
| 70-293: Planning, Maintaining a Windows Server 2003 Network Infrastructure |
• Planning and Implementing Server Roles and Server Security
• Configure security for servers that are assigned specific roles.
• Plan a secure baseline installation.
• Plan security for servers that are assigned specific roles.
• Planning, Implementing, and Maintaining a Network Infrastructure
• Analyze IP addressing requirements.
• Plan and modify a network topology.
• Plan an Internet connectivity strategy.
• Troubleshoot TCP/IP addressing.
• Plan a host name resolution strategy.
• Plan a NetBIOS name resolution strategy.
• Troubleshoot host name resolution.
• Planning, Implementing, and Maintaining Routing and Remote Access
• Plan security for remote access users.
• Implement secure access between private networks.
• Troubleshoot TCP/IP routing. Tools might include the route, tracert, ping, pathping
• Implement a cluster server.
• Manage Network Load Balancing. Tools might include the Network Load Balancing Monitor.
• Planning and Maintaining Network Security
• Configure security for data transmission.
• Plan for network protocol security.
• Plan secure network administration methods.
• Plan security for wireless networks.
• Troubleshoot security for data transmission.
• Plan a framework for planning and implementing security.
• Plan a security update infrastructure.
| |
MCP
