Training Course: NonStop SQL MP query design for performance

training course enquiry

Back to Search Results

Training Course Code: U4183S
Training Duration: 4 days.
Price: £1,600

Training Course Summary:

Enhance your query writing skills by learning how to design complex and efficient queries to access HP NonStop™ 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.

Pre-Requisites:

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

Who Should Attend:

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

Training Course Overview/Content:

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

Training course title:

Name:

Email:

Phone:

Company Name: (if applicable)

Number of delegates attending:

Preferred Location:

Select from above or tick in house (we come to you)

Preferred dates: