U4181S - HPE NonStop SQL/MP Essentials - Online Training - English - Webinar von Fast Lane Institute for Knowledge Transfer

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
• Objectdependencies • SQLCI and NonStop kernel utilities

At the conclusion of this course you should be able to:

• Understand relational database concepts and terminology

At the end of this course students will learn:

• Relational database concepts and terminology
• HPE NonStop SQL/MP components
• HPE NonStop SQL/MP database structures
• HPE NonStop SQL/MP conversational interface
• HPE NonStop SQL/MP queries
• HPE NonStop SQL/MP database object creation and management