The PowerLearning™ courses are
presented by Industry
Specialists and use a powerful
combination of audio,
full-motion video, text and
colourful graphics, providing
the necessary training for
people to grasp and to give them
a road map to practice on their
own.
Our Microsoft Exam 70-443 training
course PRO-Designing a Database
Server Infrastructure by Using
Microsoft SQL Server
2005 teaches database
administrators to to design a
Microsoft SQL ServerT 2005
database infrastructure, to
design security for database
systems using Microsoft SQL
ServerT 2005, how to monitor
security and respond to threats
and to design database solutions
that meet the availability needs
of their organization,
emphasizing high availability,
which includes thinking about
the database itself and about
their entire environment,
including business needs;
regulatory requirements; and
network, systems, and database
considerations during design.
Students will also learn how to
document and test the high
availability database solution.
When you pass this exam, you
earn credit towards the
following certifications: MCITP
Database Administrator.
As a Microsoft Certified
Partner, our developer follows
the approved Microsoft course
curriculum, ensuring you receive
the training and knowledge
needed to succeed.
Designing High Availability
Database Solutions
Using Microsoft SQL Server 2005
Determining Appropriate
High-Availability Solutions
Identifying High-Availability
Requirements and Constraints
Analyzing High-Availability
Requirements and Constraints
High-Availability Solution
Determining Storage Requirements
for SQL Server Databases
Determining Storage Requirements
for SQL Server Components and
Files
Designing Storage Solutions for
SQL Server Databases
Designing a Backup and Restore
Strategy
Designing the Platform for
Failover Clustering
Designing the SQL Server Cluster
Implementation
Designing Recovery Strategies
and a Test Plan for Failover
Clustering
Migrating and Upgrading SQL
Server Clusters
Designing an Operations Plan for
Clustering
Introduction to Designing a Log
Shipping Solution
Designing Log Shipping Server
Roles and Topology
Designing a Log Shipping Upgrade
Strategy
Designing an Operations Plan for
Log Shipping
Introduction to Designing a
Database Mirroring Solution
Designing Database Roles and
Topology for Database Mirroring
Converting High-Availability
Solutions to Database Mirroring
Designing an Operations Plan for
Database Mirroring
Introduction to Designing a
Replication Solution
Designing a Replication Solution
Designing a Replication Upgrade
Strategy
Designing an Operations Plan for
Replication
Evaluating Weaknesses in Each
High-Availability Technology
Maximizing Availability by
Combining High-Availability
Technologies
Documenting High-Availability
Solutions
Creating a Test Plan for
High-Availability Solutions
Designing Security for Microsoft
SQL Server 2005
Principles of Database
Security
Security Standards
Methodology for Designing a SQL
Server Security Policy
Monitoring SQL Server Security
Developing an Authentication
Policy
Developing Server-Level Security
Policies
Developing a Secure
Communication Policy
Defining SQL Server
Security-Monitoring Standards
Designing an Instance-Level
Security Policy
Designing a Database-Level
Security Policy
Designing an Object-Level
Security Policy
Defining Security Monitoring
Standards for Instances and
Databases
Securing Data by Using
Encryption and Certificates
Designing Data Encryption
Policies
Determining a Key Storage Method
Analyzing Business and
Regulatory Requirements
Determining the Exceptions and
Their Impact
Constraints of Government
Regulations
Designing a Response Policy for
Virus and Worm Attacks
Designing a Response Policy for
Denial of Service Attacks
Designing a Response Policy for
Internal and SQL Injection
Attacks
Designing a Microsoft SQL Server
2005 Infrastructure
Estimating Storage Requirements
Estimating CPU Requirements
Estimating Memory Requirements
Estimating Network Requirements
Analyzing Capacity Needs
Identifying Requirements That
Affect Data Archiving
Determining the Structure of
Archival Data
Creating a Data Archival Plan
Overview of Database Server
Consolidation
Designing a Database Server
Consolidation Strategy
Selecting a Data Distribution
Tool
Creating a Data Distribution
Plan Using Replication
Evaluating the Current Database
Server Infrastructure
Gathering Requirements for
Changing a Database Server
Infrastructure
Designing Modifications to a
Database Server Infrastructure
Designing a Backup and Restore
Strategy
Creating a Database Disaster
Recovery Plan
Establishing Database Naming
Conventions
Defining Database Standards
Note: The
PowerLearning™ courses are
presented by Industry
Specialists and use a powerful
combination of audio,
full-motion video, text and
colourful graphics, providing
the necessary training for
people to grasp and to give them
a road map to practice on their
own. Not all modules/courses
have interactive software
simulations. To pass the exams
we recommend students need to
practice using the actual
software itself. For persons
without access to the software,
we often find that the software
vendors provide trail versions
of software – we recommend you
visit their website for details.
This also further enhances a
person’s preparation for taking
a related exam. The training
programs are subject to
copyright and software licence
terms. The developers reserves
the right to alter materials
listed in published outlines in
order to address current
certification requirements. See
FAQ for more information.
.
