Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? Ask now.
|
Course Overview 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. Audience Anyone who has responsibilities for query design and programming or query performance and tuning. Skills Gained - 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
Prerequisites - NonStop SQL/MP Essentials course
- NonStop SQL/MP experience in a production environment
How to make a booking for the U4183S course
|
