Microsoft - MCTS SQL Server 2005 Certification

A Firebrand Training
5
Day Course

Microsoft - MCTS SQL Server 2005 Certification - Overview

The Technology Specialist certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge of and expertise in the technologies with which they work. Microsoft Technology Specialists are consistently capable of implementing, building, troubleshooting, and debugging a particular Microsoft technology..

The goal of our 5 day accelerated Microsoft SQL Server 2005 certification is to provide IT professionals with the knowledge and skills necessary to design, implement and administer Microsoft SQL Server 2005 databases. This is an accelerated, fully immersed course, designed upon the job-related tasks of a DBA.

The course is appropriate for individuals who 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.

The SQL Server 2005 Course is Appropriate for:

  • Database administrator
  • Database analysts
  • Database developers

Firebrand Training is unlike any other "boot camp". With Firebrand Training, you will learn more. We offer accelerated training courses that ensure professionals will emerge with thorough knowledge of the products in the shortest possible time. 

Instructors are available at all times to provide individual and group attention, lead lab exercises and practice sessions, and ensure the students' success. Our attention to detail shows in our unsurpassed instruction and customer service, our classroom and testing facilities, and our individual and corporate success stories.

From the skilful crafting of our unique curriculum and careful selection of courseware to every detail of your training comfort, Firebrand Training is the best way to obtain SQL 2005 skills. Other training providers cannot match our commitment to quality instruction-led training and top-notch educational facilities.

Interested? See our pricing or text 'firebrand msql05' to 07786 200 690

Microsoft - MCTS SQL Server 2005 Certification - Benefits

So what makes SQL Server 2005 compelling? The following short list highlights some

Enhanced features

  • T-SQL enhancement
  • 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 MCDBA 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.

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

Our approach is highly varied and interactive to keep your attention, promote teamwork, and reinforce knowledge gained through hands-on learning.

You will:

Be Immersed into a distraction-free environment - escaping your normal routine and focusing purely on learning.

Experience Accelerated Learning methods – designed to help you learn much more quickly, spend less time out of the office, and see returns from your investment straight away.

Be Measured through on-site exam testing - creating a complete feedback loop that ensures you understand the subject thoroughly.

With Firebrand Training, you will learn more.

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.

Interested? See our pricing or text 'firebrand msql05' to 07786 200 690

Microsoft - MCTS SQL Server 2005 Certification - Curriculum

Firebrand Training provides thorough instructor-led training to ensure that you learn the fundamentals and obtain hands-on skills. You will emerge able to immediately apply your new knowledge in your career environment.

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

  • Day 1  Using Transact-SQL to retrieve data from SQL Server 2005
  • Day 2  Implementing a Microsoft SQL Server 2005 Database
  • Day 3  Maintaining a Microsoft SQL Server 2005 Database
  • Day 4  Introduction to SQL Server Services
  • Day 5  Exam - 70-431
  • Microsoft SQL Server 2005 - Implementation and Maintenance

Firebrand Training is a Microsoft Certified Partner : Learning Solutions (formerly CTEC). We specially select Microsoft Press or MOC Courseware for the highest-standard training of SQL Server 2005.

