Course Overview
This course is an introduction to SQL, relational database principles, and the HPE NonStop SQL/MX product and serves as a prerequisite to more advanced HPE 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).
Who should attend
- Anyone requiring an introduction to SQL and working with the HPE NonStop SQL/MX product
Prerequisites
- Concepts and Facilities course (U4147S)
Course Objectives
- Describe relational database concepts and terminology
- Describe the HPE NonStop SQL/MX processes 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
Upon completion of this course, you will:
- 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