On this page

Share this page

HP NonStop SQL/MP database management

Course information
Price: £2,200.00 exc. VAT
Day(s): 5
Course Code: U4180S

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 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.

Pre-Requisites

  • 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

Objectives

  • Review of the 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

Target Audience

This course is suitable for Database administrators, System managers and people responsible for availability of NonStop SQL/MP databases and applications.

Follow on Courses

  • NonStop SQL/MP Query Design for Performance course.

Schedule

Dates available on request. Please contact us.

This item has been added to your basket