 |
GET IN THE LEAD - get certified today!
Experience the benefits of classroom learning - anytime, anywhere! QuickCert's expert instruction and multi-media courses are to get you certified - or your money back!
Read why successful professionals choose QuickCert > |
The Microsoft MCITP Database Administrator Training Package from QuickCert include expert instructor-led training modules with customized presentations, practice exam simulators and learning supplements for an all-inclusive training program that provides all the benefits of classroom training at your own pace.
QuickCert's MCITP Database Administrator Training Package includes the following exams:
The Microsoft Certified IT Professional: Database Administrator (MCITP: Database Administrator) certification training course from QuickCert enables students with the knowledge and skills needed to manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting.
Database Administrators design or implement security or server automation and monitor and troubleshoot SQL Server activity. They are typically employed by mid-sized to large organizations.
As a Microsoft Certified Partner, you can be certain that QuickCert's comprehensive MCITP: Database Administrator training courses will provide you with all the tools necessary to successfully prepare for your MCITP: Database Administrator certification. We guarantee it!
Click on one of the tabs above to learn more about our course curriculum or QuickCert product features, or to learn more about a specific exam, click on a course number below.
Not sure what course is right for you?
Contact one of our Career Advisors at 888.840.2378 for assistance.
Your QuickCert MCITP: Database Administrator Certification Training Course: Microsoft Certified IT Professional Training Package Includes:
| Delivery Format |
Instructor Led Modules |
Practice Exam Simulator |
Exam Pass Guarantee |
DVDs
or online |
|
|
|
Exam Pass Guarantee - Learn More
Free Product Upgrades
Toll Free Educational Support
Compatibility with:
NT | 95 | 98 | 2000 | ME | XP | 2003| Vista | Windows 7
“I’m 100% satisfied with QuickCert’s training program. I love that it’s broken into manageable sections. This is an all-inclusive training solution… they give you the manuals, the lectures broken into short segments, and practice tests that really mirror the actual tests I’ve taken. I plan to renew my membership!!”
— Karen S., Network Administrator, Calabasas, California
Questions? Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.
MCITP: Database Administrator Certification Training Course: Microsoft Certified IT Professional Curriculum
Exam 70-431
Implementing a Microsoft SQL Server 2005 Database
Module-1 Creating Databases and Database Files
Creating Databases
Creating Filegroups
Creating Schemas
Creating Database Snapshots
Module-2 Creating Data Types and Tables
Creating Data Types
Creating Tables
Creating Partitioned Tables
Module-3 Using XML
Retrieving XML by Using FOR XML
Shredding XML by Using OPENXML
Using the XML Data Type
Module-4 Creating and Tuning Indexes
Planning Indexes
Creating Indexes
Optimizing Indexes
Creating XML Indexes
Module-5 Implementing Data Integrity
Data Integrity Overview
Implementing Constraints
Implementing Triggers
Implementing XML Schemas
Module-6 Implementing Views
Introduction to Views
Creating and Managing Views
Optimizing Performance by Using Views
Module-7 Implementing Stored Procedures and Functions
Implementing Stored Procedures
Creating Parameterized Stored Procedures
Creating Functions
Handling Errors
Controlling Execution Context
Module-8 Implementing Managed Code in the Database
Introduction to the SQL Server Common Language Runtime
Importing and Configuring Assemblies
Creating Managed Database Objects
Module-9 Using Service Broker
Service Broker Overview
Creating Service Broker Objects
Sending and Receiving Messages
Maintaining a Microsoft SQL Server 2005 Database
Module-1 Installing and Configuring SQL Server 2005
Preparing to install SQL Server
Installing SQL Server
Managing a SQL Server 2005 Installation
Module-2 Managing Databases and Files
Planning databases
Creating databases
Managing databases
Module-3 Disaster Recovery
Planning a Backup Strategy
Backing Up User Databases
Restoring User Databases
Recovering Data from Database Snapshots
System Database and Disaster Recovery
Module-4 Managing Security
Overview of SQL Server Security
Securing the Server Scope
Securing the Database Scope
Managing Keys and Certificates in SQL Server
Module-5 Monitoring SQL Server
Viewing Current Activity
Using System Monitor
Using SQL Server Profiler
Using DDL Triggers
Using Event Notifications
Module-6 Transferring Data
Overview of Data Transfer
Introduction to SQL Server Integration Services
Using SQL Server Integration Services
Module-7 Automating Administrative Tasks
Automating Administrative Tasks in SQL Server 2005
Configuring the SQL Server Agent
Creating Jobs and Operators
Creating Alerts
Managing Multiple Servers
Managing SQL Server Agent Security
Module-8 Maintaining High Availability
Introduction to High Availability
Implementing Server Clustering
Implementing Database Mirroring
Implementing Log Shipping
Module-9 Introduction to Replication
Overview of Replication
Replication Scenarios
Exam 70-443
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
Exam 70-444
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
Administering and Automating Microsoft SQL Server 2005
Databases and Servers
Planning an Automated System for Database Maintenance
Planning an Automated System for Server Maintenance
Documenting Administration and Automation Information
Managing SSIS Packages
Managing Replication
Managing Reporting Services
Troubleshooting and Optimizing Database Servers
Using Microsoft SQL Server 2005
Using SQL Server Profiler and System Monitor
Troubleshoot Performance Issues
Narrowing Down a Performance Issue to a Database Object
Troubleshooting Database Server Performance Issues
Query Performance Troubleshooting Process
Optimizing the Query Performance Environment
Troubleshooting SQL Server Connectivity Issues
Areas to Troubleshoot for Connectivity Issues
Troubleshooting SQL Server Data Issues
Troubleshooting Data Integrity Issues
Troubleshooting Concurrency Issues
SQL Server Data Concurrency Issues
Questions? Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.
