Course ID: 19968 | Course Duration: 10 Days
Course Dates: 
 
Career Training
 

Microsoft Certified IT Professional (MCITP) SQL 2005 Database Administrator Training Class

Course ID: 19968
 
 
Course Snapshot View Dates Add To My Courses Get More Information About This Course Register Online Register By Fax On-Site Training View Printer Friendly Version
 
     
 

Microsoft Certified IT Professional (MCITP) SQL 2005 Database Administrator Training Seminar

MCITP: Database Administrator
Microsoft Certified IT Professional: Database Administrator (MCITP: DBA) Training Camp for SQL Server 2005 is the premier certification for database server administrators. The certification confirms that you are fully qualified to manage your enterprise business solutions.

Database administrators install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. They also design or implement security or server automation and monitor and troubleshoot SQL Server activity. The MCITP: DBA certification proves that you have what it takes in a competitive and ever-changing IT landscape.

Our MCITP: DBA program is a lab-intensive, residential course, designed for information technology professionals that require effective, real-world skill-building and timely certification.  You will live, learn, and test on-site.

Our MCITP Program:

  • Allows you to achieve your certification in a fraction of the time of 'traditional training' while delivering industry-leading exam passing percentages.
  • Helps students grasp complex technical concepts more easily by identifying and catering to individual student learning styles through a mixed visual, auditory and kinesthetic-tactual delivery system.
  • Enhances retention by employing accelerated learning techniques focused on committing information to long-term memory.

With Training Camp, you will learn more. effectively. efficiently.

So what makes SQL Server 2005 compelling? The following short list highlights some of its enhanced and new features. Several of these features should make a compelling case to upgrade your SQL Server environment.

Enhanced features

  • T-SQL enhancements
  • Performance improvements
  • Backup enhancements
  • Online-maintenance operations
  • Business-intelligence enhancements
  • Management-GUI enhancements
  • Security enhancements
  • Increased memory usage with
  • Standard Edition
  • XML enhancements
  • Better e-mail handling
  • 64-bit support

New features

  • Common Language Runtime (CLR) Support
  • Service Broker for Secure and Reliable Messaging and Routing
  • SQL Server Integration Services (SSIS) enhancements (formerly DTS)
  • New product versions
  • High-availability features
  • Data encryption
  • Database Tuning Advisor
  • Dedicated administrator connection

So now that you have decided to upgrade to or deploy SQL Server 2005 - why educate? 
As SQL Server continues to mature, more and more features are added to the base product. This is both good and bad. The plus side is that you get more than just a database engine. The down side is that you have a lot more to learn. The days of being of being an expert on every aspect of SQL Server are over -- but this doesn't mean that you can't still use these new features. If you are only using the product's base functionality you are missing out on a wealth of functions. Case in point: Analysis Services, SQL Server's business analysis tools. This product has been available for several years and most people that use SQL Server have never taken advantage or know little about it.

What are the benefits of certification?
For IT managers, certification is particularly important because it allows them to more easily identify the skills that an individual possesses. When a company has employees that possess certain skills, it can garner a competitive advantage when seeking to attract customers. Certification can also contribute to increased productivity, because studies have shown that certified individuals are generally quicker to implement and design new technologies. And of course by knowing that their employees are certified, IT managers can feel more confident about their ability to implement and support a network infrastructure.

Individuals:

  • Overwhelmingly, individuals with Microsoft certifications have an advanced level of knowledge, expertise and skill, and command more professional credibility.
  • The MCITP: DBA certification is recognized as a particularly elite indication of an database administrator's prowess and skill level, and these professionals are highly sought by employers.
  • Individual students may receive college credits to utilize tuition reimbursement programs for their IT training or to complete college coursework.

Human Resources:

  • Employer-funded training and certification programs are a key to retaining skilled IT staff. Career development and advancement opportunities are shown to significantly reduce rates of employee turnover.
  • Certification Training Programs provide benchmarks for hiring and promotion decisions by accurately assessing technical skills.
  • For-certification training programs maximize educational investments through immediate validation of skills.

Microsoft?? certification affords special membership benefits:

  • Technical information, product information and exclusive discounts on products and services through a secured section of the Microsoft?? website.
  • Microsoft?? logos and certificate for your personal promotion to clients or potential employers.
  • Invitations to Microsoft?? conferences and other educational opportunities.
  • Access to the secure Microsoft?? Certified Professional Magazine Online website.

Effective technical instruction must be highly varied and interactive to keep attention levels high, promote camaraderie and teamwork between the students and instructor, and solidify knowledge through hands-on learning.

Training Camp provides instruction to meet every learning need, including:

  • Intensive group instruction
  • One-on-one instruction attention
  • Hands-on labs
  • Lab partner and group exercises
  • Question and answer drills
  • Friendly competitions between concurrently running classes
  • Independent study
  • Self-testing

Some of the information on this page has been drawn from Microsoft's?? website: www.microsoft.com.

This information has been provided as a helpful tool for candidates considering certification. Benefits of certification determined through studies do not guarantee any particular personal successes. Training Camp provides a guarantee of obtaining certification at the camp, but does not make any guarantees about personal successes or benefits of obtaining certification.

 
     
     
  Course Details  
     
     
  Agenda  
 

