This HPE NonStop SQL/MX training course provides an introduction to SQL, relational database principles, and the HPE NonStop SQL/MX product and serves as a prerequisite to more advanced NonStop SQL/ MX courses. Hands-on lab sessions provide practical experience with generating SQL/MX queries to access data and creating database objects (catalogs, tables, indexes, views, and constraints).
By attending HPE NonStop SQL/MX workshop, delegates will learn to:
- Describe relational database concepts and terminology
- Describe the HPE NonStop SQL/MXprocesses and objects
- Use a mxci session and reference ANSI names for SQL/MX database objects
- Describe the basic process to write queries and the tools to evaluate the query performance
- Use the mxci SELECT statement and predicates to retrieve data from single tables
- List the types of functions supported in SQL/MX
- Retrieve data from:
- multiple tables using joins and union operations
- derived tables using Query Expression by using subqueries
- Create a SQL/MX database (Catalog, Schema, Tables, Indexes, Views, and Constraints)
- Modify data in a table using SQL/MX INSERT, UPDATE, and DELETE statements
- Describe the SQL/MX access options and isolation levels
- Describe SQL/MX database management functions
- Understand key relational database concepts and terminology
- Be able to use mxci commands to create SQL/MX objects
- Be able to use SQL statements to retrieve or modify data in SQL/MX tables
- Attend a training on Concepts and Facilities for HPE NonStop Systems or equivalent practical experience
The HPE NonStop SQL/MX class is ideal for:
- Anyone requiring an introduction to SQL and working with the NonStop SQL/MX product