Microsoft SQL Server 2008 Maintenance MCTS 70-432: 1 New Features in SQL Server 2008
Description
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.
Objectives
- Describe the new features in SQL Server 2008
- List Reporting Services enhancements
Microsoft SQL Server 2008 Maintenance MCTS 70-432: 2 Installing SQL Server 2008
Description
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.
Objectives
- List SQL versions, requirements, features, and differences
- Plan your installation
- Compare upgrading vs. side-by-side installation options
- Describe the relationships between database instances, files, locations, Filegroups, and performance
Microsoft SQL Server 2008 Maintenance MCTS 70-432: 3 Configuring SQL Server 2008
Description
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.
Objectives
- 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
- Manage Full-Text Indexing
Microsoft SQL Server 2008 Maintenance MCTS 70-432: 4 Managing Security
Description
This course covers all aspects of managing security for Microsoft SQL Server 2008.
Objectives
- This course covers all aspects of managing security for Microsoft SQL Server 2008.
- 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
- Select account types to use with services
Microsoft SQL Server 2008 Maintenance MCTS 70-432: 5 Managing Data Encryption
Description
This course covers using encryption in SQL Server 2008. This includes using Transparent Data Encryption, Encrypting File System, and Extensible Key Management.
Objectives
- This course covers using encryption in SQL Server 2008. This includes using Transparent Data Encryption, Encrypting File System, and Extensible Key Management.
- Use Transparent Data Encryption
- Explain the use of encrytion keys
- Describe methods of cell- and column-level encryption
Microsoft SQL Server 2008 Maintenance MCTS 70-432: 6 Managing High Availability
Description
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.
Objectives
- 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.
- Define High Availability
- Describe SQL High-Availability options
- Describe SQL Server options for expandability
Microsoft SQL Server 2008 Maintenance MCTS 70-432: 7 Maintaining Your Database
Description
This course covers the SQL Server features you use to perform ongoing maintenance tasks to keep your databases functioning well.
Objectives
- This course covers the SQL Server features you use to perform ongoing maintenance tasks to keep your databases functioning well.
- Explain Data Collation
- Maintain data files
- Back up and restore data
- Perform ongoing maintenance
- Collect performance data
Microsoft SQL Server 2008 Maintenance MCTS 70-432: 8 ETL Techniques
Description
This course covers ways to extract, transform, and load data using SQL Server 2008. SQL Server provides many tools for your ETL needs.
Objectives
- This course covers ways to extract, transform, and load data using SQL Server 2008. SQL Server provides many tools for your ETL needs.
- Bulk copy data
- Use distributed queries
- Demonstrate SQL Server Integration Services
- Apply alternative ETL solutions
Microsoft SQL Server 2008 Maintenance MCTS 70-432: 9 Managing Replication
Description
This course covers various replication technologies. This course discusses copying and distributing data between databases and then synchronizing them to maintain consistency and integrity.
Objectives
- This course covers various replication technologies. This course discusses copying and distributing data between databases and then synchronizing them to maintain consistency and integrity.
- Describe replication scenarios, types, and configuration
- Assess conflict resolution
- Demonstrate DDL replication
- Describe security considerations
- Explain replication performance
- Describe Monitoring
Microsoft SQL Server 2008 Maintenance MCTS 70-432:10 Monitoring and Troubleshooting
Description
This course covers the tools and techniques you can use to monitor SQL Server and troubleshoot any problems that arise.
Objectives
- This course covers the tools and techniques you can use to monitor SQL Server and troubleshoot any problems that arise.
- 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
- Monitor system performance
Microsoft SQL Server 2008 Maintenance MCTS 70-432:11 SQL Server XML Support
Description
This course covers ways that SQL Server 2008 supports XML. It also discusses the use of HTTP endpoints and Web services.
Objectives
- This course covers ways that SQL Server 2008 supports XML. It also discusses the use of HTTP endpoints and Web services.
- Work with XML data
- Apply HTTP endpoints
- Explain how Web services are used
- Describe the uses of XQuery and XPath
Microsoft SQL Server 2008 Maintenance MCTS 70-432:12 Service Broker
Description
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.
Objectives
- 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.
- Explain the Queuing Concept
- Define SERVICE BROKER
- Describe Message Types, Contracts, Queues, Services, and Routes
- Send a Message
Microsoft SQL Server 2008 Maintenance MCTS 70-432:13 Performance Tuning
Description
This course covers troubleshooting and performance tuning tools and processes you can use with SQL Server 2008 implementations.
Objectives
- This course covers troubleshooting and performance tuning tools and processes you can use with SQL Server 2008 implementations.
- 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
- Manage resource allocation with the Resource Governor
Microsoft SQL Server 2008 Maintenance MCTS 70-432:14 Implementing Objects
Description
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.
Objectives
- 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.
- Describe DDL and DML Language Elements
- Work with Tables, Indexes, and Constraints
- View and Modify Data
Microsoft SQL Server 2008 Maintenance MCTS 70-432:15 Practice Exam 1
Description
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.
Objectives
- Complete the practice exam questions
Microsoft SQL Server 2008 Maintenance MCTS 70-432:16 Practice Exam 2
Description
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.
Objectives
- Complete the practice exam questions
Microsoft SQL Server 2008 Maintenance MCTS 70-432:17 Practice Exam 3
Description
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.
Objectives
- Complete the practice exam questions
Microsoft SQL Server 2008 Maintenance MCTS 70-432:18 Practice Exam 4
Description
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.
Objectives
- Complete the practice exam questions
Before you order a single course, check out our Value Pack Deals!
Prices shown are per person. For group orders Click Here.