Our E-learning curriculum is specifically designed with the busy professional in mind. All of our programs are produced using advanced learning concepts that encompass learning techniques that are designed for adult learning. E- learning is very popular today for a very good reason – It Works! People everywhere are discovering that they can fulfill their learning objectives conveniently (at their own pace, on their own time) and affordably (online classes start at a fraction of the cost of traditional classroom training).
Our easy-to-use delivery format allows you to concentrate on the lesson at hand and not how to run the delivery software – saving you time and frustration. Our comprehensive course materials are delivered in an easy-to- understand format – allowing you to get the most out of your time online.
The Microsoft Certified IT Professional (MCITP) credential validates that an individual has the comprehensive set of skills necessary to perform a particular job role, such as database administrator or enterprise messaging administrator. MCITP certifications build on the technical proficiency measured in the Microsoft Certified Technology Specialist (MCTS) certifications. Therefore, you will earn one or more MCTS certifications on your way to earning an MCITP credential.
MCITP candidates are capable of deploying, building, designing, optimizing, and operating technologies for a particular job role. They make the design and technology decisions necessary to ensure successful technology implementation projects.
The MCITP for Database Administrator is designed for individuals working with SQL Server 2008 and performing database administrator tasks: installing, configuring, and maintaining.
The MCITP for Database Administrator requires the following two exams:
Microsoft Exam 70-450: PRO-Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 Training Course Curriculum
AND
Microsoft Exam 70-432: MCTS: Microsoft SQL Server 2008, Implementation and Maintenance Certification Training Course
AUDIENCE PROFILE:
Candidates should have one to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who have jobs in which database administration is their main area of responsibility, or they work in environments in which databases are central to their job roles. These job roles include the following:
- IT generalists who work in environments in which SQL Server 2008 is part of an overall solution
- IT professionals who manage systems that run SQL Server 2008
- IT professionals who work with third-party applications that are built on SQL Server 2008
- Developers who build applications that use SQL Server 2008
COURSE FEATURES:
- Instructor led training by the industry’s finest experts delivered via streaming video online or DVD
- Software demonstrations where the instructor shows you how to perform a task onscreen.
- Interactive multimedia presentations
- Easy to navigate controls
- Course bookmarking which allows you to resume training where you left off the last session.
- Hands-on activities and labs
- Review Questions
- Practice Exam Simulators with three different training and testing modes. These simulators can also be used for pre- and post-testing.
- Free technology upgrades for one year
- Educational support
COURSE OUTLINE
Microsoft Exam 70-432
Installing SQL Server
Services and Installation Process
Installing SQL Server
Module Review
Configuring SQL Instances
Common Server Options
Database Mail
Module Review
Managing Databases
Recovery Models
Partitions
Encryption and Compression
Module Review
Disaster Recovery
Backups and Restores
Database Snapshots
Module Review
Security
Authorization
Policies
Database and Server Level Triggers
SQL Server Auditing
Module Review
Indexes
Specialized Indexes
Module Review
Concurrency
Monitoring Locks
Module Review
Optimizing Performance
SQL Server Profiler
Data Collector
Resource Governor
Module Review
Maintaining a SQL Server Database
Automating SQL Tasks
Maintenance Plans
Importing/Exporting Data
Module Review
High Availability
Database Mirroring
Log Shipping
Replication
Module Review
Course Review and Exam Tips
70-432 Demo Scripts
Microsoft Exam 70-450
Module 1: Configuring SQL Server
Module Overview
Hardware Configuration
Windows Configuration
Instance Configuration
Database Configuration
Maintaining SQL Server
Upgrading
Module Review
Module 2: Designing Secure SQL Server Solutions
Module Overview
Authentication
Authorization
Encryption
Policies
SQL Server Auditing
Module Review
Module 3: Designing Highly Available SQL Server Solutions
Module Overview
Failover Clustering
Database Mirroring
Log Shipping
Combining Solutions
Module Review
Module 4: Designing Disaster Recovery Solutions
Module Overview
Backup Strategies
Recovery Strategies
Piecemeal Backup and Restore
Recovering Pages
Media Failure
Database Snapshots
Module Review
Module 5: Designing Data Distribution
Module Overview
SQL Server Integration Services
Replication
Module Review
Module 6: Monitoring SQL Server
Module Overview
Windows Resources
SQL Resources
Resource Governor
Module Review
Course Review
Exam Tips
To order contact Specialized Solutions at:
Specialized Solutions
Corporate Training Division
3727 Jonlen Drive
Cincinnati, OH 45227
Toll Free – 1-877-291-9797
Direct – 513-878-1116