This series will prepare you for the TS: Microsoft SQL Server 2008, Implementation and Maintenance exam. This exam is the only requirement to apply for the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Mai
This Microsoft SQL Server 2008 Maintenance MCTS 70-432 online training series provides over 29 hours of self-paced courseware. This web-based training provides 6 months of unlimited access to all of the following lessons:
1 . Configuring SQL Server 2008
2 . ETL Techniques
3 . Implementing Objects
4 . Installing SQL Server 2008
5 . Maintaining Your Database
6 . Managing Data Encryption
7 . Managing High Availability
8 . Managing Replication
9 . Managing Security
10 . Monitoring and Troubleshooting
11 . New Features in SQL Server 2008
12 . Performance Tuning
13 . Practice Exam 1
14 . Practice Exam 2
15 . Practice Exam 3
16 . Practice Exam 4
17 . Service Broker
18 . SQL Server XML Support
Lesson Detail:
Configuring SQL Server 2008
This course explores using multiple SQL Server instances and managing connection protocols and service accounts with Configuration Manager. It also covers some key configuration options and how to set them using sp_configure and Management Studio as well
ETL Techniques
This course covers ways to extract, transform, and load data using SQL Server 2008. SQL Server provides many tools for your ETL needs.
Implementing Objects
This course covers implementing objects using DLL and DML language elements in SQL Server 2008. This includes using tables, indexes, and constraints to view and modify data.
Installing SQL Server 2008
This course covers the installation of SQL Server 2008. More specifically, it reviews the features, capabilities, and limitations of each edition and type of installation. Planning an installation and best practices for hardware utilization are also discu
Maintaining Your Database
This course covers the SQL Server features you use to perform ongoing maintenance tasks to keep your databases functioning well.
Managing Data Encryption
This course covers using encryption in SQL Server 2008. This includes using Transparent Data Encryption, Encrypting File System, and Extensible Key Management.
Managing High Availability
This course describes how high availability ensures that your application is always available. High availability incorporates such technologies as clustering, mirroring, log shipping, and replication.
Managing Replication
This course covers various replication technologies. This course discusses copying and distributing data between databases and then synchronizing them to maintain consistency and integrity.
Managing Security
This course covers all aspects of managing security for Microsoft SQL Server 2008.
Monitoring and Troubleshooting
This course covers the tools and techniques you can use to monitor SQL Server and troubleshoot any problems that arise.
New Features in SQL Server 2008
This course covers the new features in SQL Server 2008. There are quite a few enhancements to SQL Server, many of which will make the job of the DBA much easier. One of these, the new performance data management system, allows for database statistics and
Performance Tuning
This course covers troubleshooting and performance tuning tools and processes you can use with SQL Server 2008 implementations.
Practice Exam 1
This course presents questions that will help you prepare for the Microsoft SQL Server 2008 Maintenance MCTS 70-432 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to l
Practice Exam 2
This course presents questions that will help you prepare for the Microsoft SQL Server 2008 Maintenance MCTS 70-432 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to l
Practice Exam 3
This course presents questions that will help you prepare for the Microsoft SQL Server 2008 Maintenance MCTS 70-432 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to l
Practice Exam 4
This course presents questions that will help you prepare for the Microsoft SQL Server 2008 Maintenance MCTS 70-432 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to l
Service Broker
This course covers what SERVICE BROKER is, how to set it up, and how to test to be sure it's functioning. This course also discusses message queuing with SQL Server.
SQL Server XML Support
This course covers ways that SQL Server 2008 supports XML. It also discusses the use of HTTP endpoints and Web services.
Certification:
Microsoft SQL Server 2008 Maintenance MCTS 70-432
Audience:
This series is for anyone who wants to achieve MCTS 70-432 certification.
Features:
What You Get:
You will receive Unlimited Access to all of the Microsoft SQL Server 2008 Maintenance MCTS 70-432 training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.
Web-Based Training Products:
You might also be interested in our Microsoft Certifications Package which includes all of the Microsoft SQL Server 2008 Maintenance MCTS 70-432 training courses listed above plus hundreds of hours of related online training courses