On the 1st October 2007 The Training Camp UK became Firebrand Training. Learn more

Microsoft MCTS SQL Server 2008, Implementation and Maintenance

A Firebrand Training


6


Day Course

Microsoft MCTS SQL Server 2008, Implementation and Maintenance - Overview

SQL Server 2008 delivers on Microsoft's Data Platform vision by helping your organization manage any data, any place, any time. Your data can be stored and accessed in your largest servers within the data centre all the way down to desktops and mobile devices, enabling you to have control over your data no matter where it is stored.

SQL Server 2008 delivers a trusted, productive, and intelligent data platform for all your data needs.

During this 6 day Accelerated Learning course, delegates will learn how to install and configure SQL Server 2008, how to maintain instances, manage security, maintain a database and perform data management tasks. They will also learn how to monitor and troubleshoot SQL Server, optimize performance and implement high availability.

Microsoft MCTS SQL Server 2008, Implementation and Maintenance - Benefits

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 MCTS SQL Server 2008, Implementation and Maintenance - Curriculum

  • Install SQL Server 2008 and related services
  • Configure SQL Server instances
  • Configure SQL Server services
  • Configure additional SQL Server components
  • Implement database mail
  • Configure full-text indexing
  • Manage SQL Server Agent jobs
  • Manage SQL Server Agent alerts
  • Manage SQL Server Agent operators
  • Implement the declarative management framework (DMF)
  • Back up a SQL Server environment
  • Manage logins and server roles
  • Manage users and database roles
  • Manage SQL Server instance permissions
  • Manage database permissions
  • Manage schema permissions and object permissions
  • Audit SQL Server instances
  • Manage transparent data encryption
  • Configure surface area
  • Back up databases
  • Restore databases
  • Manage and configure databases
  • Manage database snapshots
  • Maintain database integrity
  • Maintain a database by using maintenance plans
  • Import and export data
  • Manage data partitions
  • Implement data compression
  • Maintain indexes
  • Manage collations
  • Identify SQL Server service problems
  • Identify concurrency problems
  • Identify SQL Agent job execution problems
  • Locate error information
  • Implement Resource Governor
  • Use the Database Engine Tuning Advisor
  • Collect trace data by using SQL Server Profiler
  • Collect performance data by using Dynamic Management Views (DMVs)
  • Collect performance data by using System Monitor
  • Use Performance Studio
  • Implement database mirroring
  • Implement a SQL Server clustered instance
  • Implement log shipping
  • Implement replication
  • Review
  • Exam 70-432

Microsoft MCTS SQL Server 2008, Implementation and Maintenance - Exam Track

This course prepares students for the exam 70-432. The exam provides a valid and reliable measure of technical proficiency and expertise.

Candidate Profile

Candidates for this exam are IT professionals who have jobs in which database administration is their main area of responsibility, or they work in environments in which databases are central to their job roles. These job roles include the following:

  • IT generalists who work in environments in which SQL Server 2008 is part of an overall solution
  • IT professionals who manage systems that run SQL Server 2008
  • IT professionals who work with third-party applications that are built on SQL Server 2008
  • Developers who build applications that use SQL Server 2008

Microsoft MCTS SQL Server 2008, Implementation and Maintenance - 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 MCTS SQL Server 2008, Implementation and Maintenance - Prerequisites

  • At least one year of experience using SQL Server 2005 or higher in a live production environment
  • An understanding of T-SQL
  • Experience of Windows Server
  • Experience of database design

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.

MCTS SQL Server 2008, Implementation and Maintenance Testimonials

"Firebrand provides an excellent, highly focused and friendly learning environment with first-class instructors. I would strongly recommend their training courses."
DC, RM Education.

"Hard work but well worth it."
CP, ScS.

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

"Firebrand are an excellent company to help you through the courses. Do not expect an easy ride as there is a lot of work, but the instructors and centre staff are always available to help. Excellent food as well!!"
Tom Baker, St Regis Paper.

"The course was good and extremely rigorous."
Ashish Gupta, Quative Ltd (Kudelski Group).

"Many thanks to Firebrand Training and especially the instructor, as I would have never got through the material and taken the exams. Now I am a qualified MCTS in ASP.NET 3.5, and ADO.NET 3.5. One thing to note - this is not a picnic, be prepared to work hard and put the hours in."
Richard Tappenden, Education Direct Ltd.

"Firebrand Training was an excellent experience! It is certainly hard work and theres no escaping it...but it is worth it!"
David Smith, St Regis Paper Company.

"The course was good and extremely rigorous."
Ashish Gupta, Quative Ltd (Kudelski Group).

"An excellent way to study for the exam - lots of tips and focus on how to pass, all very condensed. I have never had to take in so much in so short a time. "
DC, Lloyds TSB.

"The CRM 4.0 course is tough, the trainer and staff all pull together to get you through, do not expect to sleep much, but you will have fun and enjoy your experience."
James Howard, route one publishing ltd.

