HPE NonStop SQL/MP Essentials Training

  • Learn via: Classroom
  • Duration: 4 Days
  • Level: Fundamentals
  • Price: From $3,640+VAT
We can host this training at your preferred location. Contact us!

This 4-day course is an introduction to the HP 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 HP NonStop servers.

  • Concept and Facilities for NonStop Systems (U4147S)


Audience

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

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


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


Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
18 April 2024
Istanbul, Ankara, London
4 Days
Classroom / Virtual Classroom
23 April 2024
Istanbul, Ankara, London
4 Days
Classroom / Virtual Classroom
06 May 2024
Istanbul, Ankara, London
4 Days
Classroom / Virtual Classroom
04 June 2024
Istanbul, Ankara, London
4 Days
Classroom / Virtual Classroom
10 June 2024
Istanbul, Ankara, London
4 Days
Classroom / Virtual Classroom
16 June 2024
Istanbul, Ankara, London
4 Days
Classroom / Virtual Classroom
06 July 2024
Istanbul, Ankara, London
4 Days
Classroom / Virtual Classroom
14 July 2024
Istanbul, Ankara, London
4 Days
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.