HPE NonStop SQL/MP Essentials - U4181S

Beschreibung

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

expand_more chevron_right Zielgruppe

Ideal candidate for this course:
  • 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

    expand_more chevron_right Vorkenntnisse

    The following knowledge is recommended for this seminar:

    expand_more chevron_right 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

    Terminanfrage

      Durch Angabe Ihrer E-Mail-Adresse und Anklicken des Buttons „Newsletter abonnieren“ erklären Sie sich damit einverstanden, dass ETC Ihnen regelmäßig Informationen zu IT Seminaren und weiteren Trainings- und Weiterbildungsthemen zusendet. Die Einwilligung kann jederzeit bei ETC widerrufen werden.