"The training was excellent and well presented. The boot camp was the most effective way to study for the CISSP. "
John Dunne, Grant Thornton.

"I attented MCAD in May 2005 and passed with flying colours, and came back to MCTS 3.5 for more of the same learning experience to keep me up to date as I am a .NET contractor. "
Clive Hesketh, Kop Limited .

"Very focused and concise training to achive certification - with supportive trainers and environment."
BD, BMS (UK) Ltd.

"WELL, REALLY GOOD. I CAN THINK ABOUT MY FUTURE FROM HERE . "
MU, STUDENT.

"Fantastic course, fantastic instructor. The whole experience eased the pain of exam taking."
Viam Mercer, damovo.

"Best course I have ever been on."
Jonathan Leather, Morrisons.

"The hours are long and it is intensive but everyone here can relate to you, the atmosphere is amazing and the staff are so approachable and friendly."
Daniel Drury, Speakerbus Ltd..

"Probably the most intensive course that I have had to go on but this was countered by the friendly helpful atmosphere and setting. "
RC, SBA Limited.

"I thoroughly enjoyed my experience here at Firebrand. Let noone be under any illusion that you wont work hard as the course is intensive and demanding. However, that said, the staff and instructors are excellent and the food is simply superb and the accomodation very comfortable. I would recommend anyone wanting to get a real-world knowledge of their product, rather than a exam-by-numbers approach adopted by other companies to come to Firebrand, as you can guarantee going away with knowledge to further your career in your chosen field. "
Antony Blackwell, Htec Ltd..

"This is the way to do training. It is intensive and focused but it provides the ideal environment to learn the subject and pass the exams. Excellent food and trainers. Highly recommended."
Andrew Deacon, Cabinet Office.

"I have leant a lot in such a sort time. I have enjoyed the experience."
Michele Greenwood, Morrison.

"Firebrand Training offer a training solution that fits the busy technical professional. It is difficult or even impossible for anyone to get away and do the courses separately, so the bootcamp is ideal. Staff are amazingly friendly, and the instructor is both knowledgable, personable, and articulate. An amazing two weeks, and I will definitely be back!"
Simon Phillips, Yokogawa Middle East.

"Took the final MCITP:EA exam a day early, without revision and passed. The Firebrand Training experience is intense, but very very worthwhile. "
Frank Murray, DynCorp international.

"Knackering but worth it! I you are prepared to do the work you reap the rewards!"
Michele Curtis, NHS Supply Chain.

"Exceptional instructor, relaxing environment, all set for mastering in your subject area."
FH, EDS Hungary.

"Have self funded my course and I felt that I recieved excellent value for money."
Adrian Law, Soon to be self employed.

"The course was very hard going but very good. The centre, all the staff and the food were all excellent. The only thing that I would advise is that you have a very good understanding of computers and IT before you come. This was a complete career change for me and I had very little computing knowledge when I started, unlike everyone else on the course, but I worked hard and manged to get my first IT qualification. So it can be done. Would definitley recommend Firebrand Training. "
MP, un-employed.

"The training centre provided the best learning environment I have ever been in. The days were long, but productive and were made easier by a flexible attitude to breaks and modes of study. The lecturer was very well versed in his subject and his enthusiasm was infectious (well, almost!)."
Julia Halliday, Morrisons PLC.

"The training course with Firebrand was excellent, I do not believe I could have acheived my results in another setting or with another style of teaching."
Nathan Lee Cartwright, Contoso.com, its all I can think of! Seriously though, its SafeCom.

"Firebrand Training was brilliant. The course was very intense, however the tutor really knew his stuff and the facilites at the camp were great! The tutor was very helpful and will stay up as long as you need in order for you to gain the knowledge. You do have to put the hard work in though to obtain the results!"
SP, HeathLambert Group.

MCTS SQL Server 2008, Implementation and Maintenance Course Dates

Start

End

Availability

Register

10/11/2008

15/11/2008

Finished

 

5/1/2009

10/1/2009

Seats open

Register

23/2/2009

28/2/2009

Seats open

Register

6/4/2009

11/4/2009

Seats open

Register

18/5/2009

23/5/2009

Seats open

Register

29/6/2009

4/7/2009

Seats open

Register

Related Microsoft MCTS SQL Server 2008, Implementation and Maintenance resources

Bookmark Microsoft MCTS SQL Server 2008, Implementation and Maintenance

Talk to us on the phone about MCTS SQL Server 2008, Implementation and Maintenance: 080 80 800 888

Talk to us about Microsoft MCTS SQL Server 2008, Implementation and Maintenance:
080 80 800 888

Request more information via email about MCTS SQL Server 2008, Implementation and Maintenance

Request more information about Microsoft MCTS SQL Server 2008, Implementation and Maintenance. Enter your email address:

Print all MCTS SQL Server 2008, Implementation and Maintenance information

Print all Microsoft MCTS SQL Server 2008, Implementation and Maintenance information