MCITP Database Administrator Certification Course
- Price: US$ 799.00
- Publisher: Element K
- Number of modules: 29
- Length: 58 hours
- Language: English
- Subscription: 12 months
Microsoft's Professional Database Administrator Certification. Study Online and Practice on Live Software in our Virtual Lab.
This suite of online courses is built by Microsoft and is the premier online training courses for MCITP Database Administrator candidates. These e-learning courses are Official Microsoft Learning Products published by ElementK.
Use this course to prepare for the following Microsoft certification exams:
- 70-443
- 70-444
24 Virtual Labs are included in this MCITP certification course
1. Analyzing Capacity Needs
2. Building a Monitoring Solution for SQL Server Performance Issues
3. Combining High-Availability Technologies
4. Designing a Data Distribution Strategy Using Replication
5. Designing a Database Clustering Solution
6. Designing a Database Mirroring Solution
7. Designing a Database Server Infrastructure
8. Designing a High-Availability Solution Based on Replication
9. Designing a Highly Available Database Storage Solution
10. Designing a Log Shipping Solution
11. Designing a SQL Server Systems Infrastructure Security Policy
12. Determining an Appropriate Solution
13. Documenting and Testing a High-Availability Strategy
14. Establishing Database Conventions and Standards
15. Integrating Data Encryption into a Database Security Design
16. Managing and Automating Databases and Servers
17. Managing SQL Server Supporting Services
18. Optimizing the Query Performance Environment
19. Troubleshooting Database and Database Server Performance Issues
20. Troubleshooting SQL Server Connectivity Issues
21. Troubleshooting SQL Server Data Concurrency Issues
22. Troubleshooting SQL Server Data Issues
23. Validating a Systems Infrastructure Security Policy
24. Validating Security Policies for Instances and Databases
MCITP Database Administrator Certification Course Details
| Module Name | Description |
| Creating Custom Web Parts in Microsoft Windows SharePoint Services 3.0 (5393) |
Learn strategies for gathering data and about the capacity of basic system resources such as storage, CPU, memory, and network bandwidth. Apply guidelines to help estimate future capacity needs and also include access to five search-able E-Reference books for quick just-in-time problem solving. |
| Building a Monitoring Solution for Microsoft SQL Server 2005 Performance Issues (2980) |
Perform the initial stages of troubleshooting Microsoft SQL Server 2005 where it will narrow down an issue to a particular database environment area, such as CPU, memory, disk I/O, or query design. It also applies guidelines for monitoring database servers and instances by using Profiler and Sysmon. |
| Combining High-Availability Technologies Using Microsoft SQL Server 2005 (3172) |
Evaluate the weaknesses in each high-availability technology for Microsoft SQL Server 2005 including clustering, log shipping, database mirroring, replication, and storage technologies. Then apply guidelines for maximizing availability by combining existing technologies. |
| Designing a Clustering Solution Using Microsoft SQL Server 2005 (3168) |
Design, manage, and upgrade a Microsoft SQL Server 2005 clustering solution. |
| Designing a Data Archiving Strategy for Microsoft SQL Server 2005 (3590) |
Design a strategy for data archiving for Microsoft SQL Server 2005. Firstly determine how much data can be archived, then choose an appropriate structure for the archival data, and finally create a plan for archiving the data. |
| Designing a Data Distribution Strategy for Microsoft SQL Server 2005 (3592) |
Design a data distribution plan to distribute data among multiple locations. Determine the data requirements for each location and then select an appropriate data distribution tool. This course also includes access to five search-able E-Reference books for quick just-in-time problem solving. |
| Designing a Data Recovery Strategy for Microsoft SQL Server 2005 (3594) |
Design a data recovery strategy utilizing Microsoft SQL Server 2005. Design a comprehensive strategy for your entire infrastructure that saves both time and money. It also includes access to five search-able E-Reference books for quick just-in-time problem solving. |
| Designing a Database Mirroring Solution Using Microsoft SQL Server 2005 (3170) |
Design database roles and topologies for database mirroring of Microsoft SQL Server 2005. Convert existing high-availability solutions to database mirroring and design an operations plan to maximize availability. In addition, manage security events and threats in database mirroring. |
| Designing a Database Server Consolidation Strategy for Microsoft SQL Server 2005 (3591) |
Design the database server infrastructure of an organization and consider the benefits and risks of consolidating database servers. Also learn how to use multiple SQL Server instances to optimize the design of your database server infrastructure. |
| Designing a Highly Available Database Storage Solution Using Microsoft SQL Server 2005 (3167) |
Learn how to apply guidelines and considerations for determining the storage requirements for Microsoft SQL Server 2005 databases, components, and supporting external files. Apply guidelines for designing storage solutions for SQL Server databases and for designing disaster recovery plan (DRP) strategies to maximize availability. Finally, recover damaged and partially damaged databases. |
| Designing a Log Shipping Solution Using Microsoft SQL Server 2005 (3169) |
Learn the key features and requirements of a Microsoft SQL Server 2005 log shipping solution. Apply considerations for configuring log shipping server roles and designing a log shipping topology, and learn the guidelines for designing a log shipping upgrade strategy. Finally, design an operations plan for log shipping. |
| Designing a Microsoft SQL Server 2005 Database Server Infrastructure (3593) |
Evaluate the existing database server infrastructure of an organization and gather the technical and business requirements from various stakeholders. In addition, design modifications to a database server infrastructure and utilize best practices for standardizing database server hardware and software. |
| Designing a Microsoft SQL Server 2005 Security Exceptions Policy (3316) |
Gather business and regulatory requirements and compare them with existing policy. Also, determine the exceptions and their impact on security. |
| Designing a Response Strategy for Threats and Attacks Against Microsoft SQL Server 2005 (3317) |
Apply guidelines to respond to virus and worm attacks, denial-of-service attacks, and injection attacks. |
| Designing a SQL Server 2005 Security Policy to Integrate with Systems Infrastructure (3313) |
Implement server-level security using authentication methods and gain the knowledge required to develop a Microsoft Windows server-level security policy. |
| Designing Replication Solutions for High Availability Using Microsoft SQL Server 2005 (3171) |
Design high-availability solutions based on replication in Microsoft SQL Server 2005. Apply guidelines and best practices for implementing replication, and for creating an operations plan for solutions. In addition, design a disaster recovery strategy by using merge replication and transactional replication. |
| Designing Security Policies for Microsoft SQL Server 2005 Instances and Databases (3314) |
Design SQL Server instance-level, database-level, and object-level security policies and learn the security monitoring standards for instances and databases. |
| Documenting and Testing a High-Availability Strategy Using Microsoft SQL Server 2005 (3173) |
Document a Microsoft SQL Server 2005 high-availability solution. Apply guidelines for documenting business requirements, failover and failback strategies, performance benchmarks, threats, and a test plan for the selected solution. |
| Establishing Database Conventions and Standards for Microsoft SQL Server 2005 (3595) |
Establish database conventions and standards for Microsoft SQL Server 2005 to help organize the server infrastructure and make database administrator and developer teams more productive. |
| Integrating Data Encryption into a Microsoft SQL Server 2005 Database Security Design (3315) |
Apply guidelines and considerations for securing data using encryption and certificates. Also, describe various data encryption policies and determine a key storage method. |
| Introduction to Designing SQL Server Security for Microsoft SQL Server 2005 (3312) |
Learn the principles and methodology of designing SQL Server security and learn the benefits of having a security policy in place and the process of creating a security policy. In addition, this course teaches the importance of monitoring the security of SQL Server. |
| Managing and Automating Microsoft SQL Server 2005 Databases and Servers (3466) |
Plan automated systems for databases and servers. Also, gain the knowledge required to maintain a run book. |
| Managing Microsoft SQL Server 2005 Supporting Services (3467) | Deploy and manage SSIS packages. Also, provide the guidelines and considerations for maintaining replication and reporting services. |
| Optimizing the Microsoft SQL Server 2005 Query Performance Environment (2982) | Troubleshoot Microsoft SQL Server 2005 performance issues caused by poorly performing queries. Learn the query troubleshooting process, which requires a review of the query and the query environment to identify performance issues before implementing a suitable solution. The course shows how to utilize the Database Engine Tuning Advisor (DTA) to troubleshoot a query environment. |
| Selecting the Appropriate High-Availability Technology Using Microsoft SQL Server 2005 (3166) | Establish and then implement a comprehensive high-availability strategy for SQL Server 2005 by following a four step process: analyzing business requirements, selecting an appropriate strategy, designing and implementing the architecture, and managing the infrastructure. |
| Troubleshooting Microsoft SQL Server 2005 Concurrency Issues (2985) | Troubleshoot Microsoft SQL Server 2005 concurrency issues. Use a five step database troubleshooting methodology to identify and resolve concurrency issues that are caused by locking, blocking, and deadlocking. In addition, the course shows how to measure and troubleshoot wait times by using SQL Server latches. |
| Troubleshooting Microsoft SQL Server 2005 Connectivity Issues (2983) | Troubleshoot Microsoft SQL Server 2005 connectivity issues and examine the SQL Server environment and network infrastructure to help you troubleshoot the connection problem. The course also teaches how to explore common connection problems related to Domain Name System (DNS), network authentication, and SQL Server 2005 endpoints. |
|
Troubleshooting Microsoft SQL Server 2005 Data Issues (2984) |
Troubleshoot Microsoft SQL Server 2005 data integrity issues. Use a five step database troubleshooting methodology to identify and resolve torn SQL Server pages by using single-page restore. The course shows how to detect torn pages by using the Page_Verify option. |
|
Troubleshooting Microsoft SQL Server 2005 Performance Issues (2981) |
Troubleshoot Microsoft SQL Server 2005 performance by analyzing the data captured through a monitoring solution. Then use this analysis to narrow down the performance issue to a specific database environment object. In addition, the course shows how to automatically synchronize Sysmon logs and Profiler traces, and utilize the SQLDiag tool. |
