SQL 2008 MCTS DBA (Microsoft Certified Technology Specialist) Certification: Database Administrator Boot Camp Class
 During our 7-day dual Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 Training Camp, students will live, learn, and take the exams at one of our
state-of-the-art education centers. This blended-learning course employs outcome-based (Lecture | Lab | Review)™ delivery that focuses on preparing you with the
real-world skills required to pass the simulator-based exams (and to hit the ground running in your career). You will learn how to work with SQL Server 2008 and
performing database administrator tasks: installing, configuring, and maintaining. You will also work with SQL Server 2008 and writing application code against
systems that run SQL, writing T-SQL or Microsoft .NET CLR code that runs inside SQL 2008, or developing solutions in SQL 2008.
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.
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
|
|
|
Days
|
Module Description
|
|
1
|
Installing and Configuring SQL Server 2008 , Configuration and Maintenance, Tables and Constraints, SQL Server Indexes
|
|
2
|
Partitioning Data, Importing and Exporting Data, Designing Policy Based Management, Backing up and Restoring a Database
|
|
3
|
Automating SQL Server, Designing SQL Server Security, Monitoring SQL Server
|
|
4
|
Optimization, Failover Clustering, Database Mirroring, Log Shipping, Replication
|
|
5
|
Implementing Tables and Views, Implementing Programming Objects, Working with Query Fundamentals, Additional SQL Server Components, Working with XML Data,
Dynamic Management Views, Catalog Views
|
|
6
|
Exam 70-432: Microsoft SQL Server 2008 - Installation and Maintenance
|
|
7
|
Exam 70-433: Microsoft SQL Server 2008 - Database
|
|
Class Schedule
9/6/2010 9/12/2010 Bushkill, PA
9/20/2010 9/26/2010 Washington, DC
10/4/2010 10/10/2010 Dallas, TX
10/18/2010 10/24/2010 San Francisco, CA
11/1/2010 11/7/2010 Bushkill, PA
****Refund Policy- For full refund, class or boot camp must be cancelled via email or fax at least 14 days prior to start of class.
CISSP cancellation period is 21 days do to arrangement of tests via ISC2.
|
