Nutanix Database Management and Automation (NDMA) (NDMA)

This course teaches you the skills needed to install, configure, and operate Nutanix Database Service (NDB, formerly known as Nutanix Era) for the purpose of managing databases.


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


In this course, you will explore a number of subjects including:

  • The what, the how, the why, and the benefits of database-as-a-service (DBaaS)
  • Important NDB terms and concepts, like copy data management, time machine, provisioning profiles and data access management
  • Implementing role-based access control (RBAC), including working with built-in and custom roles, and managing users and groups
  • Adding multiple clusters to NDB, working with Nutanix Guest Tools, and registering a Nutanix cluster with NDB
  • Monitoring and investigating issues with NDB, including alert policies, notifications, and log collection
  • Operations involved in protecting and restoring databases, including creating snapshots, cloning databases, log catch-up operations, refreshing clones, and restoring source databases


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


Prerequisities

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.

These skills can be acquired by attending our basic admin course (Enterprise Cloud Administration), or through on-the-job experience by working on a Nutanix system for at least 6 months.


Course Outline

1: Introduction to Database Automation

  • Understanding DBaaS
  • Understanding NBD Terminology and Concepts
  • The Nutanix Solution for DBaaS


2: Configuring and Operating NDB

  • Understanding the NDB Workflow
  • Installing and Configuring NDB
  • Exploring the NDB Dashboard
  • Creating Profiles
  • Registering an Existing Database
  • Provisioning a New Database
  • Patching, Upgrading, and Scaling Databases
  • Upgrading NDB
  • NDB High Availability

Hands-on Labs:

  • Deploying NDB
  • Configuring an NDB Instance
  • Getting Started with a PostgreSQL Database
  • Upgrading NDB
  • Working with NDB Profiles
  • Registering Existing Databases
  • Provisioning, Patching, and Removing Databases


3: Administering and Monitoring NDB

  • Implementing RBAC and Managing Users
  • Adding Nutanix Clusters to NDB
  • Working with Maintenance Windows
  • Using Tags for Database Inventory Management
  • Working with Alerts
  • Investigating Issues with NDB

Hands-on Labs:

  • Implementing RBAC and Managing Users
  • Using Tags for Database Inventory Management
  • Working with Alerts
  • Generating and Downloading a Diagnostics Bundle
  • Enabling NDB Multi-Cluster
  • Provisioning a Database to a New Cluster
  • Provisioning a Multi-Cluster HA Database


4: Protecting and Restoring Databases (Time Machine Operations)

  • Understanding Time Machine
  • Managing SLAs Schedules
  • Preparing for Snapshot Creation, Replication, and Deletion
  • Cloning Databases
  • Database Log Management
  • Refreshing and Removing Clones
  • Restoring Source Databases

Hands-on Labs:

  • Creating SLAs
  • Cloning Databases
  • Creating and Replicating Snapshots
  • Restoring a Database from a Snapshot