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).
TARGET AUDIENCE:
This course is susitalbe for anyone reqauiring an introductory course to SQL and working with the NonStop SQL/MX product.
COURSE PREREQUISITES:
• Concepts and Facilities course (U4147S)
COURSE CONTENT:
Not available. Please contact.
COURSE OBJECTIVE:
• 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
FOLLOW ON COURSES:
Not available. Please contact.