HPE NonStop SQL/MP Essentials

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
• SQLCI Report Writer

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