 |
MCITP: Database Administrator
Microsoft Certified IT Professional: Database Administrator (MCITP: DBA) 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 lecture, lab and demonstration delivery system.
- Enhances retention by employing accelerated learning techniques focused on committing information to long-term memory.
With Advanced Custom Training, 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.
Advanced Custom Training provides instruction to meet every learning need, including:
- Intensive group instruction
- One-on-one instruction attention
- Hands-on labs
- Question and answer drills
- Independent study
- Self-testing
Advanced Custom Training'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 four primary individual learning-intake styles (lecture, demonstrations, videos and hands on labs) - critical for a successful accelerated learning experience.
Daily lectures, labs, and review sessions are supplemented by a combination of:
- Microsoft Courseware
- Additional Files & Resources for add on labs
- Self Study Practice Test Resources.
Delivery Schedule:
The MCITP: SQL 2005 Database Administrator bootcamp prepares students to achieve 3 certifications during the program: MCP, MCTS: SQL Server 2005, MCITP: SQL Sever 2005 Database Administator.
| Days |
Module Description |
|
Exam |
| 1-3 |
PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 |
|
70-443 |
| 4-6 |
PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 |
|
70-444 |
| 7-9 |
TS: Microsoft SQL Server 2005 - Implementation and Maintenance
|
|
70-431 |
Daily 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 MCSA on Windows 2003.
| Start Time |
End Time |
Activity |
Additional Info |
| 7:30 am |
8:00 am |
Breakfast |
-
|
| 8:00 am |
11:45 am |
Lecture/Labs |
|
| 11:45 am |
12:30 pm |
Lunch |
- |
| 1:30 pm |
5:30 pm |
Lecture/Labs |
|
| 5:30 pm |
9:00 pm |
Test Prep |
|
|
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.
|
Advanced Custom Training offers the highest quality technical education in an all-inclusive course package specifically designed for the needs and ease of our students. We attend to every detail so our students can focus solely on their educational objectives.
Our MCTS: SQL Server 2005 Accelerated Certification Program includes:
- Intensive Hands-on Training by Microsoft Certified Trainers utilizing our (Lecture | Lab | Review)™ Delivery.
- Blended-Learning Instruction comprised of comprehensive study materials and pre-class mentoring, customized Microsoft Official Curriculum, comprehensive lab manuals, and Self-Test Testing Software.
- Examination Vouchers & On-site Certification Testing.
- Examination Passing Policy.
Advanced Custom Training has dedicated, well-equipped educational facilities where you will attend instruction and labs and have access to comfortable study and lounging rooms.
Our Microsoft Certified Trainers teach to accommodate every student’s learning needs through individualized instruction, hands-on labs, lab partner and group exercises, independent study, self-testing, question and answer drills, and friendly competitions between concurrently running classes.
Students will have 24-hour access to quality personal workstations, audiovisual equipment, supplies, and lab equipment.
Examination Passing Policy. Should a student complete a Advanced Custom Training Program without having successfully passed all vendor examinations, the student may re-attend that program for a period of one year. Students will only be responsible for accommodation and vendor exam fees.
|
|
Advanced Custom Training staff interview all potential students regarding their technical background, degrees and certifications held, and personal fortitude. This screening process ensures a successful match between the customer and Training Camp toward accelerated training and certification.
Students who are successful in accelerated SQL 2005 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
Advanced Custom Training is an intense training environment. You must have an attitude aimed for success. The above prerequisites are guidelines, but many students with less experience have other background or traits that have enabled their success in accelerated training through Training Camp.
Advanced Custom Training representative can skillfully assist you in determining your readiness for accelerated training.
|
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.
|
Advanced Custom Training offers the highest quality technical education in an all-inclusive course package specifically designed for the needs and ease of our students. We attend to every detail so our students can focus solely on their educational objectives.
- All inclusive package includes Airfare (Roundtrip to Florida), Transportation to and from airport, 9 Days of Hotel Accommodations, Breakfast and Lunch, Unlimited Beverages and Snacks.
- Intensive Hands-on Training by Microsoft Certified Trainers utilizing our (Lecture | Lab | Demo | Video) Delivery
- Blended-Learning Instruction comprised of comprehensive study materials, Microsoft training materials, official CompTIA courseware, comprehensive lab manuals, and practice test resources
- Examination Vouchers
- On-site Certification Testing
- Examination Passing Policy
Advanced Custom Training has dedicated, well-equipped educational facilities where you will attend instruction and labs and have access to comfortable study and rest/break room.
Our Microsoft Certified Trainers teach to accommodate every student’s learning needs through individualized instruction, hands-on labs, independent study, self-testing, question and answer drills.
|
|
 |