courseoutline_metadesc.tpl

HPE NonStop SQL/MP Essentials (U4181S) – Details

Detaillierter Kursinhalt

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