Exam 70-431: TS: Microsoft SQL Server 2005: Implementation and Maintenance Curriculum Outline
SQL Server 2005 High Availability and Disaster Recovery
Overview/DescriptionTo implement database mirroring, log shipping, database snapshots, and data replication in SQL Server 2005
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
3 Hours
SQL Server 2005 High Availability and Disaster Recovery
- Recognize the features and functionality of database mirroring
- Configure database mirroring in a given scenario
- Configure database mirroring in SQL Server 2005
- Configure and monitor log shipping in a given scenario
- Configure log shipping options in SQL Server 2005
- Configure database snapshots in a given scenario
- Configure data replication in a given scenario
- Manage replication in SQL Server 2005, given a scenario
- Set up data replication in SQL Server 2005
Back to List
SQL Server 2005 Backup and Restores
Overview/DescriptionTo back up and restore a database in SQL Server 2005
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
1.75 Hours
SQL Server 2005 Backup and Restores
- Determine the appropriate recovery model and backup strategy for a given scenario
- Perform database backups in a given scenario
- Back up a SQL Server database
- Restore a SQL Server backup in a given scenario
- Move a SQL Server database in a given scenario
- Perform a database restore in SQL Server 2005
Back to List
Installing SQL Server 2005
Overview/DescriptionTo install SQL Server 2005 and upgrade to SQL Server 2005 from previous versions
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
3 Hours
Installing SQL Server 2005
- Recognize how SQL Server 2005 can help improve enterprise data management, developer productivity, and business intelligence
- Differentiate between the components and services provided by SQL Server 2005
- Distinguish between SQL Server 2005 management tools
- Identify the requirements and considerations for installing SQL Server 2005
- Configure a SQL Server 2005 installation in a given scenario
- Install SQL Server 2005
- Select the appropriate SQL Server 2005 upgrade path for a given scenario
- Perform the steps to upgrade to SQL Server 2005
- Upgrade to SQL Server 2005
Back to List
Creating and Implementing Database Objects in SQL Server 2005
Overview/DescriptionTo create and implement key database objects in SQL Server 2005
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
3.25 Hours
Creating and Implementing Database Objects in SQL Server 2005
- Create a database table in SQL Server 2005, given a scenario
- Create a database view in a given scenario
- Create a database table and a database view
- Identify recommended guidelines for designing indexes
- Create a database index in a given scenario
- Create an online index in SQL Server 2005
- Create functions and triggers in a given scenario
- Create stored procedures in a given scenario
- Manage stored procedures in a given scenario
- Create and implement a stored procedure
Back to List
SQL Server 2005 Database Performance and Optimization
Overview/DescriptionTo 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
2.50 Hours
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
Back to List
Configuring SQL Server 2005
Overview/DescriptionTo configure a SQL Server instance and create a database, configure logins, users, and schemas for a database, and set up a linked server configuration
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
3 Hours
Configuring SQL Server 2005
- Use SQL Server Surface Area Configuration to configure a SQL Server 2005 installation
- Create a SQL Server database in a given scenario
- Create a database in SQL Server 2005
- Recognize the security functionality of the SQL Server 2005 Database Engine
- Create logins and grant permissions in a given scenario
- Create logins, users, and schemas in SQL Server 2005
- Recognize the security mechanisms provided by encryption, the TRUSTWORTHY database property, and execution context in SQL Server 2005
- Recognize how SQL Server 2005 can access data from OLE DB data sources on remote servers using a linked server configuration
- Use SQL Server Management Studio to configure a linked server in a given scenario
- Configure a linked server using SQL Server Management Studio
Back to List
Retrieving Data and Running Queries in SQL Server 2005
Overview/DescriptionTo perform relational data and XML data management tasks, and work with assemblies and transactions in SQL Server 2005
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
3 Hours
Retrieving Data and Running Queries in SQL Server 2005
- Retrieve data from a database in a given scenario
- Modify data from a relational database in a given scenario
- Use queries to retrieve and modify data in a SQL Server database
- Retrieve, insert, and convert XML data in SQL Server 2005
- Create and secure an HTTP endpoint in a given scenario
- Work with XML data in SQL Server 2005
- Create and modify an assembly in a given scenario
- Control SQL Server transactions in a given scenario
- Manage transactions in SQL Server 2005
Back to List
SQL Server 2005 Messaging and Querying Tools
Overview/DescriptionTo implement Service Broker components and use full-text search in SQL Server 2005
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
2 Hours
SQL Server 2005 Messaging and Querying Tools
- Create Service Broker components in a given scenario
- Create a Service Broker service
- Recognize the routing, networking, and security features provided by Security Broker
- Identify the features of Full-Text Searches and recognize considerations for implementing them
- Create and troubleshoot full-text queries in a given scenario
- Use full-text search to query SQL Server 2005
Back to List
Managing and Maintaining SQL Server 2005 Databases
Overview/DescriptionTo manage and maintain SQL Server 2005 databases
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
3.25 Hours
Managing and Maintaining SQL Server 2005 Databases
- Export bulk data in SQL Server 2005 in a given scenario
- Import bulk data into SQL Server 2005 in a given scenario
- Import and export bulk data in SQL Server 2005
- Create and manage jobs using SQL Server Agent
- Configure alerts using SQL Server Agent in a given scenario
- Configure operators using SQL Server Agent in a given scenario
- Perform management and monitoring tasks using the SQL Server Agent service
- Perform database management tasks in SQL Server 2005, given a scenario
- Perform the steps required to shrink a database in a given scenario
- Check and maintain database integrity in SQL Server 2005
Back to List
Monitoring and Diagnosing Database Problems in SQL Server 2005
Overview/DescriptionTo monitor and resolve database blocks, and connect to the server using a dedicated administrator connection (DAC)
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
1.25 Hours
Monitoring and Diagnosing Database Problems in SQL Server 2005
- Recognize how locking is used to secure data integrity in a SQL Server database
- Detect and end deadlocks and blocking connections in a given scenario
- Detect and terminate a transaction lock
- Connect to the server using the dedicated administrator connection (DAC) in a given scenario
- Connect to a non-responsive database using the dedicated administrator connection (DAC)
Back to List
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 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
2.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 List
Designing 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 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
3 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 List
Designing 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 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
2.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 List
Designing 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 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
2.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 List
Designing 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 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
1.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 List
Designing 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 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
2.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 Audience
Professionals pursuing a career as a Database Administrator
Expected Duration
2.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 List
Monitoring 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 Audience
Professionals pursuing a career as a Database Administrator
Expected Duration
3 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 List
Optimizing SQL Server 2005 Performance
Overview/DescriptionTo identify ways of optimizing the performance of SQL Server 2005
Target Audience
Professionals pursuing a career as a Database Administrator
Expected Duration
3 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 List
Optimizing 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 Audience
Professionals pursuing a career as a Database Administrator
Expected Duration
2 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 List
Managing 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 Audience
Professionals pursuing a career as a Database Administrator
Expected Duration
3.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 List
Managing 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 Audience
Professionals pursuing a career as a Database Administrator
Expected Duration
2.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
Exam 70-447: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005 Curriculum Outline
Designing a Database Server Infrastructure for SQL Server 2005
Overview/Description
To 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
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005
Designing a Database Server Infrastructure for SQL Server 2005
Back to List
Designing Security for a Database Server Infrastructure for SQL Server 2005
Overview/Description
To identify business security requirements, select the appropriate authentication method, and specify a security design for different levels of the SQL Server environment
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005
Designing Security for a Database Server Infrastructure for SQL Server 2005
Back to List
Designing the Physical Database for SQL Server 2005
Overview/Description
To identify physical database requirements, select the appropriate strategy for designing database objects, and determine suitable database naming standards and change control procedures
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005
Designing the Physical Database for SQL Server 2005
Back to List
Designing a Database Server High Availability Solution for SQL Server 2005
Overview/Description
To select the appropriate database storage design for a high availability scenario and identify a suitable replication solution
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005
Designing a Database Server High Availability Solution for SQL Server 2005
Back to List
Designing a Database Failover Solution for SQL Server 2005
Overview/Description
To identify the appropriate cluster configuration solution, database mirroring solution, and log shipping solution for a database
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005
Designing a Database Failover Solution for SQL Server 2005
Back to List
Designing a Database Server Data Recovery Solution for SQL Server 2005
Overview/Description
To select the appropriate data backup and recovery solution for a SQL Server 2005 database
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005
Designing a Database Server Data Recovery Solution for SQL Server 2005
Back to List
Optimizing SQL Server 2005 Performance
Overview/Description
To identify ways of optimizing the performance of SQL Server 2005
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.
Optimizing SQL Server 2005 Performance
Back to List
Optimizing a Database Data Recovery Plan for SQL Server 2005
Overview/Description
To identify potential causes of database failure, and select the appropriate fault tolerance and restore strategies for a scenario
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.
Optimizing a Database Data Recovery Plan for SQL Server 2005
Back to List
Monitoring and Maintaining a Database in SQL Server 2005
Overview/Description
To monitor a database, automate database maintenance tasks, and configure reporting services for SQL Server 2005
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.
Monitoring and Maintaining a Database in SQL Server 2005
Back to List
Managing Data Between Servers and Databases
Overview/Description
To recognize how to manage change, configure and work with linked servers, and manage and tune replication in SQL Server 2005
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.
Managing Data Between Servers and Databases
Back to List
Managing and Maintaining Database Security in SQL Server 2005
Overview/Description
To 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
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.
Managing and Maintaining Database Security in SQL Server 2005
Back to List
Managing Database Data in a SQL Server 2005 Environment
Overview/Description
To recognize how to create and deploy SSIS packages, and enforce data quality and data integrity in a SQL Server 2005 database
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.
Managing Database Data in a SQL Server 2005 Environment
Back to List
Microsoft MCITP Database Administrator Certification
(Microsoft Certified IT Professional)
Microsoft Certified IT Professional (MCITP): Database Administrator is the premier certification for database server
administrators. This certification demonstrates that you can keep up with your enterprise business solutions 24 hours a day,
7 days a week. Earning the MCITP Certification highlights your expertise and distinguishes you as an IT professional with current
skills and proven job-role capabilities to work effectively with a comprehensive set of Microsoft database technologies.
Database administrators install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. They also design or implement security or server automation and monitor and troubleshoot SQL Server activity. Database administrators are typically employed by mid-sized to large organizations.
Benefits of CBT Direct’s Online Microsoft MCITP Certification Training
CBT Direct boasts the most beneficial online certification training on the market. With online training, you have
the flexibility to study on your schedule, and with the speed and reliability of the internet, CBT Direct’s Microsoft MCITP
training course is accessible anywhere you have an internet connection. Convenience finally costs less with CBT Direct –
the most affordable online training solution today. CBT Direct is also a Microsoft Certified Partner.
The unique design of CBT Direct’s Microsoft MCITP certification course incorporates a proven four-step learning process: presentation, demonstration, guidance and independent practice. This four-step proven learning model for CBT Direct’s Microsoft MCITP training course ensures the greatest level of retention to prepare you for your Microsoft MCITP certification exam.
CBT Direct also offers online mentoring for over 100 current major certification exams, including Microsoft MCITP, for IT
professionals and end-users alike. CBT Direct’s mentors have a minimum of 20 certifications each and are available 24/7*.
* Available for most courses.
Who Benefits from CBT Direct’s Microsoft MCITP Training?
This training would be beneficial for individuals looking for IT job positions such as; SQL Database Administrator or a Database Manager.
What Professionals Will Learn from CBT Direct’s Microsoft
MCITP Training
To earn this certification, you must pass three exams: one Microsoft Certified Technology Specialist (MCTS) prerequisite exam and two Professional Series exams.
Exam 70-431: TS: Microsoft SQL Server 2005: Implementation and Maintenance
This course provides students with the knowledge to install and configure SQL Server 2005 and to set up tables, indexes, columns,
and constraints. You will also learn how to use Transact-SQL to implement functions, stored procedures, and triggers. The training
will also teach you how to work with relational and XML data, monitor, troubleshoot, and tune queries. The course also includes how to
maintain database availability with log shipping, mirroring, and replication and prepare a backup strategy and restore a database.
Click here to see a detailed curriculum outline.
Exam 70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
This course provides students with the knowledge to install, consolidate, and configure multiple database instances and to design
tables, file groups, and indexes for a physical database. You will also be taught to develop and implement security policies at the
server, database, and object levels, design, implement, and configure clustering, log shipping, mirroring, and replication. Lastly you
will learn to develop plans for data archiving, backups, and disaster recovery. Click here to see a detailed curriculum outline.
Exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
This course provides students with the knowledge to monitor and troubleshoot queries, databases, and servers as well as manage
security strategies and perform audits. You will learn to help defend against attacks, worms, and viruses and detect and resolve
data conflicts. This course will also cover how to diagnose faults and recover from database failures and disasters while teaching
how to optimize availability with failover clustering, mirroring, log shipping, and replication. Lastly, how to customize maintenance
and automate routine tasks, build, debug, and deploy SQL Server Integration Services packages. Click here to see a detailed curriculum outline.
If you are already MCDBA certified, then only the following exam is required to become MCITP DBA certified:
Exam 70-447 UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft
SQL Server 2005
This course provides students with the knowledge to design a Database Server Infrastructure, design Security for a Database Server
Infrastructure, design the Physical Database, design a Database Server High Availability Solution, design a Database Failover
Solution and design a Database Server Data Recovery Solution for SQL Server 2005. You will also learn how to optimize the SQL
Server performance, optimize for a database data recovery plan and how to monitor and maintain a database. This training also
covers managing database data, managing data between servers and databases and the managing and maintaining of database security
in SQL Server 2005.Click here to see a detailed curriculum outline.
Exam#
Certification
Certified Mentoring
Hours
Hours
24x7
Mon-Fri
(9-5 EST)
(9-5 EST)
Tier 3
TestPrep
| 70-431 | Microsoft MCTS: Microsoft SQL Server 2005 - Implementation and Maintenance | ü | ü | |
| 70-443 | Microsoft MCITP PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 | ü | ü | |
| 70-444 | Microsoft MCITP PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 | ü | ü |
Exam 70-431: TS: Microsoft SQL Server 2005: Implementation and Maintenance
Exam 70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
Exam 70-444: PRO: Optimizing Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
Exam 70-447: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using
Microsoft SQL Server 2005
