信息来源：邪恶八进制信息安全团队（
www.eviloctal.com）
Microsoft微软专业认证之MCDBA （Microsoft Certfied Datebase Administrator）
SQL Server 2000 透过网站搜寻、分析及管理資料。在封闭式的系統中， 以 XML 格式交換数据。轻易且安全地存取数据以浏览器透过防火墙，快速对格式化的文件做全文检索。甚至进行线上分析 (OLAP) 也透过网站。透过点选分析，來了解您的网站使用者。
SQL Server 2000 高度延展性及可靠性的特点，使得数据库可以无限制成长。切割您的数据库負荷至分散的应用软件中。充分发挥对称性出理架构与 Microsoft Windows 2000 Datacenter 的优点。支持到 32 个CPUs 与 64 GB RAM 的服务器操作系統。
由于微软专业人员监定考试是一项全球性统一的验证资格测验，通过测验成为 「软件工程师」的专业人员，将由微软总公司寄发资格证明书与徽章，并有权将 Microsoft Certified Professional 的标记印在个人名片上使用，且通行全世界，代表著个人技术能力的肯定。取得MCDBA是代表您已具有：
1. 建置、管理Microsoft SQL Server资料库这方面的能力。
2. 建构实际资料库设计、开发资料库的逻辑模型、开发实体的资料库、设计使用Transact- SQL来管理与维护资料库、并设定与管理资料库的安全性、监控资料库并使资料库最佳化，及 SQL Server安装及设定。
适合人仕 :
有志投身 I.T. 界的人仕，程式设计员，数据库管理員，系統工程師。
修读条件 :
具有基础 Windows 操作经验， 拥有数据库设置的简单概念。对数据库系統及网络具有浓厚兴趣
MCDBA 2003 考试科目 (共四科)
数据库管理考試
(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
課程內容 :
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.