Through lecture, group discussion and hands-on lab work, you will learn how to:

  • Use the Development Tools provided with SQL Server 2005
  • Use Transact-SQL enhancements to perform database development tasks
  • Develop XML-based Solutions using SQL Server 2005
  •  Build Message-Based Services with the Service Broker
  • Implement Web Services using Native HTTP Endpoints
  • Build Notification Services Applications
  • Implement Database Functionality with Managed (.NET) Code
  • Build Client Applications with the .NET Framework
  • Build Administrative Applications with SQL Management Objects (SMO)
  • Describe the components of SQL Server 2005
  • Describe new and enhanced features for administrators in SQL Server 2005
  • Plan a SQL Server 2005 installation
  • Install SQL Server 2005
  • Maintain a SQL Server 2005 installation
  • Choose the appropriate tool or utility to perform an administrative task
  • Use SQL Server Management Studio to manage databases
  • Use SQL Server Computer Manager to manage a server
  • Use the sqlcmd utility to execute Transact-SQL from the command prompt
  • Use SQL Management Objects to script common administrative tasks
  • Use SQL Profiler to monitor SQL Server 2005
  • Use DDL triggers to respond to DDL events
  • Use event notifications to respond to database events
  • Query SQL Server metadata
  • Maintain indexes in a SQL Server 2005 database
  •  Use the Database Tuning Advisor to assist with database design
  • Maintain SQL Server 2005 databases
  • Describe the security architecture of SQL Server 2005
  • Manage securables and principals
  • Manage permissions
  • Use certificates in SQL Server 2005
  • Describe common disaster recovery enhancements in SQL Server 2005
  • Use database snapshots
  • Perform backup and restore operations
  • Describe the data availability technologies included in SQL Server 2005
  • Describe the concepts of database mirroring
  • Configure database mirroring
  • Describe the enhancements to replication functionality in SQL Server 2005
  • Describe the new types of replication available in SQL Server 2005
  • Configure replication using SQL Server 2005.

Interested? See our pricing or text 'firebrand msql05' to 07786 200 690

Microsoft - MCTS SQL Server 2005 Certification - Exam Track

Microsoft Certified Technology Specialist on SQL Server 2005 candidates are required to pass Exam 70-431.

Skills Being Measured

The 70-431 certification exam measures your ability to implement and maintain a SQL Server 2005 database. This program shall prepare students in the job skills listed in the following matrix:

  • Installing and Configuring 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.

Interested? See our pricing or text 'firebrand msql05' to 07786 200 690

Microsoft - MCTS SQL Server 2005 Certification - What's Included

Microsoft courseware

Our accelerated program includes the most comprehensive industry courseware available - which serves as excellent post-class reference material.  In addition, students receive access to our online pre-class study materials immediately upon program registration.

With Firebrand, you benefit from top-quality education in an all-inclusive course package specifically designed for the needs and ease of our students. We attend to every detail so you can focus solely on your studies and certification goals.

You’ll get a robust set of course materials that cater to each of our three key individual learning styles (auditory, visual, and kinaesthetic-tactile) - critical for a successful learning experience.

Our Certification Programs include*

  • Daily lectures, exercises, and review sessions
  • Intensive Hands-on Training Utilising our (Lecture | Lab | Review)TM Delivery
  • Comprehensive study materials and courseware - we adapt official curriculum to address the demands of accelerated learners
  • Self-testing software and/or mock exam papers
  • Fully instructor-led program with 24 hour lab access
  • Exam vouchers
  • On site testing
  • Accommodation, all meals, drinks and snacks
  • Our Certification Guarantee - because we're sure you'll pass first time, if don’t pass your exams, come back to the course within a year and you only pay for accommodation and exam vouchers - everything else is free

* Please note:

  • Our ISC(2) Cissp CBK Review program differs from normal course delivery. For more details, speak to us on 080 80 800 888.
  • Exam vouchers for our (ISC)2 certifications need to be purchased directly from (ISC)2
  • On site testing is not included in our Scrum, ISACA or PMI 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 accommodation and vendor exam fees.

Interested? See our pricing or text 'firebrand msql05' to 07786 200 690

Microsoft - MCTS SQL Server 2005 Certification - Prerequisites

Students who are successful in accelerated SQL 2005 certification training may possess

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases
  • Experience with database design

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.

Interested? See our pricing or text 'firebrand msql05' to 07786 200 690

MCTS SQL Server 2005 Certification - Testimonials

"The camp provided an excellent environment in which to study. The food was fantastic. All staff were friendly and helpful. Accomodation was clean, quiet and comfortable. The lecturer knew his stuff and was friendly and helpful throughout."
Glen Wilkinson, GetMeIn.com.
Microsoft MCTS SQL Server 2005 (5 Days) (9/6/2008 to 13/6/2008)

"Another well run course that provided excellent training in a cost-effective manner."
Bretton Jones, BullRushIT.
Microsoft MCTS SQL Server 2005 (5 Days) (4/6/2007 to 8/6/2007)

