Microsoft SQL Server 2005 Design MCITP 70-443 - Online Course

This series 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.

This series is for anyone who wants to achieve MCITP 70-443 certification. This online course contains 12 lessons and 2 practice exams and should take approximately 16 hours to complete.

Lesson 1: Designing the Hardware and Software Infrastructure (2.0) hours

Designing the Hardware and Software Infrastructure teaches you how to design for capacity requirements, and specify software versions and hardware configurations. This course covers planning and designing a database infrastructure.

Lesson 2: Designing Physical Storage (1.0) hour

Designing Physical Storage teaches you how to design physical storage, and design instances. This course covers how to best design and organize physical storage.

Lesson 3: Designing a Consolidation Strategy (2.0) hours

Designing a Consolidation Strategy teaches you how to design a database consolidation strategy. This course covers developing a database consolidation strategy.

Lesson 4: Designing Database-Level Security (1.0) hour

Designing Database-Level Security teaches you how to analyze business requirements, integrate database security with enterprise-level authentication systems, modify the security design based on the impact of network security policies, and analyze the risk of attacks to the server environment and specify mitigations. This course covers designing an effective database-level security policy for SQL Server 2005 instances.

Lesson 5: Designing Windows Server-Level Security Processes (1.0) hour

Designing Windows Server-Level Security Processes teaches you how to develop Microsoft Windows server-level security policies. This course covers how the server-wide security parameters of SQL Server are determined and set globally for each instance.

Lesson 6: Designing SQL Server Service-Level Security (1.0) hour

Designing SQL Server Service-Level Security teaches you how to design SQL Server service-level security, and design database-level security. This course covers server-level SQL Server security items that affect the entire database service.

Lesson 7: Designing SQL Server Object-Level Security (1.0) hour

Designing SQL Server Object-Level Security teaches you how to develop object-level security. This course covers the lowest level of security - the objects that store and interact with data.

Lesson 8: Designing a Physical Database (1.0) hour

Designing a Physical Database teaches you how to modify an existing database design based on performance and business requirements, design tables and filegroups, and design index usage and views. This course covers creating, configuring, and administering databases in order to maximize their performance.

Lesson 9: Creating Database Conventions and Standards (1.0) hour

Creating Database Conventions and Standards teaches you how to create database conventions and standards, and create database change control procedures. This course covers database conventions and standards.

Lesson 10: Designing a SQL Server 2005 Solution for High Availability (1.0) hour

Designing a SQL Server 2005 Solution for High Availability teaches you how to 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, and design a high-availability solution based on replication. This course covers the technologies used in SQL Server to achieve a highly available database server.

Lesson 11: Designing a Data Recovery Solution for a Database (1.0) hour

Designing a Data Recovery Solution for a Database teaches you how to specify data recovery technologies based on business requirements, design backup strategies, and create a disaster recovery plan. This course covers planning a data recovery strategy for databases, including a backup and restore plan.

Lesson 12: Designing a Data-Archiving Solution (1.0) hour

Designing a Data-Archiving Solution teaches you how to 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, and design the topology and type of replication for archiving data. This course covers designing a data-archiving solution.

2 Practice Exams

This course 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.