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.
This exam is targeted at the professional level SQL Server 2008 Database Administrator. It tests your ability to make appropriate design and technology choice considerations for your SQL Server 2008 installations.
AUDIENCE PROFILE:
Candidates for this exam work in an environment in which Microsoft SQL Server 2008 is used for database solutions. Candidates should have at least three years of experience administering databases in an enterprise-level organization and designing, deploying, optimizing, maintaining, and supporting database service life cycle. Candidates should also have experience with the following:
- Defining high-availability solutions
- Data distribution
- Automating administrative tasks (for example, checking db stats, backups)
- Maintaining administrative tasks (for example, determining index rebuild time, file groups for backup)
- Defining security solutions
- Monitoring and troubleshooting the database server
- Performance optimization (for example, physical tuning, including hardware, operating system, instance-level tuning), PerfMon
- Designing and executing deployments
- Deployments and migration
- Defining the infrastructure (for example, storage, hardware, and number of servers or instances)
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
Course: 70-450
Course Introduction
Instructor Introduction
Course Overview
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