"Hard Work with the hours but covered a large range of subjects in depth. Although I have used SQL for many years we covered lots of areas I have never used."
Andy Wallace, SoftBrands.
Microsoft MCTS SQL Server 2005 (5 Days) (24/11/2008 to 28/11/2008)

"This highly intense training course provided a solution to enhance my overall competence with SQL2005 and achieve the knowledge base to pass the MCTS."
Steve Knight, Lenzing Fibers Grimsby.
Microsoft MCTS SQL Server 2005 (5 Days) (19/11/2007 to 23/11/2007)

"Its a benefit to be isolated from everyday life, and in the company of people with a common goal. The long hours engender a team spirit, and an atmosphere of mutual support. All in all its hard graft, but well worth it."
Keith Woodcock, Ecclesiastical Insurance.
Microsoft MCTS SQL Server 2005 (5 Days) (2/10/2006 to 6/10/2006)

"Firebrand* is a great place to learn. Everyone is nice and helpful, its not a walk in the park, but is totally worth the large amount of effort that is needed in major studying.."
NB, BrainJuicer.
Microsoft MCTS SQL Server 2005 (5 Days) (30/10/2006 to 3/11/2006)

"The best training courses I have worked with. Will not use others in the future."
Simon Bowyer, Kerry Foods.
Microsoft MCTS SQL Server 2005 (5 Days) (4/6/2007 to 8/6/2007)

"Hard Work, but met all my trainig needs. Excellent environment to focus on achieving your certification "
AC, Unisys .
Microsoft MCTS SQL Server 2005 (5 Days) (30/10/2006 to 3/11/2006)

"I spend months trying to learn for this exam myself. It took only 5 days to clear this millstone."
Ashley Bill, Tower software.
Microsoft MCTS SQL Server 2005 (5 Days) (19/11/2007 to 23/11/2007)

"Everything was laid on, allowing us to concentrate on our studies. Made a demanding schedule possible."
Nigel Harris, AEA Technology plc.
Microsoft MCTS SQL Server 2005 (5 Days) (15/1/2007 to 19/1/2007)

"Having been my second course at the camp I think its a great experience. You learn a lot in 5 days and get certified as an added bonus."
Nicolas Cure, Allied Irish Bank.
Microsoft MCTS SQL Server 2005 (5 Days) (7/5/2007 to 11/5/2007)

"They do exactly what you expect, Teach, Train & Communicate the materials and infomation you need for both the course itself and real world examples of Best Practice. "
Alasdair Thomson, Voice Marketing Ltd.
Microsoft MCTS SQL Server 2005 (5 Days) (24/9/2007 to 28/9/2007)

"The training is intense and hard going but is compensated by the beautiful surroundings. Whilst the bedrooms are quite basic they are functional and their location close to the class room is excellent."
Heather Hayes, Maginus Software Solutions.
Microsoft MCTS SQL Server 2005 (5 Days) (22/10/2007 to 26/10/2007)

"Fantastic Massively hard work - 16hours a day - but worth it. Strongly recommend"
Andy Bourdillon, PDMS.
Microsoft MCTS SQL Server 2005 (5 Days) (2/10/2006 to 6/10/2006)

"Excellent - hope my company send me back for more courses, the best way ive found to learn."
Shaun Watson, Pinacl Solutions Ltd.
Microsoft MCTS SQL Server 2005 (5 Days) (7/8/2006 to 11/8/2006)

"Although extremely intensive, the overall experience was great. The instructor was brilliant, and the other people on the course were easy to get along with. The level of learning provided is the best combination I can imagine to pass this exam."
Rose Aylward, Novia Financial Plc.
Microsoft MCTS SQL Server 2005 (5 Days) (13/7/2009 to 17/7/2009)

"Excellent Instructor, excellent facilities, excellent course.. one exam Passed!"
P.B., Maginus Software Solutions.
Microsoft MCTS SQL Server 2005 (5 Days) (22/10/2007 to 26/10/2007)

"The instructor managed to get by level of knowledge above expectation level. Thanks Firebrand Training. "
Stephen de Jong, database administrator.
Microsoft MCTS SQL Server 2005 (5 Days) (2/3/2009 to 6/3/2009)

