Microsoft MCTS MCITP SQL 2008 Training Boot Camp Class for DBA and DBD Certification Course
 During our 14-day Microsoft Certified IT Professional: Database Developer (MCITP: DBA and DBD) Boot Camp for SQL Server
2008, 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).
The Microsoft SQL Server 2008 DBA and DBD certifications offer you more choices and simpler paths to achieve your certification goals. These certifications differentiate technology skills and job-role skills, and
validate actual IT roles. This MCITP certification covers designing, optimizing, and maintaining SQL Server 2008 databases.
During our 14-day MCITP: SQL Server 2008 DBA and DBD Class, 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 Server 2008, writing T-SQL or Microsoft .NET CLR code that runs inside
SQL Server 2008, or developing solutions in SQL Server 2008.
Our dual MCITP: DBA /DBD Boot Camp course is a lab-intensive, residential course, designed for information technology professionals that require effective, real-world skill-building and
timely certification. This course is intended for students with a working knowledge of Transact-SQL and relational databases. Relevant job titles include:
- Data Architect
- Database Administrator
- Database Technician
- Database Specialist
Boot Camp Includes
- Intensive Hands-on Training by Microsoft Certified Trainers utilizing our (Lecture | Lab | Review)™ Delivery.
- Comprehensive study materials and pre-class mentoring, customized Microsoft Official Curriculum, comprehensive lab manuals, and Self-Test Testing Software.
- Deluxe Package of Fourteen (14 Days of Hotel Accommodations, Breakfast and Lunch, Unlimited Beverages, Snacks, and Freshly-brewed Coffee
- 24-Hour Lab and Instructor Access.
- Examination Vouchers & On-site Certification Testing.
- Examination Passing Policy.
Course Curriculum
Installing and Configuring SQL Server 2008
Configuration and Maintenance
Tables and Constraints
Designing Indexes
Full Text Indexing
Partitioning Data
Importing and Exporting Data
Policy Based Management
Backing up and Restoring a Database
Automating SQL Server
Designing SQL Server Security
Monitoring SQL Server
Optimization
Failover Clustering
Database Mirroring
Log Shipping
Replication
Designing a SQL Server Instance and a Database Solution
Designing a Database Server Security Solution
Designing a Database Solution for High Availability
Designing a Backup and Recovery Solution
Designing a Monitoring Strategy
Designing a Strategy to Maintain and Manage Databases
Designing a Strategy for Data Distribution
Implementing Tables and Views
Implementing Programming Objects
Working with Query Fundamentals
Applying additional Query Techniques
Additional SQL Server Components
Working with XML Data
Gathering Performance Information
Designing a Database Strategy
Designing Database Tables
Designing Programming Objects
Designing an XML Strategy
Designing a Transaction and Concurrency Strategy
Designing Queries for Performance
Designing a Database for Optimal Performance
Exams:
70-432: TS: Microsoft SQL Server 2008 - Installation and Maintenance
70-450: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008
70-433:
TS: Microsoft SQL Server 2008, Database Development
70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
Training Course Schedule - MCITP SQLServer 2008 Database Development (14 day DBD)
MCITP SQL DBD (14 days)
5/14/2012 5/27/2012
Orlando, FL
6/6/2012 6/17/2012
Greenwood Village, CO
San Diego, CA
6/11/2012 6/24/2012
Tempe, AZ
6/18/2012 7/1/2012
Bushkill, PA
7/16/2012 7/29/2012
Henderson, NV
Philadelphia, PA
Vienna, VA
8/6/2012 8/19/2012
Lombard, IL
Norcross, GA
8/27/2012 9/9/2012
Bushkill, PA
9/17/2012 9/30/2012
Addison, TX
Tacoma, WA
10/8/2012 10/21/2012
New York City, NY
Orlando, FL
Vienna, VA
1029/2012 11/11/2012
Tempe, AZ
12/3/2012 12/16/2012
Bushkill, PA
MCITP SQL DBA - 7 days
5/14/2012 5/20/2012
Orlando, FL
6/4/2012 6/10/2012
Greenwood Village, CO
San Diego, CA
6/11/2012 6/17/2012
Tempe, AZ
6/18/2012 6/24/2012
Bushkill, PA
7/16/2012 7/22/2012
Henderson, NV
Philadelphia, PA
Vienna, VA
8/6/2012 8/12/2012
Lombard, IL
Norcross, GA
8/27/2012 9/2/2012
Bushkill, PA
9/17/2012 9/23/2012
Addison, TX
Tacoma, WA
10/8/2012 10/14/2012
New York City, NY
Orlando, FL
Vienna, VA
10/29/2012 11/4/2012
Tempe, AZ
12/3/2012 12/9/2012
Bushkill, PA
****Refund Policy- For full refund, class or boot camp must be canceled via email or fax at least 14 days prior to
start of class. (ISC)2 class cancellation period is 22 days due to arrangement of tests via ISC2.
Resources
Microsoft Certification Tracks, Free Download and Information
|
