Nutanix Database Management & Automation (NDMA)

If you’re ready to move beyond manual database administration and start steering the automation of a modern, hybrid multicloud database environment, you’ve come to the right place. This course is designed specifically for Database Platform Engineers who want to master the intricacies of the Nutanix Database Service (NDB).

Note: The installation and management of databases themselves is not part of this course.

Course Objectives

By the end of this course, you will be able to:

• Provision and register databases and database server VMs.
• Create, manage, and customize new NDB profiles.
• Protect, clone, and recover databases using Time Machine and snapshots.
• Patch operating systems and database engines seamlessly.
• Manage advanced topologies including High Availability, Multicluster,
• Nutanix Objects, and NC2 environments.
• Troubleshoot NDB and database health.

Audience

• Database administrators who manage Nutanix clusters and want a detailed deep dive into database administration using NDB
• Anyone pursuing the Nutanix Certified Professional – Database Automation (NCP-DB) certification

Prerequisites

This advanced course requires you to possess a basic Nutanix system administration skill set which includes:

• Familiarity with traditional virtualization architectures and Nutanix cloud infrastructure
• Hands-on experience with the Prism interface
• An understanding of Nutanix core concepts and definitions, which can be found here
• Completion of Enterprise Cloud Administration or at least 6 months of on-the-job experience working on a Nutanix system

Course Outline

Module 1: Introduction

• NDB Overview
• Key Concepts
• Use Cases

Module 2: Deploying NDB

• Logging into NDB for the First Time
• Configuring an NDB Instance
• Exploring the NDB Interface

Module 3: Securing NDB

• Configuring an SSL Certificate
• RBAC in NDB
• User Account Management
• Configuring Local and Active Directory Users
• Creating and Assigning Custom Roles

Module 4: Managing Profiles in NDB

• Understanding NDB Profiles and Reviewing Built-in Profiles
• Creating Custom Profiles for SQL Server (Software, Compute,
• Network, Database Parameters, Windows Domain)

Module 5: Provisioning and Registering Databases in NDB

• Provisioning vs. Registering Databases
• Provisioning a New SQL Server Instance
• Registering an Existing SQL Server Instance

Module 6: NDB High Availability

• Introduction to HA
• Three-Cluster NDB HA Topology
• Enabling HA
• HA Service Resiliency

Module 7: NDB Multicluster

• Understanding NDB Multicluster
• Enabling NDB Multicluster
• Provisioning a HA SQL Server Database

Module 8: NDB and Nutanix Objects

• Registering and Provisioning a Nutanix Object Store with NDB
• Enabling Certificate Verification for a Nutanix Object Store
• Provisioning and Registering Databases That Use Objects

Module 9: NDB on NC2

• NDB with Flow Virtual Networking
• NDB in NC2 – Azure (Deployment and Database Provisioning)
• NDB in NC2 – AWS (Deployment and Database Provisioning)

Module 10: Time Machine and Point-in-Time Recovery

• Understanding Time Machine and Creating SLAs
• Cloning Databases and Refreshing Clones (Manually and via Schedule)
• Creating, Replicating, and Restoring a Database from a Snapshot

Module 11: Patching Databases

• Understanding Patching Operations in NDB
• Patching a SQL Server Database
• Configuring Automatic Patching

Module 12: Troubleshooting NDB

• Working with Alerts and the Operations Page
• Generating and Downloading a Diagnostics Bundle
• Common NDB Issues and Resolutions