"
You did a great service for me in helping me pass all my exams in a
2-month period and I am happy to say that my job is working out great.
Your training program is first rate. Your program makes it easy to learn, but most important you don't forget what you did learn from the course.
"
-
Paul Joyner
|
"
To even call your training program online training is misleading as, in my opinion, you have no competition when comparing the quality and efectiveness of your training offerings to any other. I will never take a face to face class again.
"
-
IT Manager
KBL
|
|
Live, Online Instructor-led MCTS/MCITP: SQL 2008 Database Administrator
Training
|
Microsoft Certified Information Technology Professional (MCITP): SQL 2008
Database Administrator Certification Training Packages
with Microsoft Certified Technology Specialist (MCTS): SQL 2008 Administrator | Course Overview
Our complete MCITP: SQL 2008 packages give you the expert knowledge and hands-on experience you need to master SQL Server 2008 database administration and pass both of Microsoft exams for this advanced level certification. This course includes preparation for both the MCTS: SQL 2008
Database Administrator prerequisite exam and the advanced MCITP: Database Administrator exam. For one low price, you‘ll tap into the most powerful learning system available anywhere. The Insider Training Multi-Path Learning System will maximize what you learn, and more importantly, how much you retain.
Important Note: Passing the MCTS: SQL 2008 Administrator exam is a prerequisite
for achieving MCITP certification. This class includes both MCTS and
MCITP training. If you are interested in MCTS:
SQL 2008 Database Administrator only, click here. If you are interested in
MCITP: Database Administrator training only, click here.
Students who register for any SQL 2008 course will also receive
access to SQL 2005 training for free.
This course provides a comprehensive learning track for both new and experienced database administrators to understand implementation, maintenance, database infrastructure design and optimization of SQL 2008. The course begins with a detailed focus on SQL 2008 Implementation and Design which includes foundational topics required by both database administrators and developers such as installation, configuration, Transact-SQL, data management, XML interactions, and backup and restore. Designing a Database Infrastructure focuses on advanced administration topics such as capacity planning, security design, high availability solutions, data recovery and archiving. The Optimizing and Maintaining portion of the course focuses heavily on troubleshooting and disaster planning, monitoring, advanced data management, and security monitoring and response.
Available Course Formats: |
|
| Available Formats | | Key Benefits | +LIVE Premium | On Demand
* | | Expert instructors | X | X | | Flexible scheduling | X | X | | No travel required | X | X | | No out of office days | X | X | | Key Features | | +LIVE class hours | 40 | 40 | | +LIVE class duration | 10 weeks | 10 weeks | | +LIVE class recordings | X | X | | Live hands-on labs on your schedule | 60 hours | * | | Extended Online access (months) | 12 | 6 | | Study Guide | X | * | | Ongoing instructor mentoring | X | * | | 2 Transcender test prep products (included in reg. fee) | $298 value | * | | 2 Premium course books (included in reg. fee) | $120 value | * | | Guaranteed certification | X | | | 1 Premium headset with microphone (included in reg. fee) | $75 value | $75 value |
* On Demand Premium is currently not available for this course |
PREPARATION FOR EXAMS: MCTS: SQL 2008 and MCITP: SQL 2008 Administrator - 70-432: TS: Microsoft SQL Server 2008: Implementation and Maintenance
- 70-450: PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure by Using Microsoft SQL Server 2008
|  | +LIVE Online Instructor Led Sessions
We know you‘re busy. That‘s why we‘ve designed a flexible training schedule that works around you! The +LIVE course meets twice a week for two hours at a time for live, online, instructor-led sessions.
Our unique 7-step program starts with hand-picked, certified trainers with extensive consulting and training backgrounds. Each week you‘ll attend live, information-packed sessions that cover three to four major topics in depth. Because it‘s live, you‘ll be able to get your toughest questions answered right away. In-class quizzes and surveys will ensure that you‘re absorbing the key points along the way. | | 24/7 Access to Class Recordings
Need to miss a class? No problem! All class sessions are
digitally recorded and automatically indexed so that you can review the material at any time. You‘ll be able to tap into your class recordings immediately after the live sessions
and have extended access for a full twelve months starting from when
your course begins. | | Hands-On Lab Time
Insider Training‘s remote lab gives you the ability to put your knowledge to work on real systems on your own schedule. Your private lab time is scheduled in advance at any time convenient for you. When you connect in, you‘ll be in total control of multiple real systems. | | Ongoing Instructor Mentoring
Your instructor is available to answer your questions inside and outside of class. You‘ll have email access for
twelve months starting from when your course begins. | | Highest-Rated Transcender Practice Exam Simulations Before tackling the real exam, you‘ll know you‘re prepared by taking these hard-hitting practice exams. Each simulation provides three complete practice exams with questions that closely match the style and wording of the real thing. Each question explains both the right and wrong answers with references to supporting documentation.
|
| | | Exam ID | Price | Transcender Product | | 1 | 70-432 | $149.00 | MSCert: TS - Microsoft SQL Server 2008 Implementation and Maintenance | | 1 | 70-450 | $149.00 | MSCert: PRO - Designing, Optimizing, and Maintaining a Database Server Infrastructure by Using SQL Server 2008 |
| | TOTAL VALUE | $298.00 | This is included your +Live Premium and On Demand Premium registration fees. |
| |
2 Microsoft Press Self-Paced Training Kits
Each kit includes hands-on practice labs, and sample test questions. They‘re clearly written and highly regarded by our instructors and students alike.
|
| | | Publisher | Price | Name | | 1 | Microsoft Press | $59.99 | MCTS Self-Paced Training Kit (Exam 70-432): Implementing and Maintaining Microsoft SQL Server 2008 | | 1 | Microsoft Press | $59.99 | MCITP Self-Paced Training Kit (Exam 70-450): Designing, Optimizing, and Maintaining a Database Server Infrastructure Using Microsoft SQL Server 2008 |
| | TOTAL VALUE | $119.98 | This is included your +Live Premium and On Demand Premium registration fees. |
|
Certification Guarantee
If you purchase the +LIVE Premium and you meet the course prerequisites, we guarantee that you will pass your certification exams. If you do not pass an exam, we will assign an instructor to work with you until you succeed.
| PREREQUISITES: - Broadband Internet connectivity (DSL, Cable or other high-speed connection)
AND
- 1 year of hands-on experience as a database administrator or developer
or
- 1 year of hands-on experience as a systems administrator or support specialist
|
|
Course Overview
|
SQL 2008 Implementation and Maintenance
- Installing SQL Server 2008
- Configuring SQL Server 2008
- Configuring Additional SQL Server Components
- Implementing Database Mail
- Managing SQL Server Agent
- Implementing the Declaritive Management Framework (DMF)
- Backup a SQL Server Environment (Operating System Level)
- Managing Logins and Server Roles
- Managing Users and Database Roles
- Managing Permissions
- Auditing SQL Server
- Managing Transparent Data Encryption
- Configuribng Surface Area
- Backup and Restore Databases
- Managing Database Snapshots
- Maintaining Database Integrity
- Implementing Database Maintenance Plans
- Manage Data Partitions
- Implement Data Compression
- Maintaining Indexes
- Troubleshooting and Tuning SQL Server
- Implementing Mirroring
- Implementing Log Shipping
- Implementing Replication
|
SQL 2008 Designing, Optimizing and Maintaining a Database Server Infrastructure
- Designing for capacity requirements
- Specify software versions and hardware configurations
- Designing physical storage and instances
- Designing a database consolidation strategy
- Analyzing business requirements
- Integrating database security with enterprise-level authentication
- Developing Microsoft Windows server-level security policies
- Analyzing the risk of attacks and specify mitigations
- Designing SQL Server service-level security
- Designing database-level security
- Designing object-level security
- Analyzing performance and business requirements
- Designing an encryption strategy
- Designing a recovery test plan
- Using the Resource Governor and Query Governor
- Designing a compression strategy
- Administering Integration Services, Linked Servers, and Replication
- Creating database standards, and change control procedures
- Selecting high-availability solutions based on business requirements
- Develop a strategy for migration to a highly available environment
- Designing a highly available database storage solution
- Designing a database clustering solution
- Designing database mirroring
- Designing a high-availability solution based on replication
- Designing log shipping
- Specifying data recovery solutions based on business requirements
- Designing backup strategies
- Creating a disaster recovery plan
- Selecting archiving techniques based on business requirements
- Planning for data archival and access
- Designing the topology of replication for archiving data
- Designing the type of replication for archiving data
|
| |
|
|
|
