HPE NonStop SQL/MP Essentials Training in Canada

• Concept and Facilities for NonStop Systems (U4147S)

Audience

• Anyone working with or interested in the HP NonStop SQL/MP product
• Anyone responsible for managing or designing a database or developing embedded SQL programs

Module 1 - Relational Database Definitions

• Flat-file systems and relational database management systems (RDMBS)
• Components of a relational table
• Relational database structure
• Primary and foreign keys in a relational table
• Different types of relationships
• How relationships are formed in a relational database

Module 2 - SQL/MP Physical Architecture

• Characteristics and functions of NonStop SQL/MP objects
• Function and important aspects of each of the objects

Module 3 - NonStop SQL/MP Process Architecture

• Characteristics and functions of NonStop SQL/MP processes
• Function and important aspects of each of the processes
• Overall data flow

Module 4 - NonStop SQL/MP - the SQL Language

• Standard types of SQL statements and their functions

Module 5 - NonStop SQL/MP Conversational Interface

• Setting up an SQLCI session
• Standard SQLCI commands
• Ad hoc query processing

Module 6 - Generating Queries for Single Tables

• Core syntax, structure, and function of an SQL query

Module 7 - Generating Queries Against Multiple Tables

• Concept of a 'join'
• Simple join examples
• How joining works and how to work through a join

Module 8 - SQL Subqueries

• Concept of a subquery
• Two types of subqueries
• Syntax of subqueries

Module 9 - Creating a NonStop SQL/MP Database

• Catalog
• Table
• Partition
• Index
• Constraint
• View
• Comment
• Collation

Module 10 - Creating Rows and Loading a NonStop SQL/MP Database

• Referential integrity
• How to use the INSERT statement
• SQL utilities, CONVERT, COPY, and LOA

Module 11 - Modifying Database Data

• Business transactions and Transaction Control Language (TCL) SQL commands
• SQL UPDATE and DELETE commands
• Locking mechanisms

Module 12 - NonStop SQL Management Functions

• Introduction to managing an SQL/MP database
• Syntax to alter or drop a NonStop SQL/MP object
• Impact and considerations to alter or drop SQL objects in the database
• Security issues related to adding, altering, or dropping an SQL object from the database
• Object dependencies
• SQLCI and NonStop kernel utilities