"Excellent training, great facilities, real world trainers and absolutely stunning food. The course was definately not for the faint hearted or those who only want to work 9 to 5. If you come here, put in the effort and are prepared to work hard, you may be suprised with the Firebrand* outcome!"
Mark Beeken, Olympus Automation Ltd.
Microsoft MCTS SQL Server 2005 (5 Days) (24/9/2007 to 28/9/2007)

"The training is intense and hard going but is compensated by the beautiful surroundings. Whilst the bedrooms are quite basic they are functional and their location close to the class room is excellent."
Heather Hayes, Maginus Software Solutions.
Microsoft MCTS SQL Server 2005 (5 Days) (22/10/2007 to 26/10/2007)

"A lot more intensive than i expected but worth it for the end result."
Mark Whyman, Ceva Logistics.
Microsoft MCTS SQL Server 2005 (5 Days) (2/3/2009 to 6/3/2009)

"The course was excellently presented and well-balanced, the accomodation was of a higher-than-expected standard, and the food was superb!"
CS, BrainJuicer.
Microsoft MCTS SQL Server 2005 (5 Days) (30/10/2006 to 3/11/2006)

"Cramming that much information in such a short space of time takes it's toll physically and mentally, but our instructor's style, obvious enthusiasm and love for the subject made a 13-14 hr day interesting, funny and an excellent learning experience. I would recommend Firebrand* to anybody who needs to get/be certified!"
Lance Benger, O-A-Sys.
Microsoft MCTS SQL Server 2005 (5 Days) (7/5/2007 to 11/5/2007)

"When I needed to attain qualification in SQL Server 2005, I immediatley returned to Firebrand*. Based on previous experience I knew there was nowhere better to fulfill my needs. I was not dissapointed. "
Barry Connor, nowCasting Systems.
Microsoft MCTS SQL Server 2005 (5 Days) (9/4/2007 to 13/4/2007)

"I have always been amazed at how the instructors remain happy. Its nice to see old acquantances in a familiar surrounding and having them remember then. Always a joy. Albeit the curriculum out of my league and personal sphere of influence professionally wise."
Janice Laurence, Duncan Lawrie Ltd.
Microsoft MCTS SQL Server 2005 (5 Days) (13/7/2009 to 17/7/2009)

"Excellent Environment, Focussed training. I wouldnt have passed the exam in such a short space of time without this course...but be prepared to work! Accelerated training requires focus and dedication."
PW, COA Solutions.
Microsoft MCTS SQL Server 2005 (5 Days) (19/11/2007 to 23/11/2007)

"Phew - hard work, but made it through with a pass. Thanks."
Adam Hyland, bachmann group.
Microsoft MCTS SQL Server 2005 (5 Days) (<--Please Select-->)

"I found the course very intensive and extremely hard work. Even though I was certain that I wasn't going to pass the exam, I managed to get through with a grade much higher than I expected. Maybe this proves that this full-on method of training works."
Andy Heissig, Skandia Life.
Microsoft MCTS SQL Server 2005 (5 Days) (26/2/2007 to 2/3/2007)

"The course was excellently presented and well-balanced, the accomodation was of a higher-than-expected standard, and the food was superb!"
CS, BrainJuicer.
Microsoft MCTS SQL Server 2005 (5 Days) (30/10/2006 to 3/11/2006)

"Excellently run and focussed intensive training course. Not for Wimps."
Anthony Yalden, Yalden Computer Services.
Microsoft MCTS SQL Server 2005 (5 Days) (19/11/2007 to 23/11/2007)

MCTS SQL Server 2005 Certification - Course Dates

Start

Finish

Status

Book now

12/4/2010

16/4/2010

Limited availability

Book now

Bookmark Microsoft - MCTS SQL Server 2005 Certification

Talk to us about Firebrand Training and our accelerated courses:080 80 800 888

Talk to us about Firebrand Training and our accelerated courses:

080 80 800 888

Request more information about Firebrand Training and our accelerated courses:

Request more information about Firebrand Training and our accelerated courses:

Firebrand Training printable phone icon Talk to us about this course on: 080 80 800 888