Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
SQL Server 2008 R2: Database Monitoring and Performance $74.95
SQL Server 2008 R2: Backups, Restores, and Database Snapshots $74.95
SQL Server 2008 R2: High Availability $74.95
SQL Server 2008 R2: Creating and Implementing Database Objects $74.95
SQL Server 2008 R2: Creating and Altering Partitions $74.95

Bundle Price: $199.00
Total Savings: $175.75


SQL Server 2008 R2: Database Monitoring and Performance

To keep SQL Server 2008 R2 databases running as efficiently as possible, administrators use a variety of performance tuning and monitoring tools. The SQL Server Profiler enables administrators to use trace files and logs to analyze a database's performance. They can also use the Windows System Monitor to monitor SQL Server 2008 R2 using counters, which monitor specific aspects of the server for performance issues. SQL Server 2008 R2 includes the Activity Monitor, which provides an overview of the system's performance in real-time. And the Database Engine Tuning Advisor enables administrators to analyze a database's workload and then implement recommendations to provide better performance for the database. SQL Server 2008 R2 provides a Resource Monitor, which allocates specific resources, and a data collector, which collects specific data and stores it in a management data warehouse. In SQL Server 2008 R2, concurrency issues may arise that require the administrator to intervene by detecting the locking issue and possibly terminating a process that could be blocking a session from performing its task. Concurrency issues can arise when multiple users are trying to access the same data in a database. This course demonstrates how to use SQL Server Profiler, the Database Engine Tuning Advisor, Resource Monitor, and the data collector to monitor and tune the performance of the database. It also addresses how to use the Windows System Monitor, Activity Monitor, and how to detect and resolve locks. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
  • recognize how to create a trace in SQL Server Profiler
  • recognize how to replay a trace in SQL Server Profiler
  • recognize how the Database Engine Tuning Advisor functions
  • recognize how to use the Database Engine Tuning Advisor to tune a SQL Server 2008 R2 database
  • describe the purpose of SQL Server Utility
  • use SQL Server Utility
  • recognize the features of Resource Governor
  • recognize how to use Resource Governor to manage resource allocation
  • recognize the features of the Data Collector
  • recognize how to use Data Collectors to collect SQL Server information
  • recognize how to configure System Monitor to monitor SQL Server 2008 R2 performance
  • recognize how locking is used to secure data integrity in a SQL Server 2008 R2 database
  • recognize how to track a deadlock
  • recognize how to resolve a blocked process
  • use SQL Server’s monitoring and diagnostic tools to optimize database performance

SQL Server 2008 R2: Backups, Restores, and Database Snapshots

Enterprises use databases to store their most critical data. To protect and ensure the data's availability, database administrators need to establish a solid backup and restoration plan. Such plans are used to protect data in the event of a disaster by allowing complete sets of duplicate data to be restored in a timely fashion. There are multiple types of backups that can be taken to ensure the recovery of data, including a full recovery or a point-in-time recovery. SQL Server 2008 R2 also offers database snapshots, which can be used to revert a database to a specific point when the snapshot was taken. This helps to store historical data and provides protection against administrative errors. This course demonstrates how to perform backup and recovery operations, as well as how to create database snapshots and revert to a database snapshot. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
  • match the recovery models to their characteristics
  • identify the considerations for a backup and restore strategy
  • recognize how to perform a database backup
  • recognize how the restore process works
  • recognize how to restore a SQL Server backup
  • recognize the characteristics of a database snapshot
  • recognize how to configure a database snapshot
  • backup a database
  • restore a database

SQL Server 2008 R2: High Availability

SQL Server 2008 R2 provides several key features that improve the availability of servers and databases so that downtime for users is minimized. These solutions include database mirroring, log shipping, replication, and failover clusters. These reliability features help administrators maintain multiple sets of data that help ensure that critical systems remain accessible, and can be fully recovered in the event of a disaster. This course addresses how to configure database mirroring, log shipping, replication, and failover clusters to ensure that SQL Server 2008 R2 environments are available to users at all times by providing a high-availability and complete disaster-recovery solution. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
  • identify the features of database mirroring
  • recognize the functionality of database mirroring
  • identify the requirements and recommendations for setting up a new database mirroring session with SQL Server 2008 R2
  • recognize how to configure database mirroring
  • identify the features of log shipping
  • recognize how to configure log shipping
  • recognize how to monitor log shipping
  • identify the features of data replication in SQL Server
  • recognize how to configure data replication
  • recognize the factors that affect data replication performance in SQL Server
  • recognize how to manage data replication in SQL Server 2008 R2
  • configure and monitor database mirroring in a given scenario
  • configure log shipping in a given scenario
  • configure data replication in a given scenario
  • identify factors to consider when implementing failover clustering
  • recognize how to implement a failover cluster

SQL Server 2008 R2: Creating and Implementing Database Objects

SQL Server 2008 R2 is a robust database system that provides a number of database objects used to store and view data. In order to configure a SQL Server 2008 R2 database to meet business requirements, administrators and developers must fully understand how to design, create, and configure these database objects. These objects include tables for storing data in the database, views to allow access to the data within specific tables, and indexes to optimize the performance of the database for data retrieval. This course identifies each of these database objects and demonstrates the steps required to administer them within the SQL Server 2008 R2 Management Studio tool. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
  • recognize how to define data types and column types
  • recognize how to create and alter tables
  • recognize the function of views, and how to create and modify them
  • recognize how to secure objects and document the structure of a database
  • recognize index types and how to design a database indexing strategy
  • recognize how to create and manage indexes
  • create and modify a table
  • create a view
  • grant permissions to a user
  • create an index

SQL Server 2008 R2: Creating and Altering Partitions

SQL Server 2008 R2 offers the use of partitions to manage subsets of data for large tables and indexes. Partitions can be used to improve the read/write performance on tables within a database by allowing the data within tables to be spread across multiple filegroups, whereas standard tables must be contained within a single filegroup. Data that is stored within partitions is treated as a logical entity, and the partitioned tables and indexes support the same properties as a standard table. SQL Server 2008 R2 allows views to be partitioned, which joins data from multiple tables from one or more servers. The data is returned as one set of information, making it appear as if it were from one table within one database. When partitioned views are used to access multiple tables from various servers they are known as distributed partitioned views. These are used to gather data from independent servers or a federation of servers. This course demonstrates how to create and manage such partitioned tables and indexes, and distributed partitioned views. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
  • recognize how to create table and index partitions
  • recognize how to modify table and index partitions
  • recognize how to create and use distributed partitioned views
  • create a partitioned table
  • create a partitioned index
  • modify a partitioned table
  • create a partitioned view
Register Now
Microsoft SQL Server 2008 R2: Part 2 e-learning bundle
  • Course ID:
    252797
  • Duration:
    9 hours
  • Price:
    $199