Skip to main Content

HP NonStop SQL/MX Basics

  • Course Code U4184S
  • Duration 5 days

Additional Payment Options

  • GTC 23 inc. VAT

    GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details

Public Classroom Price

£1,500.00

excl. VAT

Request Group Training Add to Cart

Course Delivery

This course is available in the following formats:

  • Company Event

    Event at company

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Course Overview

Top

This 5-day course is an introduction to SQL, relational database principles, and the HP 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).

Course Schedule

Top

Target Audience

Top

This course is susitalbe for anyone reqauiring an introductory course to SQL and working with the NonStop SQL/MX product.


Course Objectives

Top
  • Describe relational database concepts and terminology
  • Describe the HP NonStop™ SQL/MX processes and objects
  • Start a mxci session and use ANSI names 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
  • from derived tables using query expressions
  • 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

Course Prerequisites

Top
  • Concepts and Facilities course (U4147S)
Cookie Control toggle icon