Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

HPE NonStop SQL/MP

( Duration: 4 Days )

This HPE NonStop SQL/MP training course provides 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.

By attending HPE NonStop SQL/MP workshop, delegates will learn to:

  • Understand 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

  • Attend a training on Concepts and Facilities for HPE NonStop Systems or equivalent practical experience

The HPE NonStop SQL/MP class is ideal for:

  • 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

COURSE AGENDA

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
2

SQL/MP Physical Architecture

  • Characteristics and functions of NonStop SQL/MP objects
  • Function and important aspects of each of the objects
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
4

NonStop SQL/MP - The SQL Language

  • Standard types of SQL statements and their functions
5

NonStop SQL/MP Conversational Interface

  • Setting up an SQLCI session
  • Standard SQLCI commands
  • Ad hoc query processing
  • SQLCI Report Writer
6

Generating Queries for Single Tables

  • Core syntax, structure, and function of an SQL query
7

Generating Queries Against Multiple Tables

  • Concept of a “join”
  • Simple join examples
  • How joining works and how to work through a join
8

SQL Subqueries

  • Concept of a subquery
  • Two types of subqueries
  • Syntax of subqueries
9

Creating a NonStop SQL/MP Database

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

Creating Rows and Loading a NonStop SQL/MP Database

  • Referential integrity
  • How to use the INSERT statement
  • SQL utilities, CONVERT, COPY, and LOA
11

Modifying Database Data

  • Business transactions and Transaction Control Language (TCL) SQL commands
  • SQL UPDATE and DELETE commands
  • Locking mechanisms
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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X