Trending Courses

Principals

Skip Navigation Links

Overview

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.
img-course-overview.jpg

What You'll Learn

In this course, you will learn the following:

  • 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

Who Should Attend

  • NetApp and NetApp Partner Professional Services
  • Systems Engineers
  • NetApp Customers
img-who-should-learn.png

Prerequisites

  • ONTAP Cluster Administration (ONTAP9ADM) ONTAP Data Protection Administration (DATAPROT9) or
  • ONTAP Cluster Administration and Data Protection Bundle(CDOTDP9)
  • SnapCenter Fundamentals WBT
  • SnapCenter Administration (SCADMIN)

Learning Journey

Coming Soon...

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

Instructors

Scott Duffy

Bestselling Azure & TOGAF® Trainer, Microsoft Azure MVP

4.8 (4.1k)
|
10 Courses
profile-instructor-a.png
Scott Duffy

Bestselling Azure & TOGAF® Trainer, Microsoft Azure MVP

4.8 (4.1k)
|
10 Courses
profile-instructor-a.png

Frequently Asked Questions (FAQs)

  • Why get NetApp certified?

    NetApp certifications validate your expertise in data storage, management, and cloud solutions, making you a sought-after professional in the IT industry.

    These credentials demonstrate your ability to design, implement, and manage NetApp technologies, ensuring efficient and secure data infrastructure.

    NetApp-certified professionals are highly valued for their skills in maximizing data availability, performance, and security, making them valuable assets to any organization.

  • What to expect for the examination?

    NetApp offers a variety of certification exams across different levels (Associate, Professional, Specialist, Expert) and technology areas.

    Exams typically consist of multiple-choice and scenario-based questions that assess your knowledge and ability to apply it in real-world scenarios.

    Note: Certification requirements and policies may be updated by NetApp from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • How long is NetApp certification valid for?

    NetApp certifications are valid for two years from the date of passing the exam. To maintain your certification, you will need to recertify before it expires.

    Recertification options include passing the current version of the same exam, passing a higher-level exam within the same track, or earning a specialist certification that is linked to your current certification.

    Note: Certification requirements and policies may be updated by NetApp from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • Why take this course with Trainocate?

    Here’s what sets us apart:

    - Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 16 countries (and counting!).

    - Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.

    - Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.

    - Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.

    - Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.

    - Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

Frequently Asked Questions

img-improve-career.jpg

Improve yourself and your career by taking this course.

More Courses By NetApp

Browse All Courses
sanadm-ontap-san-administration-v9
SAN

ONTAP SAN Administration v9.8

This course helps you learn about configuring ONTAP 9 Data Management Software for a SAN environment. The course provides information about block-level protocols, FC, FCoE, and iSCSI on Microsoft
ILT VILT
Course Duration 2 Days
sanimp-ontap-san-implementation-training
SAN

ONTAP SAN Implementation

In this workshop, you learn how to connect Windows® and Linux® hosts to NetApp® SANs via FC and iSCSI protocols.
ILT VILT
Course Duration 3 Days
dataprot9-ontap-data-protection-administration-9
Data Protection

ONTAP Data Protection Administration 9.14

This course describes some of the key concepts and techniques for protecting data in NetApp ONTAP system.
ILT VILT
Course Duration 2 Days
img-get-info.jpg

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name
Email
Phone
I'm inquiring for
Inquiry Details

By providing your contact details, you agree to our Privacy Policy.

Stay Connected. Be the first to Know.

Company

Principals

Services

Customer Service

© Copyright Trainocate 2024. All rights reserved.