Microsoft - MCITP Database Administrator

A Firebrand Training
6
Day Course

Microsoft MCITP Database Administrator - Overview

Microsoft Certified IT Professional: Database Administrator (MCITP: Database Administrator) is the premier certification for database server administrators. This certification demonstrates that you can keep up with your enterprise business solutions 24 hours a day, 7 days a week. As an IT Pro in database administration you can:

Design and deploy a multi-server SQL Server infrastructure
Administer and monitor multiple instances of SQL Server centrally
Design and implement security policy, including authentication, auditing and encryption
Design and implement recoverability and high availability strategies on SQL Server 2005
Administer, Maintain and Optimise Microsoft SQL Server 2005

Our Microsoft SQL 2005 Server Database Administrator Program

Allows you to become an expert in Microsoft SQL Sever 2005 in less time than 'traditional training' while exposing each student to real-world, hands-on virtual team website enabling information sharing between project team departments
Helps students grasp complex technical concepts more easily by identifying and catering to individual student learning styles through a mixed visual, auditory and kinaesthetic-tactual delivery system
Enhances retention by employing accelerated learning techniques focused on committing information to long-term memory

Microsoft MCITP Database Administrator - Benefits

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
SSIS enhancements (formerly DTS)
Better e-mail handling
64-bit support

New features

Common Language Runtime (CLR)
Service Broker
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 Certified IT Pro in Database Administration certification is recognised 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 utilise 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

Other accelerated training providers rely heavily on lecture and independent self-testing and study.

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.

Firebrand Training 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
Independent study

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. Firebrand Training provides a guarantee of obtaining certification at the camp, but does not make any guarantees about personal successes or benefits of obtaining certification.

Microsoft MCITP Database Administrator - Curriculum

Firebrand Training has an aggressive educational schedule that thoroughly covers all essential elements necessary to become skilled as an SQL Server 2005 professional.

Module 1: Designing a Database Server Infrastructure
Designing Security for a Database Server Solution
Designing a Physical Database
Designing a Database Solution for High Availability
Designing a Data Recovery Solution for a Database
Designing a Strategy for Data Archiving
Exam 70-443
Optimizing the Performance of Database Servers and Databases
Optimizing and Implementing a Data Recovery Plan for a Database
Designing a Strategy to Monitor and Maintain a Database Solution
Designing a Database Data Management Strategy
Designing a Strategy to Manage and Maintain Database Security Review
Exam 70-444

Microsoft MCITP Database Administrator - Exam Track

Microsoft Certified Technology Specialist on SQL Server 2005 candidates are required to pass Exams 70-443, 70-444.

Skills Being Measured

Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 (Exam 70-443)
Optimising and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 (Exam 70-444)

Microsoft MCITP Database Administrator - What's Included

Firebrand Training offers top-quality technical education and certification training 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 studies and certification goals.

Our Certification Programs includes

Intensive Hands-on Training Utilising our (Lecture | Lab | Review)^TM Delivery
Comprehensive Study Materials, Program Courseware and Self-Testing Software
Fully instructor-led program with 24 hour lab access
Examination vouchers *
On site testing **
Accommodation, All Meals, Beverages, and Snacks
Transportation to/from designated local railway stations
Examination Passing Policy

Please note

* Exam vouchers for our (ISC)2 certifications need to be purchased directly from (ISC)2
** On site testing is not included in our ISACA, or ITIL Managers and Revision Certifications

Our instructors teach to accommodate every student's learning needs through individualised instruction, hands-on labs, lab partner and group exercises, independent study, self-testing, and question/answer drills.

Firebrand Training has dedicated, well-equipped educational facilities where you will attend instruction and labs and have access to comfortable study and lounging rooms. Our students consistently say our facilities are second-to-none.

Examination Passing Policy

Should a student complete a Firebrand 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 accommodations and vendor exam fees.

Microsoft MCITP Database Administrator - Prerequisites

Delegates are required to meet the following prerequisites:

MCTS SQL05 (Microsoft Certified Technical Specialist: SQL Server 2005)

Firebrand 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 Firebrand Training toward accelerated training and certification.

Firebrand Training is an aggressive 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 Firebrand Training.

MCITP Database Administrator Testimonials

"Without a doubt a very intense 2 weeks. The ethos at the start of the course was you will get out of it what you put in and that is certainly true! The instructor was exceptional at delivering material, and giving us appropriate time for breaks and one to one where it was needed. Better than I ever expected!"
C.H., Azetch IT Solutions.

"I found the staff, training and food to be of the highest order, well done to all the staff. They manage to maintain thier high standards and couriousness despite the long hours they are expected to be on hand."
Paul M Huff, serco.

"Although you are pushed to the limits, the effectivness of this type of training are so rewarding."
Alexander Donaldson, BEAR Scotland Ltd.

"Firebrand Training is one of the most excellent institute, as it takes you to different world where you can find comfortable environment for useful studying and preparing for exams. Moreover, everyone in Firebrand is working for you (i.e instructor, bus driver, staff, chef)."
Naif Al-Dossary, SABIC.

"Training with Firebrand is a lifetime experience. The training facilities are great, service is fantastic and the teacher can impress with the high level of knowledge and experience. I will come back for further trainings and I stongly recommend Firebrand to everyone, who wants to train with professionals."
Robert Laszczewski, Phase Forward Ltd.

"Was a very intense experience, and half way through was not sure that it was going to be of benefit. But reaching the end successfully completing both exams and now have a greater breath of knowledge than I thought I could achieve, two days in!"
Sandra Campbell, Instalec Networking Ltd.

"A professional and well designed course that adapted to the students requirements whilst keeping on the required track. I would not study any other way or with any other training company."
Kim Peck, SGP Property Services Ltd.

"I never thought I would get through 8 days of training 12-14 hours a day, plus doing homework. However the ideal environment, helpful staff and amazing instructor all helped us to focus on the task at hand and our common goal, rather than what time of day (or night!) it was. Truly an experience, not just your regular training. "
Azim Husain, PA Consulting Group.

"Quality of the delivery of the material in the classroom was excellent. "
A.D, DWP.

"Totally met my expectations."
C.A., NATS Ltd.

"Excellent course enjoyed it and learnt a lot."
David Palmer, Sutton College.

"Excellent as ever, quality lecturer, material and location. Hardwork but very enjoyable."
Robert Fullagar, Self employed.

"The overall experience was very tiring, but richly rewarding. The instructor was excellent - technically and personally - he really helped deliver the technical content in everyday terms. The learning centre was excellent - as was the food! I will certainly recommend to my staff and managers to use Firebrand for out training requirements in the future."
AL, Digica Ltd.

"An intense course! I knew nothing about Cisco equipment before I came on this course. Now I feel confident in configuring routers and switches.. Exam preparations are hard! You will feel stressed, due to lack of sleep and certain aspects that you cant quite grasp..but the instructor is great, the location is good..allowing you to fully concentrate on passing this course!"
Jaimin Rao, Made redundant last week :(.

"This seriously is the best training course I have ever been on. Great teacher, great food and one excellent location. 5 stars."
James Gardiner, SystemC.

"FIREBRAND... Training with them is like being Branded: Over quickly but leaves a lasting impression. The best way to learn, in the best place, with the best food and staff. If you are thinking of attending Sign up now. I had a great time and am now Qualified. Woo Hoo!!! "
Ross Martel-Welsh, Alternative Solutions Ltd.

"An intensive course but producing good results! Whilst the orientation is mis-leading and actually leads you straight into your first nights learning experience, you quickly adjust to its intensive nature. The accomodation is simple, but enough to get a good nights rest and to study in private. 3 meals a day are provided and the catering staff try to accomodate as much as possible. But there is a huge range of snacks, soft drinks, tea & coffee to keep you going in-between. Overall a great way to remove yourself from your daily distractions and get on with the task of getting certified as quickly as possible. Definitely recommended, however a prior knowledge of working with Dynamics (or any other) CRM and a grounding on MS Windows/Servers will definitely help give you a jump start on certain elements of this course."
Phil Midgley, Collins Stewart Wealth Management.

"Being able to be residential means I was able to focus on what I was doing - no housework, no childminding, no crisis!"
Sylvia Yates, Thurrock Council.

"The intensity of the training ensured that you received plenty of knowledge to enable you to pass the exams. The environment in which the training was undertaken was superb as it removed all distractions from learning the topic. "
PC, MOD.

"An environment created for learning for people keen and willing to learn. "
Richard Warner, Freelance IT Contractor.

"The telesales guy was good - I was somewhat nervous because that was my money ... could have done the course for half the price in london 9-5. But telesales plus recommend made me. I had absolutely no doubt by the end of the first day that this was not only an excellent course and training establishment but that the course was really practical. I can not wait to use this ... need to get a job and would affect my choice of job. "
Dathan Burden, Job hunting.

"The course met all my expectations. Facilities were good & all staff were extremely helpful."
Jon Oakes, myself.

"The dark art of computing made understandable. Take the blue pill!"
JJ, Freelance.

"I enjoyed the course although it was a long and tiring week. The instructor was wonderful and certainly knew his subject matter. I learnt an awful lot during my stay and would recommend it to someone else."
Helen Martin, Stockport College.

"An excellent trainer and the course was well structured towards the final exam. "
KH, Ernst and Young.

"The training facility is extremely focused on creating a distraction free learning environment; it succeeds!"
David Cawley, Reliance High Tech.

"It was by no means easy, but very worthwhile and gained a lot..."
Richard Ward, Insite Europe Limited.

"Hard graft and definitely not for the week willed or faint hearted - but worthwhile, no question. Pre-reading is a big must."
Mike Crowe, Self Employed.

"Be prepared to work a long day 8.30 - 8.00 with studying after class. BUT the tutors knowledge is excellent and the course is well worth attending "
Denise Potter, Thamesteel Ltd.

MCITP Database Administrator Course Dates

Start	End	Availability	Register
24/11/2008	29/11/2008	Finished
2/2/2009	7/2/2009	Limited availability	Register
30/3/2009	4/4/2009	Seats open	Register

Does your business run legacy IT systems?	Yes	no
Have legacy system upgrades caused issues with new business critical applications?	Yes	no
Would server virtualisation enable you to prolong the life of defunct business applications and directly improve productivity?	Yes	no
How old are your legacy IT systems?