NonStop SQL/MP Database Management (U4180)

Course Description Schedule Course Outline
 

Course Overview

This 5-day course introduces the tasks and tools used by a database administrator or system manager who is responsible for the daily management and protection of a HP 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 HP NonStop SQL/MP databases & applications

Prerequisites

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

Course Objectives

  • Review of the HP NonStop SQL/MP environment
  • HP NonStop SQL/MP installation and version management
  • Creating HP NonStop 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 HP 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
Classroom Training
Modality: G

Duration 5 days

Price (excl. VAT)
  • United Kingdom: £ 2,200.-
Enroll now
Online Training
Modality: U

Duration 5 days

Price (excl. VAT)
  • United Kingdom: £ 2,200.-
Enroll now
 

Accessing our website tells us you are happy to receive all our cookies. However you can change your cookie settings at any time. Find out more.   Got it!