Microsoft SQL Server 2008 Maintenance MCTS 70-432 - Online Course

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 Maintenance certification. This series will cover all aspects of running SQL Server 2008, including installing, maintaining, managing security, monitoring, troubleshooting, and optimizing performance. Practice exams will allow you to answer questions in the same format that the test will use on exam day, and will provide in-depth instructional feedback on each question to thoroughly cover every subject you'll need to master.

This series is for anyone who wants to achieve MCTS 70-432 certification. This online course contains 14 lessons and 4 practice exams and should take approximately 29 hours to complete.

Lesson 1: New Features in SQL Server 2008 (1.0) hour

New Features in SQL Server 2008 teaches you how to describe the new features in SQL Server 2008, and list Reporting Services enhancements. 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 information to be automatically captured across an enterprise. Topics include New Features in SQL Server 2008.

Lesson 2: Installing SQL Server 2008 (2.0) hours

Installing SQL Server 2008 teaches you how to list SQL versions, requirements, features, and differences, plan your installation, compare upgrading vs. side-by-side installation options, and describe the relationships between database instances, files, locations, Filegroups, and performance. 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 discussed. Topics include Installing SQL Server 2008.

Lesson 3: Configuring SQL Server 2008 (2.0) hours

Configuring SQL Server 2008 teaches you how to differentiate default and named instances, manage connection protocols and service accounts with SQL Server Configuration Manager, configure options with sp_configure and SQL Server Management Studio, setup and use Database Mail, and manage Full-Text Indexing. 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 as how to set up and use Database Mail and manage Full-Text Indexes. Topics include Configuring SQL Server 2008.

Lesson 4: Managing Security (1.0) hour

Managing Security teaches you how to define what SQL Server considers a principal, describe the roles into which logins and users can be added, select an appropriate authentication mode, configure auditing, manage features using the SQL Server Configuration Manager, and select account types to use with services. This course covers all aspects of managing security for Microsoft SQL Server 2008. Topics include Managing Security.

Lesson 5: Managing Data Encryption (1.0) hour

Managing Data Encryption teaches you how to use Transparent Data Encryption, explain the use of encrytion keys, and describe methods of cell- and column-level encryption. This course covers using encryption in SQL Server 2008. This includes using Transparent Data Encryption, Encrypting File System, and Extensible Key Management. Topics include Managing Data Encryption.

Lesson 6: Managing High Availability (2.0) hours

Managing High Availability teaches you how to define High Availability, describe SQL High-Availability options, and describe SQL Server options for expandability. 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. Topics include Managing High Availability.

Lesson 7: Maintaining Your Database (3.0) hours

Maintaining Your Database teaches you how to explain Data Collation, maintain data files, back up and restore data, perform ongoing maintenance, and collect performance data. This course covers the SQL Server features you use to perform ongoing maintenance tasks to keep your databases functioning well. Topics include Maintaining Your Database.

Lesson 8: ETL Techniques (3.0) hours

ETL Techniques teaches you how to bulk copy data, use distributed queries, demonstrate SQL Server Integration Services, and apply alternative ETL solutions. This course covers ways to extract, transform, and load data using SQL Server 2008. SQL Server provides many tools for your ETL needs. Topics include ETL Techniques.

Lesson 9: Managing Replication (2.0) hours

Managing Replication teaches you how to describe replication scenarios, types, and configuration, assess conflict resolution, demonstrate DDL replication, describe security considerations, explain replication performance, and describe Monitoring. This course covers various replication technologies. This course discusses copying and distributing data between databases and then synchronizing them to maintain consistency and integrity. Topics include Managing Replication.

Lesson 10: Monitoring and Troubleshooting (1.0) hour

Monitoring and Troubleshooting teaches you how to troubleshoot when issues arise with the server, resolve concurrency issues, manage issues with SQL Server Agent, access error logs, view commands using SQL Server Profiler, and monitor system performance. This course covers the tools and techniques you can use to monitor SQL Server and troubleshoot any problems that arise. Topics include Monitoring and Troubleshooting.

Lesson 11: SQL Server XML Support (1.0) hour

SQL Server XML Support teaches you how to work with XML data, apply HTTP endpoints, explain how Web services are used, and describe the uses of XQuery and XPath. This course covers ways that SQL Server 2008 supports XML. It also discusses the use of HTTP endpoints and Web services. Topics include SQL Server XML Support.

Lesson 12: Service Broker (2.0) hours

Service Broker teaches you how to explain the Queuing Concept, define SERVICE BROKER, describe Message Types, Contracts, Queues, Services, and Routes, and send a Message. 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. Topics include Service Broker.

Lesson 13: Performance Tuning (2.0) hours

Performance Tuning teaches you how to capture trace data, manage locks, blocking, and deadlocks, view SQL Server internals with Dynamic Management Functions, partition tables, collect performance data in the Management Data Warehouse, and manage resource allocation with the Resource Governor. This course covers troubleshooting and performance tuning tools and processes you can use with SQL Server 2008 implementations. Topics include Performance Tuning.

Lesson 14: Implementing Objects (2.0) hours

Implementing Objects teaches you how to describe DDL and DML Language Elements, work with Tables, Indexes, and Constraints, and view and Modify Data. 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. Topics include Implementing Objects.

4 Practice Exams

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 look for in correct answers.