Microsoft MCTS / MCITP Database Developer 2008 - Just 6 Days

Win free training for life

Get every certification for free. Enter here

What do our customers say?

"The course has been the most intensive and rewarding course that I have ever attended. I am definitely returning with a lot of knowledge of SQL Server Development and the tools available in the MS SQL Server. "
Rasmus Remmer Nielsen, Fibertex Personal Care A/S - Microsoft MCTS / MCITP Database Developer 2008 (6 days), 24/10/2011 to 29/10/2011

8 reasons why you should take your Database Developer with Firebrand Training:

You will be trained and certified in just 6 days. With us you will be trained and certified in record time. A certification you will complete at our training center as part of the intensive and accelerated training.
Everything is included. A one-off fee covers all course materials, exams, transport service, accommodation and meals and offer the most cost-effective way for you to get your Database Developer training and certification. Without any additional costs.
Pass your Database Developer exam first time or train again for free. This is our guarantee. We are sure you will pass your course first time. But if you don’t, come back within a year, and only pay for accommodation and exams. Everything else is free.
You will learn more. A day with a traditional training provider generally runs from 9am – 5pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day of focused and distraction free quality learning time, with your instructor.
You will learn faster. We combine 3 different learning styles (Visual|Auditory|Tactile), to deliver the material in a way that ensures you will learn Database Developer faster and more easily.
You’ll be studying Database Developer with the best.We have trained and certified 30.000 professionals and we are partners with all of the big names in the business. Furthermore we have won numerous awards, among them “Microsoft Learning Partner of the year 2010 and 2011”, the Institute of IT Training’s "Training Company of the Year" a record three times, ”Highest Performing Affiliate of the Year 2009 – EMEA” from (ISC)2 as well as ”Newcomer of the Year 2011”, ”Accredited Training Centre of the Year 2010” and ”Instructors Circle of Excellence” from EC-Council.
You will learn more than just the theory. We have developed the Database Developer training and use practical exercises to make sure, you can apply your new knowledge to the work environment. Our instructors use demonstrations and real-world experience to keep the day interesting and engaging.
You will learn from the best. Our instructors on Database Developer are the best in the business and offer a unique blend of expertise, experience and passion for teaching.

Think you are ready for the course? Take a FREE practice test to assess your knowledge!

When do you want to sit your accelerated course?

Microsoft - MCTS / MCITP Database Developer 2008
Start	Finish	Status	Location	Book now
10/6/2013 (Monday)	15/6/2013 (Saturday)	Limited availability	Nationwide	Book now

We've trained more than 30,000 students in ten years. We asked them all to review our Accelerated Learning. Currently,
95,88% have said Firebrand exceeded their expectations:

"The course has been the most intensive and rewarding course that I have ever attended. I am definitely returning with a lot of knowledge of SQL Server Development and the tools available in the MS SQL Server. "
Rasmus Remmer Nielsen . - Microsoft MCTS / MCITP Database Developer 2008 (6 days) (24/10/2011 to 29/10/2011)

"An intense but very rewarding experience. I have gained so much SQL Server 2008 knowledge in a such a short time, would recommend! Great Trainer!"
R.P. - Microsoft MCTS / MCITP Database Developer 2008 (6 days) (8/10/2012 to 13/10/2012)

"The instructor succeeded in delivering the course objectives."
Anon.. - Microsoft MCTS / MCITP Database Developer 2008 (6 days) (12/3/2012 to 17/3/2012)

"The facilities were excellent, and matched by the delivery of the training. It was a hard week, but worth it, and enjoyable in the process."
R.P. - Microsoft MCTS / MCITP Database Developer 2008 (6 days) (30/1/2012 to 4/2/2012)

"This is the second time I have used Firebrand training to train for and achieve a Microsoft Certification, and Im very glad I used them again. The course exceeded my expectations with regards to curriculum and material delivery. Our instructor was knowledgeable, not just in Microsoft technologies, but what works and happens in the real world, which is ultimately why we are here. This has been yet another tough but enjoyable experience."
William Relf. - Microsoft MCTS / MCITP Database Developer 2008 (6 days) (30/1/2012 to 4/2/2012)

"I think the course was taught at a good pace, with adequate breaks and split well between teaching during the morning and afternoon before doing labs and measure-up questions in the late afternoon evening."
Stephen Crush. - Microsoft MCTS / MCITP Database Developer 2008 (6 days) (31/10/2011 to 5/11/2011)

"Did the MCTIP DBD course at Firebrand and it was really helpful. The instructor was excellent and was happy to answer any question with minimal effort. But make sure you do the pre-requisites before you go for the course."
S.K. - Microsoft MCTS / MCITP Database Developer 2008 (6 days) (31/10/2011 to 5/11/2011)

"This was my first Microsoft Course, it was hard going but very worth while. The instructor was very knowledgeable and very good at getting across new concepts, as well as explaining the examples. I'm glad that I had a good background in SQL before starting the course, but still be prepared for some late nights. "
Wayne Gibson. - Microsoft MCTS / MCITP Database Developer 2008 (6 days) (31/10/2011 to 5/11/2011)

