HP NonStop SQL/MX Basics (U4184S)

Kurskode: U4184S

varighet: 5

Katergori: Hewlett Packard Enterprise (HPE)

Course Overview

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).

Not available. Please contact.

• 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

• Concepts and Facilities course (U4147S)

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

Salar Ghadani

Salg

Har du spørsmål, ta kontakt

918 34 713 salar@sgpartner.no

Kurskode: U4184S

varighet: 5

KATEGORI: Hewlett Packard Enterprise (HPE)

Underkatergori: Operating Systems

Relaterte kurs