Exam 70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 Curriculum Outline
Designing a Database Failover Solution for SQL Server 2005
Overview/DescriptionTo identify the appropriate cluster configuration solution, database mirroring solution, and log shipping solution for a database
Target AudienceProfessionals 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
PrerequisitesThis 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 Duration2.25 Hours
Designing a Database Failover Solution for SQL Server 2005 - Identify the considerations involved in designing a Microsoft cluster service
- Recognize how to install failover clustering for SQL Server 2005
- Determine the appropriate cluster configuration to implement, given a scenario
- Recognize how server role switching works in database mirroring
- Recognize the considerations involved in designing a database mirroring strategy
- Determine a database mirroring solution for a given scenario
- Identify the considerations involved in designing a log shipping strategy
- Determine the appropriate log shipping solution for a given scenario
Back to ListDesigning Security for a Database Server Infrastructure for SQL Server 2005
Overview/DescriptionTo identify business security requirements, select the appropriate authentication method, and specify a security design for different levels of the SQL Server environment
Target AudienceProfessionals 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
PrerequisitesThis 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 Duration3 Hours
Designing Security for a Database Server Infrastructure for SQL Server 2005 - Identify security requirements when designing a SQL Server environment for a given business scenario
- Determine security recommendations when designing a SQL Server environment for a given business scenario
- Identify the authentication requirements of a given enterprise scenario
- Determine the appropriate authentication method for a given SQL Server enterprise scenario
- Identify best practices when designing Windows password policies for the SQL Server environment in a given scenario
- Identify best practices when designing Windows services and securing the network for the SQL Server environment
- Identify the considerations involved in designing service-level security for the SQL Server environment in a given scenario
- Identify the considerations involved in designing database-level security for the SQL Server environment, given a scenario
- Identify the considerations involved in designing object-level security for the SQL Server environment, given a scenario
- Determine the appropriate security strategy for SQL Server in a given enterprise scenario
Back to ListDesigning a Database Server Infrastructure for SQL Server 2005
Overview/DescriptionTo specify the appropriate requirements for implementing SQL Server 2005, identify suitable instance and physical storage strategies, and determine the appropriate way to design a database consolidation plan, given a SQL Server scenario
Target AudienceProfessionals 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
PrerequisitesThis 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 Duration2.25 Hours
Designing a Database Server Infrastructure for SQL Server 2005 - Identify the infrastructure requirements for implementing SQL Server 2005 database server in a given scenario
- Determine the appropriate configuration requirements of a given SQL Server 2005 implementation scenario
- Identify an appropriate SQL Server instance deployment strategy for a given scenario
- Identify the appropriate physical storage strategy for SQL Server 2005 in a given scenario
- Determine the appropriate instance and physical storage strategies to implement for a specific SQL Server deployment scenario
- Identify issues to be taken into consideration when gathering information for consolidation
- Identify the steps involved in designing a SQL Server consolidation strategy, given a specific database scenario
- Determine the appropriate strategy for designing a migration plan for a consolidated environment, given a specific SQL Server database scenario
Back to ListDesigning the Physical Database for SQL Server 2005
Overview/DescriptionTo identify physical database requirements, select the appropriate strategy for designing database objects, and determine suitable database naming standards and change control procedures
Target AudienceProfessionals 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
PrerequisitesThis 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 Duration2.75 Hours
Designing the Physical Database for SQL Server 2005 - Identify considerations when designing the physical structure of a database in a given scenario
- Recognize how to normalize and document a database in a given scenario
- Determine how to improve a database design for performance using normalization, given a scenario
- Identify the appropriate strategy for designing filegroups in a given database scenario
- Identify the appropriate strategy for designing tables in a given database scenario
- Identify the appropriate strategy for designing indexes and views, given a scenario
- Determine the appropriate strategy for designing database objects in a given scenario
- Recognize best practices for using naming conventions and standards in a given scenario
- Recognize best practices for establishing a database change control procedure for a given scenario
- Determine the appropriate database naming standards and change control procedures to use in a given scenario
Back to ListDesigning a Database Server High Availability Solution for SQL Server 2005
Overview/DescriptionTo select the appropriate database storage design for a high availability scenario and identify a suitable replication solution
Target AudienceProfessionals 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
PrerequisitesThis 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 Duration1.75 Hours
Designing a Database Server High Availability Solution for SQL Server 2005 - Determine the appropriate RAID solution to implement in a given SQL Server scenario
- Identify how to implement a SAN solution for high availability in a given scenario
- Determine the appropriate database storage solution for a high availability scenario
- Select the appropriate replication solution for a scenario
- Identify a strategy for implementing replication in a given scenario
- Determine a database replication strategy for a specified scenario
Back to ListDesigning a Database Server Data Recovery Solution for SQL Server 2005
Overview/DescriptionTo select the appropriate data backup and recovery solution for a SQL Server 2005 database
Target AudienceProfessionals 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
PrerequisitesThis 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 Duration2.25 Hours
Designing a Database Server Data Recovery Solution for SQL Server 2005 - Identify the data recovery requirements of a given business scenario and determine the appropriate recovery model to use
- Identify considerations for designing an appropriate backup strategy for a given database scenario
- Identify database backup considerations
- Determine the appropriate backup strategy for a database scenario
- Identify considerations for designing a disaster recovery plan
- Identify the appropriate restore strategy for a given database scenario
- Determine a recovery strategy for a given database scenario
Back to List
Exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 Curriculum Outline
Managing and Maintaining Database Security in SQL Server 2005
Overview/DescriptionTo identify strategies for auditing database security at the server and user levels, and determine the appropriate way to protect against and respond to different types of attack on SQL Server
Target AudienceProfessionals pursuing a career as a Database Administrator
Expected Duration2.50 Hours
Managing and Maintaining Database Security in SQL Server 2005- Identify an appropriate strategy for auditing access to SQL Server at the server level, given a scenario
- Identify considerations for choosing an encryption algorithm, and recognize how to use the Microsoft Baseline Security Analyzer and SQL Server Surface Area Configuration tools to secure SQL Server
- Determine an appropriate strategy for monitoring and auditing SQL Server access in a given scenario
- Recognize strategies for auditing user access to SQL Server in a given scenario
- Recognize how to verify account policies and user accounts in SQL Server 2005, given a scenario
- Use stored procedures and views to verify account policy and user account information in SQL Server 2005
- Recognize how to protect SQL Server against SQL injection and DoS attacks
- Recognize how to protect SQL Server against viruses, worms, and internal attacks
- Determine how to protect against and respond to attacks on SQL Server, given a scenario
Back to ListMonitoring and Maintaining a Database in SQL Server 2005
Overview/DescriptionTo monitor a database, automate database maintenance tasks, and configure reporting services for SQL Server 2005
Target AudienceProfessionals pursuing a career as a Database Administrator
Expected Duration3 Hours
Monitoring and Maintaining a Database in SQL Server 2005- Identify the steps for establishing a performance baseline
- Use SQL Server Profiler to monitor a database in a given scenario
- Recognize how to tune a database using the Database Engine Tuning Advisor in a given scenario
- Monitor and tune a database using SQL Server Profiler and Database Engine Tuning Advisor
- Recognize how to automate database administration tasks using SQL Server Agent in a given scenario
- Recognize how to create alerts and operators in a given scenario
- Create and implement a database maintenance strategy for a given scenario
- Recognize how to use the Maintenance Plan Wizard to automate database maintenance tasks
- Manage reports in SQL Server 2005
- Configure reporting services in SQL Server 2005
Back to ListOptimizing SQL Server 2005 Performance
Overview/DescriptionTo identify ways of optimizing the performance of SQL Server 2005
Target AudienceProfessionals pursuing a career as a Database Administrator
Expected Duration3 Hours
Optimizing SQL Server 2005 Performance - Recognize how to optimize server performance using memory configuration options in a given scenario
- Recognize how to optimize server performance using I/O configuration options and Windows options in a given scenario
- Recognize how to troubleshoot database performance in a given scenario
- Troubleshoot the performance of SQL Server 2005 in a given scenario
- Troubleshoot and analyze query performance in a given scenario
- Optimize database indexes in a given scenario
- Recognize how to optimize stored procedures in a given scenario
- Identify considerations when managing concurrent data access in a given database scenario
- Identify and troubleshoot query performance issues in SQL Server 2005
Back to ListOptimizing a Database Data Recovery Plan for SQL Server 2005
Overview/DescriptionTo identify potential causes of database failure, and select the appropriate fault tolerance and restore strategies for a scenario
Target AudienceProfessionals pursuing a career as a Database Administrator
Expected Duration2 Hours
Optimizing a Database Data Recovery Plan for SQL Server 2005 - Identify and troubleshoot the causes of database failure in a given scenario
- Recognize how to install failover clustering for high availability and fault tolerance
- Recognize how to set up database mirroring for fault tolerance, given a scenario
- Determine and configure the appropriate fault tolerance plan for a scenario
- Identify considerations for recovering from a database disaster in a given scenario
- Identify and implement the appropriate restore strategy to recover a database in a given scenario
- Determine how best to recover data following a given database disaster scenario
Back to ListManaging Database Data in a SQL Server 2005 Environment
Overview/DescriptionTo recognize how to create and deploy SSIS packages, and enforce data quality and data integrity in a SQL Server 2005 database
Target AudienceProfessionals pursuing a career as a Database Administrator
Expected Duration3.25 Hours
Managing Database Data in a SQL Server 2005 Environment - Recognize how to create an SSIS package in a given scenario
- Recognize how to run, configure, and troubleshoot SSIS packages in a given scenario
- Recognize how to deploy SSIS packages in a given scenario
- Create and deploy an SSIS package in a given scenario
- Recognize how to use DML and DDL triggers to enforce data quality in a SQL Server 2005 database
- Recognize how to configure the page_verify option to enforce data quality in a given scenario
- Configure database options to enforce data quality in a SQL Server 2005 database
- Recognize how data types are used to enforce data integrity in SQL Server 2005
- Recognize how to enforce data integrity using constraints, given a scenario
- Enforce data integrity within a SQL Server 2005 database
Back to ListManaging Data Between Servers and Databases
Overview/DescriptionTo recognize how to manage change, configure and work with linked servers, and manage and tune replication in SQL Server 2005
Target AudienceProfessionals pursuing a career as a Database Administrator
Expected Duration2.50 Hours
Managing Data Between Servers and Databases - Identify considerations for managing change in the SQL Server 2005 environment, given a scenario
- Determine the appropriate change control strategy for a given scenario
- Recognize how to configure a linked server in a given scenario
- Recognize how to query data on a linked server in a given scenario
- Work with linked servers in a given scenario
- Recognize how to monitor replication in a given scenario
- Recognize how to modify replication configuration and resolve replication conflicts in a given scenario
- Tune a replication configuration in a given scenario
Back to List
Microsoft MCITP Certifications
(Microsoft Certified IT Professional)
Microsoft Certified IT Professional (MCITP) certifications demonstrate comprehensive skills in planning, deploying,
supporting, maintaining, and optimizing IT infrastructures. Earning the Microsoft Certified IT Professional (MCITP)
certification highlights your field of expertise and helps distinguish you as an IT professional with current skills
and proven job-role capabilities to work effectively with a comprehensive set of Microsoft technologies.
Take a look at the different MCITP certifications below and click on the link after the list of exams for each
certification to learn more.
Microsoft Certified IT Professional (MCITP): Enterprise Administrator
The Microsoft Certified IT Professional (MCITP) Certification is the leading credential for Windows Server 2008.
It provides a widely recognized validation of the ability to perform critical and current IT job roles by using
Microsoft technologies to their best advantage. Enterprise administrators are recognized as leaders in Windows
infrastructure design. Earning the MCITP Enterprise Administrator certification, distinguishes you as an IT professional
committed to excellence in working with Windows Server 2008.
The following exams are required:
- Exam 70-620: TS: Windows Vista, Configuring
- Exam 70-640: TS: Windows Server 2008 Active Directory, Configuring
- Exam 70-642: TS: Windows Server 2008 Network Infrastructure, Configuring
- Exam 70-643: TS: Windows Server 2008 Applications Infrastructure, Configuring
- Exam 70-680: TS: Windows 7, Configuring
- Exam 70-647: PRO: Windows Server 2008, Enterprise Administrator
- Click here for more information about these exams.
Microsoft Certified IT Professional (MCITP): Enterprise Desktop Administrator 7
Microsoft Certified IT Professional (MCITP) certifications demonstrate comprehensive skills in planning, deploying,
supporting, maintaining, and optimizing IT infrastructures. Earning the Microsoft Certified IT Professional (MCITP)
certification highlights your field of expertise and helps distinguish you as an IT professional with current skills
and proven job-role capabilities to work effectively with a comprehensive set of Microsoft technologies.
The MCITP: Enterprise Desktop Administrator 7 validates an IT Professional’s ability to deploy desktop applications and
operating systems and manage the client life cycle. MCITP Enterprise Desktop Administrator 7 builds on the technical
proficiency needed to become certified as an MCTS (Microsoft Certified Technology Specialist). IT Professionals will
therefore earn one or more MCTS certifications as they earn an MCITP certification.
The following exams are required:
- Exam 70-680: TS: Windows 7, Configuring
- Exam 70-686: Pro: Windows 7, Enterprise Desktop Administrator
- Click here for more information about these exams.
Microsoft Certified IT Professional (MCITP): Enterprise Support Technician
The Microsoft Certified IT Professional: Enterprise Support Technician Certification validates that you have the knowledge and
skills required to deploy and support the Windows Vista operating system. The MCITP: Enterprise Support Technician credentials
show you have expertise in deploying Windows Vista, managing security, and troubleshooting network issues.
The following exams are required:
- Exam 70-620: TS: Windows Vista, Configuring
- Exam 70-622: PRO: Supporting and Troubleshooting Applications on a Windows
Vista Client for Enterprise Support Technicians
- Click here for more information about these exams.
Microsoft Certified IT Professional (MCITP): Server Administrator
The Microsoft Certified IT Professional (MCITP) Certification is the leading credential for Windows Server 2008. It
provides a widely recognized validation of the ability to perform critical and current IT job roles by using Microsoft
technologies to their best advantage. Server Administrators are recognized as leaders in Windows infrastructure design.
Earning the MCITP Server Administrator certification, distinguishes you as an IT professional committed to excellence in
working with Windows Server 2008.
The following exams are required:
- Exam 70-640: TS: Windows Server 2008 Active Directory, Configuring
- Exam 70-642: TS: Windows Server 2008 Network Infrastructure, Configuring
- Exam 70-646: PRO: Windows Server 2008, Server Administrator
- Click here for more information about these exams.
