Microsoft SQL Server 2005 Design MCITP 70-443 Course

Total Items: 14 Total Time: 16.00 hour(s)

Summary:

This training provides you with a study guide to prepare to become certified as a Microsoft Certified IT Professional: Database Administrator. PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 (70-443), will cover your ability to maintain everyday operations of enterprise Microsoft SQL Server 2005 databases.

Practice exams are also included, which will allow you to answer questions in the same format that the test will use on exam day, and will provide in-depth instructional feedback on each question to thoroughly cover every subject you'll need to master.

Learning Segment 1 : Designing the Hardware and Software Infrastructure :

Summary:

This learning segment covers planning and designing a database infrastructure.

Objectives:

• Design for capacity requirements Specify software versions and hardware configurations

Topics:

Learning Segment 2 : Designing Physical Storage :

Summary:

This learning segment covers how to best design and organize physical storage.

Objectives:

• Design physical storage Design instances

Topics:

Learning Segment 3 : Designing a Consolidation Strategy :

Summary:

This learning segment covers developing a database consolidation strategy.

Objectives:

• Design a database consolidation strategy

Topics:

Learning Segment 4 : Designing Database-Level Security :

Summary:

This learning segment covers designing an effective database-level security policy for SQL Server 2005 instances.

Objectives:

• Analyze business requirements Integrate database security with enterprise-level authentication systems Modify the security design based on the impact of network security policies Analyze the risk of attacks to the server environment and specify mitigations

Topics:

Learning Segment 5 : Designing Windows Server-Level Security Processes

Summary:

This learning segment covers how the server-wide security parameters of SQL Server are determined and set globally for each instance.

Objectives:

• Develop Microsoft Windows server-level security policies

Topics:

Learning Segment 6 : Designing SQL Server Service-Level Security

Summary:

This learning segment covers server-level SQL Server security items that affect the entire database service.

Objectives:

• Design SQL Server service-level security Design database-level security

Topics:

Learning Segment 7 : Designing SQL Server Object-Level Security

Summary:

This learning segment covers the lowest level of security - the objects that store and interact with data.

Objectives:

• Develop object-level security

Topics:

Learning Segment 8 : Designing a Physical Database :

Summary:

This learning segment covers creating, configuring, and administering databases in order to maximize their performance.

Objectives:

• Modify an existing database design based on performance and business requirements Design tables and filegroups Design index usage and views

Topics:

Learning Segment 9 : Creating Database Conventions and Standards :

Summary:

This learning segment covers database conventions and standards.

Objectives:

• Create database conventions and standards Create database change control procedures

Topics:

Learning Segment 10 : Designing a SQL Server 2005 Solution for High Availability :

Summary:

This learning segment covers the technologies used in SQL Server to achieve a highly available database server.

Objectives:

• Develop a strategy for migration to a highly available environment Design a highly available database storage solution Design a database-clustering and database mirroring solutions Design a high-availability solution based on replication

Topics:

Learning Segment 11 : Designing a Data Recovery Solution for a Database

Summary:

This learning segment covers planning a data recovery strategy for databases, including a backup and restore plan.

Objectives:

• Specify data recovery technologies based on business requirements Design backup strategies Create a disaster recovery plan

Topics:

Learning Segment 12 : Designing a Data-Archiving Solution :

Summary:

This learning segment covers designing a data-archiving solution.

Objectives:

• Select archiving techniques based on business requirements Design the format of archival data Specify what data to archive and plan for data archival and access Design the topology and type of replication for archiving data

Topics:

Learning Segment 13 : Practice Exam 1

Summary:

• This learning segment presents questions that will help you prepare for the MCITP 70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.

Objectives:

• Complete the practice exam questions

Topics:

• Practice exam

Learning Segment 14 : Practice Exam 2

Summary:

This learning segment presents questions that will help you prepare for the MCITP 70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.

Objectives:

• Complete the practice exam questions

Topics:

• Practice exam

Features:

• Flash-based instructional demonstrations applying course concepts. Instructional audio with graphics highlighting key points.
• Exercises allow learners to practice in the actual application being studied.
• A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
• Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
• Search text enables learners to rapidly search all text within a course to easily retrieve information required.
• Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
• A skill assessment generates a customized learning path based on the results of a pre-test.
• A glossary provides a reference for definitions of unfamiliar terms.
• Bookmarking tracks the learner's progress in a course.

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.