Font size:

Description:

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

Course Price
Microsoft SQL Server 2012: Backing Up and Restoring Databases $74.95
Microsoft SQL Server 2012: Managing Indexes, Full-Text Search and Partitions $74.95
Microsoft SQL Server 2012: Database Monitoring and Performance Tuning $74.95
Microsoft SQL Server 2012: Configuring High Availability $74.95

Bundle Price: $169.00
Total Savings: $130.80


Microsoft SQL Server 2012: Backing Up and Restoring Databases

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 data can be recovered, including to the point of failure or a point-in-time recovery. This course demonstrates how to perform backup and recovery operations.This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.
  • determine the most appropriate recovery model for a given scenario
  • choose a logical backup device
  • match the different kinds of backups to their descriptions
  • recognize how to create a database backup
  • describe the consideration involved in planning to restore a database
  • recognize how to restore a database for a given scenario
  • determine when to use particular backup types
  • determine which recovery models and backup types should be used in a given scenario
  • create database backups
  • use SQL Server 2012 restore features

Microsoft SQL Server 2012: Managing Indexes, Full-Text Search and Partitions

SQL Server 2012 provides features to allow administrators to ensure that data is accessed efficiently, this includes the use of indexes, table and index partitions, and full-text search. Indexes in SQL Server 2012 database allow data to be accessed quickly using keys that are stored in a B-tree structure. Indexes need to be created and managed to ensure for the best database performance. SQL Server 2008 provides table and index partitioning to allow data to be stored across multiple filegroups within a database. This makes tables and indexes that contain large amounts of data more manageable. Partitions in the database may need to be split to allow for more data to be stored, or data from one partition may need to be moved to another partition. SQL Server's full-text search component can be implemented to ensure that specific data is returned based on search words and phrases. This course demonstrations how to create and manage indexes, table and index partitions, and how to configure and use the full-text search component in SQL Server 2012. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.
  • match the indexes that can be used in SQL Server 2012 to their descriptions
  • recognize the considerations associated with creating different types of indexes
  • recognize the options available for managing indexes
  • perform index maintenance
  • describe the characteristics of indexes in SQL Server 2012
  • manage and maintain indexes
  • recognize the steps for enabling full-text search
  • implement full-text search in SQL Server 2012
  • describe the features of partitioning in SQL Server 2012
  • recognize how to manage partitioning in SQL Server 2012
  • use full-text search in SQL Server 2012
  • recognize how to employ partitioning in SQL Server 2012

Microsoft SQL Server 2012: Database Monitoring and Performance Tuning

To keep SQL Server 2012 databases running as efficiently as possible, there are a variety of performance tuning and monitoring tools. The SQL Server Profiler enables you to use trace files and logs to analyze a database's performance. You can also use the Windows System Monitor to monitor SQL Server 2012 using counters, which monitor specific aspects of the server for performance issues. SQL Server 2012 includes the Activity Monitor, which provides an overview of the system's performance in real-time. SQL Server 2012 provides a the Resource Governor, which allocates specific resources to specific sessions, and a data collector, which collects specific data and stores it in a management data warehouse. Extended Events can be used to monitor performance information based on events that occur in the instance using sessions. In SQL Server 2012, concurrency issues may arise that require you 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, System Monitor, Activity Monitor, Extended Events, and the data collector to monitor and tune the performance of the database. It also addresses how to detect and resolve locks. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.
  • describe the importance of database monitoring
  • recognize how SQL Server Profiler is used to monitor a database
  • describe the characteristics of SQL Server 2012's performance monitoring tools
  • create an Extended Event session using the CREATE EVENT SESSION statement
  • configure the management data warehouse to support data storage on instances of SQL Server that are using the data collector
  • recognize how Resource Governor is used to manage resources
  • monitor databases
  • access data to solve a server issues
  • describe how to manage SQL Server workload using Resource Governor
  • recognize how locking is used to secure data integrity in a SQL Server 2012 database
  • describe how to minimize deadlocks
  • manage deadlocks
  • describe how locking is used in a SQL Server 2012 database
  • use the features of SQL Server 2012 to manage and resolve deadlocks

Microsoft SQL Server 2012: Configuring High Availability

SQL Server 2012 provides several key features that improve the availability of servers and databases so that downtime for users is minimized. These solutions include AlwaysOn Failover Clustering, AlwaysOn Availability Groups, database mirroring, and Replication. 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 SQL Server 2012's AlwaysOn features, database mirroring, and replication to ensure that SQL Server 20012 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 the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.
  • match the high availability solutions to their descriptions
  • describe the considerations involved in installing SQL Server AlwaysOn Failover Clustering
  • match the steps in the failover process with appropriate examples
  • describe the considerations involved in implementing AlwaysOn Availability Groups
  • implement AlwaysOn Availability Groups
  • prepare for database mirroring
  • describe how to set up database mirroring
  • describe how to monitor database mirroring sessions
  • describe the options when setting up replication
  • match the subscription types to their description
  • determine the most appropriate high availability solution for a given scenario
  • recognize the considerations involved in implementing AlwaysOn Availability Groups and SQL Server Failover Clustering
  • implement database mirroring
  • recognize how to distribute data and database objects using replication
Register Now
Microsoft SQL Server 2012: Database Administration Part 2 e-learning bundle
  • Course ID:
    252789
  • Duration:
    8 hours
  • Price:
    $169