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
Module 1 - Relational Database Definitions
Module 2 - SQL/MP Physical Architecture
Module 3 - NonStop SQL/MP Process Architecture
Module 4 - NonStop SQL/MP - the SQL Language
Standard types of SQL statements and their functions
Module 5 - NonStop SQL/MP Conversational Interface
Module 6 - Generating Queries for Single Tables
Core syntax, structure, and function of an SQL query
Module 7 - Generating Queries Against Multiple Tables
Module 8 - SQL Subqueries
Module 9 - Creating a NonStop SQL/MP Database
Module 10 - Creating Rows and Loading a NonStop SQL/MP Database
Module 11 - Modifying Database Data
Module 12 - NonStop SQL Management Functions
Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.