HPE NonStop SQL/MP Essentials Training in South Africa

  • 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 South Africa facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
29 July 2024
Cape Town, Durban, Johannesburg
€3,640 +VAT Book Now
Classroom / Virtual Classroom
18 August 2024
Cape Town, Durban, Johannesburg
4 Days
Classroom / Virtual Classroom
25 August 2024
Cape Town, Durban, Johannesburg
4 Days
Classroom / Virtual Classroom
05 September 2024
Cape Town, Durban, Johannesburg
4 Days
Classroom / Virtual Classroom
04 September 2024
Cape Town, Durban, Johannesburg
4 Days
Classroom / Virtual Classroom
07 September 2024
Cape Town, Durban, Johannesburg
4 Days
Classroom / Virtual Classroom
19 September 2024
Cape Town, Durban, Johannesburg
4 Days
Classroom / Virtual Classroom
17 October 2024
Cape Town, Durban, Johannesburg
4 Days
HPE NonStop SQL/MP Essentials Training Course in South Africa

Formerly known as Union of South Africa, now officially known as Republic of South Africa is the Southernmost country in Africa. South Africa's population is over 60 million people, which makes the country the world's 23rd-most populous nation. South Africa has three capital cities: executive Pretoria, judicial Bloemfontein and legislative Cape Town, while the largest city is Johannesburg. The official languages of South Africa are Afrikaans, English, Ndebele, Pedi, Sotho, Swati, Tsonga, Tswana, Venda, Xhosa and Zulu.

South Africa can be rainy from November to February, so the best time to visit South Africa is from May to September. Despite the rainy season South Africa is a year-round destination, with varying regional climates. Blyde River Canyon, Durban, Drakensberg, Kruger National Park and of course, Cape Town are the tourist attractions of the country.

Expand your IT knowledge with our comprehensive range of courses, including programming, software development, business skills, data science, cybersecurity, cloud computing and virtualization. Our skilled instructors will facilitate hands-on training and share practical insights, all conveniently conducted at your preferred location within South Africa.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.