Microsoft - MCITP Database Developer

A Firebrand Training
6
Day Course

Microsoft MCITP Database Developer - Overview

Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) is the premier certification for database server developers. This credential demonstrates that you can design a secure, stable, enterprise database solution by using Microsoft SQL Server 2005. On completion of this course you will be able to:

Design and implement Relational Database models and database storage objects
Program efficient user-defined functions, triggers and stored procedures using T-SQL or the CLR
Design and tune highly optimised queries to access or modify data
Design well-architected applications that best utilise SQL functionality to meet specific business requirements

Our Microsoft SQL 2005 Sever Database Developer 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 Developer - Benefits

Database developers design and implement relational database models (logical and physical) and database storage objects. They also program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or the CLR. They retrieve or modify data using SQL queries or tune and optimise queries. Database developers are typically employed by mid- to large-sized organisations.

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

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 SQL 2005 IT Pro Database Developer certification is recognised as a particularly elite indication of an Database Developer'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

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 Developer - Curriculum

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

Module 1: Designing an Application Solution for SQL Server 2005
Module 2: Designing a Database
Module 3: Designing Database Objects
Module 4: Designing Database Testing and Code Management Procedures
Module 5: Developing Applications That Use SQL Server Support Services
Exam 70-441
Module 6: Designing Efficient Access to a SQL Server Service
Module 7: Designing a Database Query Strategy
Module 8: Designing Error-Handling Routines Module 9: Designing a Transaction Strategy
Module 10: Performance Tuning a Database and a Database Application
Exam 70-442

Microsoft MCITP Database Developer - Exam Track

This course is focussed on attaining the MCITP Database Developer on SQL 2005 (Microsoft Certified IT Professional) and will include sitting exams MS 70-441 and MS 70-442.

Microsoft MCITP Database Developer - 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 Developer - Prerequisites

Delegates are required to meet the following prerequisites:

MCTS SQL05 (Microsoft Certified Technical Specialist: SQL Server 2005)
Development experience with the ADO.Net and the .Net Framework

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 Developer Testimonials

"Excellent Experience, would higly recommend."
Craig Hawes, The Blue Coat School.

"A great nine days of training. The subjects were tough, but the instructor broke them down into manageable chuncks. I achieved the goals I set out to and met a great bunch of people on the way. The instructor was brilliant. A really friendy guy who new the subject thoroughly."
Edward Herbert, Brandwidth.

"Excellent instructor and methods. The instructor really knows his stuff."
Neil Grant, Artesia - opentext.

"Nice course friendly people. Course is demanding and requires significant pre-reading to avail maximum benefit. "
Sanjay Mudaliar, Bank.

"A very intense but worthwhile learning experience. My Instructor was exceptionally knowledgeable in his subject area and explained complex concepts in a way that was easy to understand. He was also more that willing to chat about real world examples and best practices. Having said that, don’t under estimate this course you really need a decent base level of understanding to pass the exams and keep up with the pace! "
C.C, Prodo.

"The training at Firebrand is excellent. They get the most important thing right. Choice of instructor."
PE, Logicalis.

"I was very impressed with the instructor. He delivered the course at the right pace and level to get through all the material, which is substantial! To any further students I can fully recommend this course and suggest they prepare as much as possible. "
Ralph Carter, AIM Technology.

"Very good location, extremely good instructors and a good atmosphere. I did MCSE 2003 at home on my own and it was not the same. It is so good having other people to talk to about the subject. Also being away from home means much more time is spent learning and not being distracted. I strongly recommend Firebrand Training to anybody wanting to get qualified (and quick too!)"
Tom Sage, Balfour Beatty (interroute).

"A very professional and focused experience."
Rasmus Lamp Posselt, Proinfo A/S.

"A first-class course, well delivered by an excellent instructor."
Trevor Riley, PSU Technology Group.

"Although very intensive and you should expect no less, Firebrand Training delivers first class training in a comfortable enviroment for you to produce first class results. "
Mark Taylor, The Ryes School Ltd.

"MCPD certification in 2 weeks... a lot of hard work but it is amazing, the amount you can learn in a short time. It is due to the excellent location and facilities but mainly our instructor. He is an excellent instructor who really knows his subject inside out."
Andrew McGibbon, ITP Solutions.

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

"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.

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

"Accelerated training - understatement! The pace of the course was phenomenal & definitely not suitable for anyone without significant experience with older versions of the products being taught. However, the course instructor and the other Firebrand Training staff are extremely supportive & will help you work through issues, both in the classroom, and out of hours."
Anne Danks, QinetiQ.

"The course was very tough but I felt that our instructor covered all of the material in a very effective and easy to pick up way and held the interest of the class throughout the course. I feel that I have greatly improved my knowledge of the .net framework and would recommend Firebrand Training to anyone considering tackling the Microsoft Exams. "
Guy Wilson, Education Direct.

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

"I went in to this course knowing it would be a hard slog. And it was 9am till 12pm every day is needed to try and get all the information in even if like me you had been using the products for 2 years. Do not attempt the course without experience if you want the full qualification it would be a waste. "
Neill Riordan, Nothing.

"Being able to learn away from the "real world" where all base requirements (food/accommodation) are catered for helps greatly in the learning experience. I would use Firebrand Training again."
Ian Ridley, Attain Limited.

"While this course was not what I would call a bootcamp, it was informative, detailed and thoroughly absorbing. "
Marc Rogers, Vodafone.

"Great food!"
Sebastian Page, NHS.

"I would highly recommend the Firebrand Training courses to anybody including non-industry people. The courses are intense, but the delivery of the content is first class."
Mark Gambrell, MTA Solicitors.

"Undoubtebly the best centre to attend for anyone wishing to get certified, or just for IT knowledge."
Steve Houghton, none.

"The training was brilliant and the instructor was engaged and interesting."
HS, Lloyds TSB.

"Although I found this course very tough, and didn't succeed in the end, I have taken away a very good fundamental knowledge of the subjects divisions. I will now be able to return, practice more on the areas required and return to pass. I believe I have learnt a lot for someone with very little experience."
Nathan Bull, Itex Jersey.

"The CISSP course was very hard but rewarding. The instructor covered the large sylabus in a clear and easy to understand manner. I would not hesitate to recommend this course to potential CISSP candidates. "
Neil Croft, BT.

MCITP Database Developer Course Dates

Start	End	Availability	Register
8/12/2008	13/12/2008	Finished
16/2/2009	21/2/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?