HPE NonStop SQL/MP Essentials Training in Germany

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

Classroom / Virtual Classroom
29 Juli 2024
Berlin, Hamburg, Münih
€3,640 +VAT Book Now
Classroom / Virtual Classroom
18 August 2024
Berlin, Hamburg, Münih
4 Days
Classroom / Virtual Classroom
25 August 2024
Berlin, Hamburg, Münih
4 Days
Classroom / Virtual Classroom
05 September 2024
Berlin, Hamburg, Münih
4 Days
Classroom / Virtual Classroom
04 September 2024
Berlin, Hamburg, Münih
4 Days
Classroom / Virtual Classroom
07 September 2024
Berlin, Hamburg, Münih
4 Days
Classroom / Virtual Classroom
19 September 2024
Berlin, Hamburg, Münih
4 Days
Classroom / Virtual Classroom
17 Oktober 2024
Berlin, Hamburg, Münih
4 Days
HPE NonStop SQL/MP Essentials Training Course in Germany

The Federal Republic of Germany is the second most populous country in Europe and is located in Central Europe. The official language of the country is German. Germany is one of the richest countries in the world. The main exports of the country include motor vehicles and iron and steel products.

Here are some fun facts about Germany:
The fairy tale writer, the Brothers Grimm, came from Germany and wrote many famous stories such as Cinderella, Snow White, and Sleeping Beauty.
Germany is home to the largest theme park in Europe, the Europa-Park.
The famous composer Ludwig van Beethoven was born in Germany.
The Autobahn, the German highway system, is known for having no general speed limit.


Berlin was divided by the Berlin Wall from 1961 to 1989. Known for its street art, Berlin has many colorful murals and graffiti throughout the city. Also, Berlin is home to many famous museums, such as the Pergamon Museum and the Museum Island. Many clubs and bars stay open until the early hours of the morning in this big city.

Another popular city is Munich, which is famous for its Oktoberfest beer festival that attracts millions of visitors every year. Munich is also home to many historic buildings, including Nymphenburg Palace and the Marienplatz town square.

The country's capital and largest city is Berlin, however Frankfurt is considered to be the business and financial center of Germany. It is home to the Frankfurt Stock Exchange, the European Central Bank, and many other financial institutions. Because of its central location within Europe and its status as a major financial hub, Frankfurt is often referred to as the "Mainhattan," a play on the city's name and its association with the Manhattan financial district in New York City.

Frankfurt is also a major transportation hub, with the largest airport in Germany and one of the largest in Europe, Frankfurt Airport. Additionally, it is a popular destination for tourists, with its historic city center, beautiful parks, and vibrant cultural scene.

Some of the top German technology companies like Siemens AG, Bosch, SAP SE, Deutsche Telekom, Daimler AG and Volkswagen has business centers in Frankfurt. The country has a strong tradition of engineering and innovation, and is home to many other world-class technology companies and research institutions.

Tailored to meet the specific needs of Germany, Bilginç IT Academy combines cutting-edge training methodologies with our comprehensive range of Certification Exam preparation courses and accredited corporate training programs. Experience a transformative approach to IT training that will redefine your expectations.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.