70-443 - PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
Retired. This product is no longer available.
uCertify uses content from well known publishers, instructors, and subject matter experts. They have a minimum of 15 years of experience in their fields. uCertify brings these textbooks to life. It is full of interactive activities that keeps the learner engaged. uCertify brings all available learning resources for a topic in one place so that the learner can efficiently learn without going to multiple places. Challenge questions are also embedded in the chapters so learners can attempt those while they are learning about that particular topic. This helps them grasp the concepts better because they can go over it again right away which improves learning. Learners can do Flashcards, Exercises, Quizzes and Labs related to each chapter. At the end of every lesson, uCertify courses guide the learners on the path they should follow.
uCertify platform supports 50+ different types of interactive activities, connect the idea, or try it yourself lab activities embedded throughout its course. These interactive activities keeps learners engaged and makes learning fun.
Here's What You Get
Each lesson comes with Exercises, Flashcards & Quizzes. There is no limit to the number of times learners can attempt these. Exercises come with detailed remediation, which ensures that learners are confident on the topic before proceeding. Flashcards help master the key concepts while Glossary defines the key terms.
Here's What you will Learn
Lesson 1: Designing a Database Server Infrastructure
- Design for capacity requirements.
- Specify software versions and hardware configurations.
- Design physical storage.
- Design instances.
- Design a database consolidation strategy.
Lesson 2: Design Security for a Database Server Solution
- Analyze business requirements.
- Integrate database security with enterprise-level authentication systems.
- Develop Microsoft Windows server-level security policies.
- Modify the security design based on the impact of network security policies.
- Analyze the risk of attacks to the server environment and specify mitigations.
- Design SQL Server service-level security.
- Design database-level security.
- Design object-level security.
Lesson 3: Designing a Physical Database
- Modify an existing database design based on performance and business requirements.
- Design tables.
- Design file groups.
- Design index usage.
- Design views.
- Create database conventions and standards.
- Create database change control procedures.
Lesson 4: Design a Database Solution for High Availability
- Select high-availability technologies based on business requirements.
- Develop a strategy for migration to a highly available environment.
- Design a highly available database storage solution.
- Design a database-clustering solution.
- Design database mirroring.
- Design a high-availability solution that is based on replication.
- Design log shipping.
Lesson 5: Design a Data Recovery Solution for a Database
- Specify data recovery technologies based on business requirements.
- Design backup strategies.
- Create a disaster recovery plan.
Lesson 6: Designing a Strategy for Data Archiving
- Select archiving techniques based on business requirements.
- Design the format of archival data.
- Specify what data to archive.
- Plan for data archival and access.
- Design the topology of replication for archiving data.
- Design the type of replication for archiving data.
Test Prep & Practice Questions
uCertify provides full length practice tests. These tests closely follow the exam objectives and are designed to simulate real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure that learners are prepared for the certification exam.
Here's What You Get
Each question comes with detailed remediation explaining not only why an answer option is correct but also why the incorrect answer options are incorrect.
Each test can be taken unlimited number of times until the learner feels they are prepared. Learner can review the test and read detailed remediation. Detailed test history is also available.
Each test set comes with learn, test and review modes. In learn mode, learners will attempt a question and will get immediate feedback and complete remediation as they move on to the next question. In test mode, learners can take a timed test simulating the actual exam conditions. In review mode, learners can read through one item at a time without attempting it.
The certification is targeted at Database Administrators involved with installing or configuring Microsoft SQL Server 2005 and managing or maintaining databases or multidimensional databases. The exam covers how to define high-availability solutions, automate administrative tasks, define security solutions, monitor and troubleshoot the database server, design and execute deployments, define the infrastructure.
A Microsoft MCITP: Databse Administrator certified professional has several career opportunities open up to them, including:
- Database Administrators
- Database Developers
- Application Developers
(on a scale of 0-1000)
In the event that you fail your first attempt at passing the MCITP certification, Microsoft's retake policy is:
- If a candidate does not achieve a passing score on an exam the first time, he must wait at least a 24-hour period before retaking the exam.
- If a candidate does not achieve a passing score the second time, the candidate must wait at least a 14-day period before retaking the exam a third time.
- A 14-day waiting period will also be imposed for the fourth and fifth subsequent exam retakes.
- A candidate may not take a given exam any more than five times per year (12 months). This 12-month period would start the day of the fifth unsuccessful exam retake.
- The candidate would then be eligible to retake the exam 12 months from that date. In order to take a given exam more than five times per year, a candidate must submit a request and obtain prior permission from Microsoft.