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

Upcoming Trainings

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

Classroom / Virtual Classroom

29 juli 2024

Oslo, Bergen, Trondheim

€3,640 +VAT Book Now

Classroom / Virtual Classroom

18 august 2024

Oslo, Bergen, Trondheim

4 Days

Classroom / Virtual Classroom

25 august 2024

Oslo, Bergen, Trondheim

4 Days

Classroom / Virtual Classroom

05 september 2024

Oslo, Bergen, Trondheim

4 Days

Classroom / Virtual Classroom

04 september 2024

Oslo, Bergen, Trondheim

4 Days

Classroom / Virtual Classroom

07 september 2024

Oslo, Bergen, Trondheim

4 Days

Classroom / Virtual Classroom

19 september 2024

Oslo, Bergen, Trondheim

4 Days

Classroom / Virtual Classroom

17 oktober 2024

Oslo, Bergen, Trondheim

4 Days

HPE NonStop SQL/MP Essentials Training Course in Norway

The Nordic country Norway, is in Northern Europe. Known for its stunning natural beauty, including fjords, mountains, and forests, Norway is also famous for its high standard of living and strong social welfare system. Norway's capital and largest city is Oslo. Tromsø, Bergen, Trondheim and Stavanger are the other tourist attracting cities of Norway.

Norway is a constitutional monarchy with King Harald V as the head of state. The country has a population of 5,425,270 as of January 2022. Norway is a relatively small country and has a relatively low population density, with much of its land area covered by forests, mountains, and fjords. Despite its small size, Norway is known for its rich cultural heritage, strong economy, and stunning natural beauty, which attracts millions of visitors every year. This Nordic country is also known for its winter sports, such as skiing and snowboarding, and is a popular destination for outdoor enthusiasts.

Norway has a long history of invention and is home to numerous more top-tier tech firms and research facilities, such as; Kongsberg Gruppen, Telenor, Atea, Evry and Gjensidige Forsikring.

Due to the country's high latitude, there are large seasonal variations in daylight. From late May to late July, the sun never completely descends beneath the horizon. Which attracts many tourists around the world to see the "Land of the Midnight Sun". Tourists mainly visit Sognefjord, Norway's Largest Fjord, Pulpit Rock, one of the most photographed sites in Norway and of course the capital; Oslo.

Oslo is considered the business center of Norway. It is the country's largest city and the capital of Norway. The city is home to many of Norway's largest and most important companies, as well as several international organizations and research institutions. Additionally, the city is a popular tourist destination, known for its scenic location on the Oslo Fjord, its many museums and cultural attractions, and its vibrant nightlife and dining scene. Some of the most popular museums in Oslo are The Norwegian Museum of Cultural History, The Nobel Peace Center, The National Museum of Art, Architecture, and Design, The Munch Museum and The Vigeland Museum.

HPE NonStop SQL/MP Essentials Training in Norway

Prerequisites

Outline

Upcoming Trainings