Logo Hewlett Packard Enterprise

HPE NonStop SQL/MP Essentials

Trainings-ID:
U4181S

Inhalt des Trainings

This course is an introduction to the HPE NonStop SQL/ MP database product and serves as a prerequisite to more advanced courses. Hands-on lab sessions provide practical experience with creating databases and generating queries to access the data. The course is 70 percent lecture and 30 percent hands-on labs using HPE NonStop servers.

After you successfully complete this course, expect to be able to:
  • Understand relational database concepts and terminology

Zielgruppen

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

Vorkenntnisse

  • U4147S: Concepts and Facilities for HPE NonStop Systems

Detail-Inhalte

 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

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

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

NonStop SQL/MP - The SQL Language
  • Standard types of SQL statements and their functions

NonStop SQL/MP Conversational Interface
  • Setting up an SQLCI session
  • Standard SQLCI commands
  • Ad hoc query processing
  • SQLCI Report Writer

Generating Queries for Single Tables
  • Core syntax, structure, and function of an SQL query

Generating Queries Against Multiple Tables
  • Concept of a “join” 
  • Simple join examples
  • How joining works and how to work through a join

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

Creating a NonStop SQL/MP Database
  • Catalog
  • Table
  • Partition
  • Index 
  • Constraint
  • View
  • Comment
  • Collation

Creating Rows and Loading a NonStop SQL/ MP Database
  • Referential integrity
  • How to use the INSERT statement
  • SQL utilities, CONVERT, COPY, and LOA

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

 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

Downloads

Terminanfrage

Ab  2.688,-*

*Preis pro Teilnehmer*in ohne Zusatzoptionen, exkl. MwSt.

Sie haben Fragen?

Ihr ETC Support

Kontaktieren Sie uns!

+43 1 533 1777-99

Hidden
Hidden
Hidden

Lernformen im Überblick

Mehr darüber