NetApp Protecting SQL Server Training in Canada

  • Learn via: Classroom
  • Duration: 2 Days
  • Level: Intermediate
  • Price: From €2,333+VAT
We can host this training at your preferred location. Contact us!

This course covers the deployment of the SnapCenter Plug-in for Microsoft SQL Server. In this course, you learn about the features of the plug-in and how to install and perform initial configuration of the plug-in. You learn how to protect, clone, and restore Microsoft SQL Server databases by using SnapCenter software. Through instructor-led presentations, you gain knowledge about these topics. Hands-on exercises provide you with experience in performing these tasks.

Audience

  • NetApp and NetApp Partner Professional Services
  • Systems Engineers
  • NetApp Customers

The following 5 day instructor led class is required..

OT-CLU-DPA - ONTAP Cluster Administration & Data Protection

In addition to the following 3 day instructor led class..

SNAP-C-ADM - NetApp SnapCenter Administration

The SnapCenter Fundamentals free of charge elearning is also required which can be accessed directly from the NetApp Learning Centre. Please contact us for further help as required

  • Describe the features of the Microsoft SQL Server Plug-in
  • List the workflow for using SnapCenter software to protect Microsoft SQL Server databases
  • Explain how SnapCenter software uses NetApp technology to protect SQL Server databases
  • Illustrate the recommended NetApp storage layouts to support SQL Server data
  • Describe data protection strategies for SQL Server databases by using SnapCenter software
  • Demonstrate how to configure and perform SQL Server database backups by using SnapCenter software
  • Demonstrate SQL Server database restores that use SnapCenter software
  • Describe cloning strategies that use SnapCenter software and NetApp technology
  • Build alerting and reporting operations for Plug-in for SQL Server

Module 1: SnapCenter Plug-In for Microsoft SQL Server Overview

  • Features

  • MS SQL server data protection workflow

Module 2: Getting Started with the SnapCenter Plug-In for MS SQL Server

  • Prerequisite tasks for using the Plug-In
  • Installation steps for the Plug-in
  • Plug-in configuration
  • Storage layout recommendations and restrictions
  • Storage design for a virtualized environment

Module 3: Data Migration

  • Resource wizard
  • Importing from SnapManager software

Module 4: Creating and Backing up SQL Server Resources

  • Data protection strategy
  • Backing up SQL server databases

Module 5: Restoring SQL Server Resources

  • Defining a restore strategy
  • Restoring SQL server databases

Module 6: Cloning SQL Server Databases

  • Defining a cloning strategy
  • Cloning a SQL server database backup
  • Splitting a SQL server cloned database
  • Clone lifecycle management

Module 7: Monitoring and Managing SQL Server Operations

  • Monitoring operations
  • Canceling a database backup operation
  • Monitoring and managing a thin-provisioned environment
  • Setting thresholds, alerts and reports

Labs:

  • Configuring SnapCenter and install plug-ins for MS SQL Server
  • Migrating databases
  • Protecting a MS SQL server database
  • Restoring a MS SQL server database
  • Cloning a MS SQL server database
  • Performing management and monitoring tasks by using SnapCenter software and NetApp ONTAP system manager

Appendix A - Challenge labs:

  • Migrating a database from existing volume to a new volume
  • Configuring backup and replication for the newly migrated database
  • Configuring a clone lifecycle for the development team
  • Performing a point-in-time restore to remove database corruption


Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Canada facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
02 July 2024
Toronto, Montreal, Calgary
2 Days
Classroom / Virtual Classroom
07 August 2024
Toronto, Montreal, Calgary
2 Days
Classroom / Virtual Classroom
19 August 2024
Toronto, Montreal, Calgary
€2,333 +VAT Book Now
Classroom / Virtual Classroom
26 August 2024
Toronto, Montreal, Calgary
2 Days
Classroom / Virtual Classroom
10 September 2024
Toronto, Montreal, Calgary
2 Days
Classroom / Virtual Classroom
10 September 2024
Toronto, Montreal, Calgary
2 Days
Classroom / Virtual Classroom
27 September 2024
Toronto, Montreal, Calgary
2 Days
Classroom / Virtual Classroom
07 October 2024
Toronto, Montreal, Calgary
€2,333 +VAT Book Now
NetApp Protecting SQL Server Training Course in Canada

Canada is a North American country. Known as the second-largest country of the world, Canada’s capital city is Ottawa. Toronto, Vancouver and Montreal are the biggest and most popular cities of this country. The 8,891-kilometer southern and western border between Canada and the United States is the world's longest intergovernmental land border. This country also has the longest coastline in the world.

Canada is a constitutional monarchy. The country was originally a British Empire colony and is now a part of the British Commonwealth. Both French and English are Canada’s official languages. Canada’s national animal is a beaver and the its flag design is a vertical triband of red and white with a red maple leaf charged in the centre. Some of the top-rated tourist attractions in Canada are Niagara Falls, Banff National Park and Rocky Mountains, CN Tower in Toronto City, Bay of Fundy, Old Quebec (Vieux-Quebec in French), the ski resort of Whistler, Ottawa's Parliament Hill and Vancouver Island.

Choose from our extensive selection of IT courses, covering programming, data analytics, software development, business skills, cloud computing, cybersecurity, project management. Our highly skilled instructors will deliver hands-on training and valuable insights at a location of your choice within Canada.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.