"Excellent course. Great facilities and instructors who know how to maximise the learning experience. Its hard work but very rewarding if you put the effort in."
M.F. - Microsoft MCTS / MCITP Database Developer 2008 (6 days) (31/10/2011 to 5/11/2011)

"The faclities and staff at Firebrand are exceptional and provide perfect conditions for a completely immersive environment and some serious hard work. We had an incredibly attentive and knowledgeable trainer, I was very pleased with her style and presentation skills. If you are prepared to put the hours in and work very hard, the rewards will pay off. Definitely not an easy ride but well worth it and pleased I left Firebrand with the pass result for the MCITP Certification!"
Simon Walker. - Microsoft MCTS / MCITP Database Developer 2008 (6 days) (8/8/2011 to 13/8/2011)

Our accelerated MCITP Database Developer 2008 course is the fastest and most cost-effective way to be trained and certified in. We have constructed our course material in a way that best prepares you for your exam, which you will take during the course. You will cover the following material:

The latest SQL Server 2008 R2 curriculum is now included. Firebrand Training's accelerated MCITP Database Developer 2008 course will teach you how to:

Create and alter tables.
Create and alter views.
Create and alter indexes.
Create and modify constraints.
Implement data types.
Implement partitioning solutions.
Create and alter stored procedures.
Create and alter user-defined functions (UDFs).
Create and alter DML triggers.
Create and alter DDL triggers.
Create and deploy CLR-based objects.
Implement error handling.
Manage transactions.
Query data by using SELECT statements.
Modify data by using INSERT, UPDATE, and DELETE statements.
Return data by using the OUTPUT clause.
Modify data by using MERGE statements.
Implement aggregate queries.
Combine datasets.
Apply built-in scalar functions.
Implement subqueries.
Implement CTE (common table expression) queries.
Apply ranking functions.
Control execution plans.
Integrate Database Mail.
Implement full-text search.
Implement scripts by using Windows PowerShell and SQL Server Management Objects (SMOs).
Implement Service Broker solutions.
Track data changes.
Retrieve relational data as XML.
Transform XML data into relational data.
Query XML data.
Manage XML data.
Capture execution plans.
Gather trace information by using Profiler
Collect output from the Database Engine Tuning Advisor.
Collect information from system metadata.
Identify which SQL Server components to use to support business requirements.
Design a database model.
Design a data model by using the Entity Framework.
Design an application strategy to support security.
Design a solution by using Service Broker.
Design a Full-Text Search strategy.
Identify the appropriate usage of new data types.
Design tables.
Design data integrity.
Design T-SQL stored procedures.
Design views.
Design T-SQL table-valued and scalar functions.
Design Common Language Runtime (CLR) table-valued and scalar functions.
Design CLR stored procedures, aggregates, and types.
Evaluate special programming constructs.
Design the locking granularity level.
Design for implicit and explicit transactions.
Design for concurrency.
Design XML storage.
Design a strategy to query and modify XML data.
Design a query strategy by using FOR XML.
Design a strategy to transform XML into relational data.
Optimize and tune queries.
Analyze execution plans.
Evaluate the use of row-based operations vs. set-based operations.
Optimize indexing strategies.
Design scalable database solutions.
Resolve performance problems by using plan guides.
Design a table and index compression strategy.
Design a table and index partitioning strategy.
Review

You will be prepared for, and sit the following Microsoft exam:

Exam 70-433: TS: Microsoft SQL Server 2008, Database Development
Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

Our Certification Programmes include everything with;

Practically oriented teaching, which utilising our (Lecture | Lab | Review) methods.
Comprehensive study materials and courseware - we adapt traditional curriculum to address the demands of accelerated learners.
Fully instructor-led programme with 24-hour access to the classroom and instructor.
Exam vouchers and onsite testing at our training centre.
Accommodation, all meals, drinks and snacks.
Our Certification Guarantee - because we're sure you'll pass first time, we offer you a non-conditional guarantee that you will achieve your certification. You have the right to come back to the course as often as you like within a year and you only pay for accommodation and exam vouchers - everything else is free.
Transport to and from the nearest airport/train station before and after the course.

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, unlimited beverages, snacks and tea / coffee***
Transportation to/from designated local railway stations
Examination Passing Policy

Please note

*Examination vouchers are not included for the following courses: PMP, CAPM, CISA, CISM and CISSP CBK Review
**On site testing is not included in our PMP, ISACA, or ITIL Managers and Revision Certifications
***Accommodation not included on the CISSP CBK Review Seminar

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.

Are you ready to get certified in record time?

We interview all applicants for the course on their technical background, degrees and certifications held, and general suitability. If you get through this screening process, it means you stand a great chance of passing.

Firebrand Training is an immersive training environment. You must be committed to the course. 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.

If you have any doubts as to whether you meet the pre-requisites please call 88 18 43 20 and speak to one of our enrolment consultants, who can help you with a training plan.

Interested? See prices or call 0770-17 10 00