Module 1: HPE Nonstop SQL/MP Environment

• Processes, structure, and objects of the HPE Nonstop SQL/MP environment
• Locating the SQL/MP system catalog
• Determining the number and location of SQL/MP catalogs on a system
• Identifying and locating the objects registered in an SQL/MP database
• Related products and additional tables they can create in the SQL/MP system catalog
• Locate the system catalog
• Locate all user catalogs on a system
• Identify the objects in the PERSNL database and their dependent objects
• Identify what SQL/MP processes you have running for your session
• Create a user catalog

Lab

• HPE Nonstop SQL/MP Environment

Module 2: installation and Version Management

• Identifying the system requirements for HPE Nonstop SQL/MP
• Installation and initialization process of SQL/MP software
• Version management for SQL/MP objects
• Managing the migration of SQL/MP from one NonstopKernel operating system release to another Compatibility of SQL/MP software versions within a network)
• Identify the versions of HPE Nonstop SQL/MP, the catalog, and several objects on your system

Lab

• Installation and Version Management

Module 3: Creating HPE Nonstop SQL/MP Database Objects

• Planning and creating HPE Nonstop SQL/MP database objects
• Performance considerations and guidelines for creating SQL/MP database objects
• Query metadata for the SQL/MP objects that have been created

Lab

• Creating SQL/MP Database Objects

Module 4: Copying, Loading, Appending, Reorganizing, and Converting Data

• Converting an Enscribe database to a HPE Nonstop SQL/MP database
• Use the COPY utility to load, extract, or display data
• Using the LOAD or APPEND utilities to load data
• Re-organizing data in key-sequenced tables and indexes
• Archiving data from the database
• Checking the referential integrity of the database

Lab

• Using Copy, Load and Append Utilities
• Reorganizing Data
• Converting an Enscribe Database to an SQL/MP Database

Module 5: DataLoader/MP

Module 6: Updating HPE Nonstop SQL/MP Statistics

• Creating DataLoader/MP processes to load the data given a data loading scenario
• HPE Nonstop SQL/MP statistics
• Statistics for partitioned tables
• How the optimizer uses statistics to calculate selectivity for predicates
• How to update statistics
• When to update statistics
• Testing the impact of updating statistics in a test environment or the production environment
• Querying the catalog for statistical information
• Copying the production system statistics to the development system
• Statistics performance degradation

Lab

• Updating SQL/MP Statistics

Module 7: Managing Nonstop SQL/MP Embedded Programs

• Explicit compilation and automatic recompilation of HPE Nonstop SQL/MP programs
• SQL/MP program run-time environment
• Compiling COBOL and C embedded SQL programs in the Guardian and Open System Services (OSS) environments using native and non-native compilers
• SQL/MP compiler options
• Creating, implementing, and testing a compilation strategy for an SQL/MP program
• Determining what actions make an SQL/MP program invalid
• Detecting invalid SQL/MP programs
• Detecting auto-recompiling SQL/MP programs
• Plan and implement different compiler options using two scenarios

Lab

• Managing SQL/MP Embedded Programs

Module 8: Altering HPE Nonstop SQL/MP Database Objects

• Altering HPE Nonstop SQL/MP objects and the impact to the database environment
• Methods for partitioning tables and indexes
• SQL/MP Format 2 Enabled objects and Format 1 and Format 2 partitions

Lab

• Altering SQL/MP Database Objects

Module 9: Moving HPE Nonstop SQL/MP Database Objects

• Process for moving HPE Nonstop SQL/MP objects
• Methods to move SQL/MP objects (Re-create and Load, ALTER MOVE, DUP, Backup and Restore)

Lab

• Moving SQL/MP Database Objects
• Moving SQL/MP Embedded Programs

Module 10: Removing HPE Nonstop SQL/MP Database Objects

• Removing HPE Nonstop SQL/MP objects
• Removing objects using the DROP command and PURGE and CLEANUP utilities
• Removing data from a table or a partition of a table using PURGEDATA utility
• Dropping a partition of a table using ALTER TABLE … DROP PARTITION
• Dropping a partition of an index using ALTER INDEX … DROP PARTITION
• TACL GOAWAY command

Lab

• Removing SQL/MP Database Objects

Module 11: Managing Database Protection and Recovery

• HPE Nonstop Transaction Manager/MP (TM/MP) methods of protection and recovery
• TM/MP considerations for HPE Nonstop SQL/MP objects
• Protecting SQL/MP database with TM/MP
• Online dump strategy
• Recovery strategy
• TM/MP recovery of SQL/MP objects and their catalog
• TM/MP recovery of SQL/MP objects without recovering their catalog
• Using licensed copy of SQLCI2 to insert, update, or delete metadata

Module 12: Backing up and Restoring HPE Nonstop SQL/MP Database Objects

• File-mode BACKUP and RESTORE options that can beused with HPE NonStop SQL/MP objects
• Developing protection strategies with the BACKUP and RESTORE utilities for SQL/MP objects
• Volume-mode options of the BACKUP and RESTORE utilities
• Using the tape simulator program to implement BACKUP and RESTORE options
• Possible causes for objects becoming unusable
• Locating unusable objects
• Removing unusable objects
• Identifying the appropriate tools to make objects usable
• Using the simulator program to implement Backup and Restore options

Lab

• Backing Up and Restoring SQL/MP Database Objects

Module 13: Managing HPE Nonstop SQL/MP Database Security

• Process for securing the HPE Nonstop SQL/MP environment
• Authorization requirements for SQL/MP operations
• SQL/MP security commands and utilities
• SQL/MP protection views
• HPE Nonstop Kernel security and the Safeguard product security characteristics
• Security for the production and development environment

Lab

• Managing SQL/MP Database Security

Module 14: Tools for Monitoring Performance

• Performance tools: SQLCI, Measure product, TandemPerformance Data Collector (TPDC), and basic guidelines for monitoring performance

Module 15: Disk process (DP2) Performance Enhancements

• Methods to enhance the performance of the disk process

Module 16: Managing Sorts

• Sorts available to HPE Nonstop SQL/MP
• Managing sort processes to control system resources
• Configuring serial and parallel sort operations

Module 17: Controlling HPE Nonstop SQL/MP Processes

• Controlling the impact of HPE Nonstop SQL/MP processes on performance