HP NonStop SQL/MX Basics
- Course Code U4184S
- Duration 5 days
- Version link.aspx
Course Delivery
Additional Payment Options
-
GTC 23 inc. VAT
GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details
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
TopThis 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
TopTarget Audience
TopThis 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)
- /en-gb/-/media/global-knowledge/merchandising/right-side-column/uk/cisco-clcs.png https://www.globalknowledge.com/en-gb/training/courses/technology-providers/cisco/learning-credits-clc #000000
- /en-gb/-/media/global-knowledge/rte-images/campaigns-and-promotions/aws_awardwebbanner.jpg https://www.globalknowledge.com/us-en/company/awards/ #000000
- U4184S
- HP NonStop SQL/MX Basics
- Operating Systems
- U4184S | HP NonStop SQL/MX Basics | Training Course | Hewlett Packard Enterprise (HPE).
- Hewlett Packard Enterprise (HPE)