SQL 2005 MCTS (Microsoft Certified Technology Specialist) Certification: Developer and Administrator Boot Camp Class
Microsoft Certified Technology Specialist Microsoft SQL 2005 MCTS Boot Camp
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.
Microsoft Certified Technology Specialists in SQL Server 2005 (MCTS: SQL Server 2005) implement and maintain databases
using specific instructions and specifications. They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to navigate the user interface. Technology
Specialists are typically pursuing careers as a database administrator, database developer, or business intelligence developer. They may also be individuals such as developers and systems administrators who do
not work with SQL Server on a daily basis but wish to show their breadth of technology experience.Whether you are
planning to start migrating to SQL Server 2005 tomorrow or not for another six months, take the time now to plan and educate your team.
Our program is a lab-intensive, residential course, designed for information technology professionals that require
effective, real-world skill-building and timely certification. You will live, learn, and test on-site.
Our Boot Camp
- Allows you to achieve your certification in a fraction of the time of 'traditional training' while delivering industry-leading exam passing percentages.
- Helps students grasp complex technical concepts more easily by identifying and catering to individual student learning styles through a mixed visual, auditory and kinesthetic-tactual delivery system.
- Enhances retention by employing accelerated learning techniques focused on committing information to long-term memory.
So what makes the new software so 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 - 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 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, the 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.
Boot Camp Training Overview
Course Materials:
Students attending this blended-learning program will receive a robust set of course materials that caters to each of the
three primary individual learning-intake styles (auditory, visual, and kinesthetic-tactual) - critical for a successful accelerated learning experience.
Daily lectures, labs, and review sessions are supplemented by a combination of:
- Proprietary Lab Manual & Microsoft Courseware - developed in conjunction with Microsoft, adapting Microsoft Official Curriculum to address the demands of accelerated learners.
- Self Test™ Testing Software.
Delivery Schedule:
The MCTS for SQL Server Program effectively prepares students to demonstrate a mastery of both SQL 2000 and
Windows Server 2003 - both skill sets measured by the MCDBA certification exams.
|
Days
|
Module Description
|
Exam
|
|
1
|
Writing Queries Transact-SQL
|
|
|
2
|
Implementing a SQL Server Database
|
|
|
3
|
Maintaining a SQL Server Database
|
|
|
4
|
Introduction to SQL Server Services
|
|
|
5
|
EXAM: Microsoft SQL Server - Implementation and Maintenance
|
70-431
|
|
Daily Educational Schedule:
Our daily schedule incorporates different modes of instruction and learning environments to ensure that students learn,
retain, comprehend, and can apply knowledge critical to a MCTS on SQL 2000.
|
Start Time
|
End Time
|
Activity
|
Intake Style
|
|
8:15 am
|
9:00 am
|
breakfast
|
|
|
9:00 am
|
1:00 pm
|
lecture
|
auditory/visual
|
|
1:00 pm
|
1:30 pm
|
lunch
|
|
|
1:30 pm
|
5:30 pm
|
instructor-led
|
labs kinesthetic
|
|
5:30 pm
|
7:00 pm
|
dinner
|
|
|
7:00 pm
|
8:00 pm
|
review session
|
auditory/visual/kinesthetic
|
|
8:00 pm
|
9:00 pm
|
breakout sessions
|
auditory/visual/kinesthetic
|
|
9:00 pm
|
as appropriate
|
lab review sessions
|
kinesthetic
|
|
Our Boot camp includes:
- Intensive Hands-on Training by Microsoft Certified Trainers utilizing our (Lecture | Lab | Review)™ Delivery.
- Blended-Learning Instruction comprised of comprehensive study materials and pre-class mentoring, customized Microsoft Official Curriculum, comprehensive lab manuals, and Self-Test Testing Software.
- Five (5) Days of Deluxe Hotel Accommodation.
- 24-Hour Lab and Instructor Access.
- Examination Vouchers & On-site Certification Testing.
- Most Meals; Unlimited Beverages, Snacks and Freshly-brewed Coffee.
- Examination Passing Policy. Should a student complete a Training Camp 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.
Boot Camp Training Class Prerequisites
Students who are successful in accelerated SQL 2005 certification training may possess:
- Basic Knowledge of Microsoft Windows operating system and its core functionality
- Working knowledge of Transact_SQL
- Working knowledge of relational databases
- Some experience with database design
Class Schedule
8/25/2008 8/29/2008 Ft. Lauderdale, FL
9/8/2008 9/12/2008 Orange County, CA
9/29/2008 10/3/2008 Vienna, VA
10/13/2008 10/17/2008 Pocono Mountains, PA
11/3/2008 11/7/2008 Dallas, TX
12/1/2008 12/5/2008 Chicago, IL
12/8/2008 12/12/2008 Atlanta, GA
|
