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