Course ID 00071733
HP product number U4183S
Course format ILT
Course length 4 days
Skill level Expert
Delivery languages English
Related certifications
In preparation for these exams
Selected items from this course are included in these exams:
Register for this course.
Find this course in the Training calendar and click the “Register” link in the last column to begin your registration.

Course description

This course teaches how to design complex and efficient queries to access HP NonStop SQL/MP databases. Learn the different query analysis and tuning techniques. Become familiar with tools to optimize query performance, influence the optimizer's choice of query execution plans and test queries before they go into production.This course is applicable for both online transaction processing (OLTP) and decision support solutions (DSS) query programs.

Who should attend

Anyone who has responsibilities for query design and programming or query performance and tuning.

Prerequisites

• NonStop SQL/MP Essentials course
• NonStop SQL/MP experience in a production environment
For complete prerequisites and requirements to achieve any of the related certifications or upgrade paths, see the certification description on the HP ExpertOne website.

Objectives

After completing this course, you should be able to do the following:
  • Design complex and efficient queries to access HP NonStop SQL/MP databases.
  • Understand different query analysis and tuning techniques.
  • Be familiar with tools to optimize query performance
  • Test queries before they go into production.

How to register

View the HP ExpertOne Global Training Calendar to register for the trainings offering that best meets your needs.

Policies, fees and cancellations

Course fees may vary and are established and collected by the training center delivering the course. Cancellation fees may apply. Contact your HP Authorized Training Partner for their respective policies.