HPE NonStop SQL/MP Database Management (U4180S)

 

Course Overview

This course introduces the tasks and tools used by a database administrator or system manager who is responsible for the daily management and protection of HPE NonStop SQL/MP database, programs that access the database, and other associated database elements. Hands-on labs give you practical experience in performing management tasks against a database with applications.

Who should attend

  • Database administrators •System managers •People responsible for availability of HPE NonStop SQL/MP databases and applications

Prerequisites

  • Concepts and Facilities course
  • NonStop SQL/MP Essentials course
  • Solid understanding of systems, application areas, and daily operations for both systems and applications
  • Understanding of the database environment at your business

Course Objectives

Benefits to you:
  • Review of the HPE NonStop SQL/MP environment
  • SQL/MP installation and version management
  • Creating SQL/MP database base objects
  • Loading, copying, appending, and reorganizing data
  • DataLoader/MP •Updating SQL/MP statistics
  • Managing SQL/MP embedded programs
  • Altering SQL/MP database objects
  • Moving SQL/MP database objects
  • Removing SQL/MP database objects
  • Managing database protection and recovery using NonStop Transaction Manager/MP (TM/MP)
  • Backing up and restoring SQL/MP database objects
  • Database security management
  • Tools for monitoring performance
  • Enhancing DP2 performance
  • Managing sorts
  • Controlling SQL/MP processes

Prix & Delivery methods

Formation en ligne

Durée
5 jours

Prix
  • CHF 4 500,–
Formation en salle équipée

Durée
5 jours

Prix
  • Suisse : CHF 4 500,–

Actuellement aucune session planifiée