About this course
This 5 day course is to help SQL/MP users transition to SQL/MX. The course describes the HP NonStop SQL/MX Release 2.0 architecture and processes.
See all training courses
See all certifications
Learn more about our online courses
See all training locations
To find out more about any of our services please contact us
Learn more about QA careers
This 5 day course is to help SQL/MP users transition to SQL/MX. The course describes the HP NonStop SQL/MX Release 2.0 architecture and processes.
Audience
Persons with practical experience creating databases, and generating queries using the NonStop SQL/MP product wanting to develop new applications using the ANSI-92 features of the NonStop SQL/MX product
Module 1 Overview of NonStop SQL/MX Release 2.0 Architecture
Module 2 Running an mxci Session
Module 3 SQL/MX DML Statements and Options
Module 4 Compiling Embedded SQL/MX
Module 5 Preprocessing SQL/MX Programs on a
Module 6 SQL/MX Compound Statements
Module 7 SQL/MX Rowsets
Module 8 SQL/MX Queuing and Publish and Subscribe Services
Module 9 SQL/MX Module Management
Module 10 Managing SQL/MX Applications
Module 11 SQL/MX Transpose Clause
Module 12 SQL/MX Sample Clause
Module 13 SQL/MX Sequence Functions
Module 14 NonStop SQL/MX Query Optimization
Onsite-Delivery Equipment Requirements
This is a QA approved partner course
Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.
We pride ourselves on the unrivalled quality of the training delivered by our experienced learning teams. Every course will teach relevant new skills that can be applied back in the workplace to improve performance.
Flexible learning options
We offer a range of flexible learning options to suit different learning styles and accommodate busy schedules, including traditional classroom courses, innovative virtual training and a range of eLearning solutions.
QA Authored
We offer over 500 QA Authored courses, designed by our subject-matter experts to complement the courses offered by leading vendors and develop skills that are immediately applicable in the workplace.
Resources to aid learning
With QA you will have access to a myQA account to manage your schedule and access extra content. We also provide exclusive training videos on demand and free revision emails for certain courses.
First-class learning centres
All QA learning centres provide free high-speed Wi-Fi, complimentary refreshments, a comfortable lounge to relax in between sessions, state-of-the-art personal workstations, and IT labs facilities for relevant courses.