Training Camp's MCITP: Database Administrator Accelerated Certification Program is the most effective, efficient way to learn how to derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure SQL Server 2005.

Course Materials:
Students attending this blended-learning program will receive a robust set of course materials that caters to each of the three primary individual learning-intake styles (auditory, visual, and kinesthetic-tactual) - critical for a successful accelerated learning experience. 

Daily lectures, labs, and review sessions are supplemented by a combination of:

  • Proprietary Lab Manual & Microsoft Courseware - developed in conjunction with Microsoft, adapting Microsoft Official Curriculum to address the demands of accelerated learners.
  • Self Test??? Testing Software.

Delivery Schedule:
The MCITP: Database Administrator SQL Server 2005 Program effectively prepares students to  design, optimize and maintain a database server infrastructure using Microsoft SQL Server 2005.

Days Module Description   Exam

1

Writing Queries Using Microsoft SQL Server 2005 Transact-SQL

 

 

2

Implementing a Microsoft SQL Server 2005 Database

 

 

3

Maintaining a Microsoft SQL Server 2005 Database

 

 

4

Introduction to SQL Server Services

 

 

5

EXAM: MCTS SQL Server 2005 Implementation and Maintenance

 

70-431

6

Designing a Microsoft SQL Server 2005 Infrastructure. Designing Security for Microsoft SQL Server 2005

 

 

7

Designing High Availability Database Solutions Using Microsoft SQL Server

 

 

8

EXAM: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005

 

70-443

9

Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005

 

 

10

EXAM: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005

 

70-444

Daily Educational Schedule:
Our daily schedule incorporates different modes of instruction and learning environments to ensure that students learn, retain, comprehend, and can apply knowledge critical to a MCITP: DBA.*

Start Time End Time Activity Intake Style
8:15 am 9:00 am breakfast

-

9:00 am 1:00 pm lecture auditory/visual
1:00 pm 1:30 pm lunch -
1:30 pm
 
5:30 pm
 
instructor-led
labs
kinesthetic
 
5:30 pm 7:00 pm dinner -
7:00 pm 8:00 pm review session auditory/visual/kinesthetic
8:00 pm 9:00 pm breakout
sessions
auditory/visual/kinesthetic
 
9:00 pm as appropriate lab review sessions kinesthetic

Some of the information on this page has been drawn from Microsoft's?? website: www.microsoft.com.

*Daily timetable shown for illustration purposes only. Significant changes may be made to the schedule on a daily basis to ensure that the goals of the course are met.

This information has been provided as a helpful tool for candidates considering certification. Benefits of certification determined through studies do not guarantee any particular personal successes. Training Camp provides a guarantee of obtaining certification at the camp, but does not make any guarantees about personal successes or benefits of obtaining certification.

 
     
     
  Pre-requisites  
  Students who are successful in accelerated MCITP: Database Administrator certification training may possess:

Basic Knowledge of Microsoft Windows operating system and its core functionality
Working knowledge of Transact_SQL
Working knowledge of relational databases
Some experience with database design
 
     
  Comments  
 

MCTS: SQL Server 2005 candidates are required to pass Exam 70-431.

MCITP: Database Administrator candidates are required to have acquired the MCTS: SQL Server 2005 certification and pass Exam 70-443, and Exam 70-444.

Skills Being Measured

The 70-431 certification exam measures your ability to implement and maintain a SQL Server 2005 database. At successful completion of this exam, candidates achieve the MCTS: SQL Server 20005 Certification. This program shall prepare students in the job skills listed in the following:

Installing and Configuring SQL Server 2005

  • Install SQL Server 2005.
  • Configure SQL Server 2005 instances and databases.
  • Configure SQL Server security.
  • Configure linked servers by using SQL Server Management Studio (SSMS).

Implementing High Availability and Disaster Recovery

  • Implement database mirroring.
  • Implement log shipping.
  •  Manage database snapshots.

Supporting Data Consumers

  • Retrieve data to support ad hoc and recurring queries.
  • Manipulate relational data.
  • Manage XML data.
  • Implement an HTTP endpoint.
  • Implement Service Broker components.
  • Import and export data from a file.
  • Manage replication.

Maintaining Databases

  • Implement and maintain SQL Server Agent jobs.
  • Manage databases by using Transact-SQL.
  • Back up a database.
  • Restore a database.
  • Move a database between servers.

Monitoring and Troubleshooting SQL Server Performance

  • Gather performance and optimization data by using the SQL Server Profiler.
  • Gather performance and optimization data by using the Database Engine Tuning Advisor.
  • Monitor and resolve blocks and deadlocks.
  • Diagnose and resolve database server errors.
  • Monitor SQL Server Agent job history.
  • Gather performance and optimization data by using DMVs.

Creating and Implementing Database Objects

  • Implement a table.
  • Implement a view.
  • Implement triggers.
  • Implement functions.
  • Implement stored procedures.
  • Implement constraints.
  • Implement indexes.
  • Create user-defined types.
  • Implement a full-text search.
  • Implement partitions.

The 70-443 certification exam measures your ability to design a database server infrastructure by using Microsoft SQL Server 2005. This program shall prepare students in the job skills listed in the following matrix:

Designing a Database Server Infrastructure

  • Design for capacity requirements.
  • Specify software versions and hardware configurations.
  • Design physical storage.
  • Design instances.
  • Design a database consolidation strategy.

Designing Security for a Database Server Solution

  • Analyze business requirements.
  • Integrate database security with enterprise-level authentication systems.
  • Develop Microsoft Windows server-level security policies.
  • Modify the security design based on the impact of network security policies.
  • Analyze the risk of attacks to the server environment and specify mitigations.
  • Design SQL Server service-level security.
  • Design database-level security.
  • Design object-level security.

Designing a Physical Database

  • Modify an existing database design based on performance and business requirements.
  • Design tables.
  • Design file groups.
  • Design index usage.
  • Design views.
  • Create database conventions and standards.
  • Create database change control procedures.

Designing a Database Solution for High Availability

  • Select high-availability technologies based on business requirements.
  • Develop a strategy for migration to a highly available environment.
  • Design a highly available database storage solution.
  • Design a database-clustering solution.
  • Design database mirroring.
  • Design a high-availability solution that is based on replication.
  • Design log shipping.

Designing a Data Recovery Solution for a Database

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

Designing a Strategy for Data Archiving

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

 

The 70-444 certification exam measures your ability to optimize and maintain a database administration solution by using Microsoft SQL Server 2005. This program shall prepare students in the job skills listed in the following matrix:

Optimizing the Performance of Database Servers and Databases

  • Troubleshoot physical server performance.
  • Troubleshoot instance performance.
  • Troubleshoot database performance.
  • Troubleshoot and maintain query performance.
  • Troubleshoot concurrency issues.

Optimizing and Implementing a Data Recovery Plan for a Database

  • Diagnose causes of failures. Failure types include database failures, physical server failures, and SQL Server service failures.
  • Plan for fault-tolerance.
  • Recover from a failure of SQL Server 2005.
  • Recover from a database disaster.
  • Salvage good data from a damaged database by using restoration techniques.

Designing a Strategy to Monitor and Maintain a Database Solution

  • Define and implement monitoring standards for a physical server.
  • Choose the appropriate information to monitor.
  • Create and implement a maintenance strategy for database servers.
  • Design a database maintenance plan.
  • Design a strategy to manage Reporting Services.

Designing a Database Data Management Strategy

  • Design and manage SQL Server Integration Services (SSIS) packages.
  • Enforce data quality according to business requirements.
  • Design data integrity.
  • Design a strategy to manage data across linked servers.
  • Design a strategy to manage replication.                         
  • Optimize a database control strategy to meet business requirements.

Designing a Strategy to Manage and Maintain Database Security

  • Perform a security audit of the existing security infrastructure based on the security plan.
  • Maintain a server-level security strategy.
  • Maintain a user-level security strategy.
  • Prepare for respond to threats and attacks.

Some of the information on this page has been drawn from Microsoft's?? website: www.microsoft.com.

This information has been provided as a helpful tool for candidates considering certification. Benefits of certification determined through studies do not guarantee any particular personal successes. Training Camp provides a guarantee of obtaining certification at the camp, but does not make any guarantees about personal successes or benefits of obtaining certification.

 

 

 
     
     
 
On-Site Training Bring this Microsoft Certified IT Professional (MCITP) SQL 2005 Database Administrator training class in-house at your facility. Request More Information Request More Information On Microsoft Certified IT Professional (MCITP) SQL 2005 Database Administrator
 
Career Training
 
 
Career Training
  Microsoft Certified IT Professional (MCITP) SQL 2005 Database Administrator Training Course Dates and Locations  
     
  Course ID: 19968 | Course Duration: 10 Days  
     
  Locations:  
     
   User Incentive For Registering on TrainUp.com! Gift card when you register today!  
     
 
Start Date Price      Location/Event Details Register Online Request
More Info
  Print/Fax
Register
12/01/2008 $6,395.00    Oakbrook, IL Register Online For The 12/01/2008 Event Request More Information   Register By Fax For The 12/01/2008 Event
12/08/2008 $6,395.00    Norcross, GA Register Online For The 12/08/2008 Event Request More Information   Register By Fax For The 12/08/2008 Event
 
     
 
On-Site Training Bring this Microsoft Certified IT Professional (MCITP) SQL 2005 Database Administrator training class in-house at your facility. Request More Information Request More Information On Microsoft Certified IT Professional (MCITP) SQL 2005 Database Administrator
 
Career Training
 
 
Career Training
  Browse Our Catalog  
     
  Select a market segment to view more courses

 
     
  Or, select a category to view more courses

 
     
  Browse By Category Browse By Category

Browse By Location Browse By Location

Browse New Courses Browse New Courses

 
     
Career Training
 
   
 
 
Career Training
   
Career Training
 
 
 
 






Site Map -- Top Training Courses -- Request On-Site Training

Find Jobs -- Degree Programs -- Training Providers -- Resource Center -- About Us -- Contact us

TrainUp.com Your Career Training Marketplace