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 HPE Nonstop SQL/MP objects
• Function and important aspects of each of the objects

Module 3: HPE Nonstop SQL/MP Process Architecture

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

Module 4: HPE Nonstop SQL/MP - The SQL Language

• Standard types of SQL statements and their functions

Module 5: HPE Nonstop SQL/MP Conversational Interface

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 HPE Nonstop SQL/MP Database

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

Module 10: Creating Rows and Loading a HPE 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: HPE Nonstop SQL Management Functions

• Introduction to managing an SQL/MP database
• Syntax to alter or drop a HPE 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