HP NonStop: SQL/MP query design for performance UK Classes & Lessons (HP)

About this class

Enhance your query writing skills by learning how to design complex and efficient queries to access HP NonStop(TM) SQL/MP databases in this 4-day class. 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 programmers.

Who will the lesson benefit?

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

What delegates will learn

query writing process
advanced query writing
ry processing using NonStop SQL/MP
improving query performance through query design
query design for DSS and OLTP environment
basic query component overview
performance considerations in query design
Stop SQL/MP optimizer functions
Iproving query performance through environment control

What prerequisites are required

NonStop SQL/MP Essentials course
NonStop SQL/MP experience in a production environment