{"course":{"productid":33910,"modality":6,"active":true,"language":"de","title":"HPE NonStop SQL\/MP Essentials","productcode":"U4181S","vendorcode":"HP","vendorname":"HP","fullproductcode":"HP-U4181S","courseware":{"has_ekit":false,"has_printkit":true,"language":""},"url":"https:\/\/portal.flane.ch\/course\/hewlettpackard-u4181s","objective":"<h5>At the conclusion of this course you should be able to:<\/h5>\n<ul>\n<li>Understand relational database concepts and terminology<\/li><\/ul><h5>At the end of this course students will learn: <\/h5><ul>\n<li>Relational database concepts and terminology<\/li><li>HPE NonStop SQL\/MP components<\/li><li>HPE NonStop SQL\/MP database structures<\/li><li>HPE NonStop SQL\/MP conversational interface<\/li><li>HPE NonStop SQL\/MP queries<\/li><li>HPE NonStop SQL\/MP database object creation and management<\/li><\/ul>","essentials":"<ul>\n<li>U4147S: Concepts and Facilities for HPE NonStop Systems<\/li><\/ul>","audience":"<ul>\n<li>Anyone working with or interested in the HPE NonStop SQL\/MP product<\/li><li>Anyone responsible for managing or designing a database or developing embedded SQL programs<\/li><\/ul>","outline":"<h5>Module 1 - Relational Database Definitions <\/h5><ul>\n<li>Flat-file systems and relational database management systems (RDMBS)<\/li><li>Components of a relational table<\/li><li>Relational database structure<\/li><li>Primary and foreign keys in a relational table<\/li><li>Different types of relationships<\/li><li>How relationships are formed in a relational database<\/li><\/ul><h5>Module 2 - SQL\/MP Physical Architecture <\/h5><ul>\n<li>Characteristics and functions of NonStop SQL\/MP objects<\/li><li>Function and important aspects of each of the objects<\/li><\/ul><p>\nModule 3 - NonStop SQL\/MP Process Architecture \n<\/p>\n<ul>\n<li>Characteristics and functions of NonStop SQL\/MP processes<\/li><li>Function and important aspects of each of the processes<\/li><li>Overall data flow<\/li><\/ul><h5>Module 4 - NonStop SQL\/MP - The SQL Language <\/h5><ul>\n<li>Standard types of SQL statements and their functions<\/li><\/ul><h5>Module 5 - NonStop SQL\/MP Conversational Interface <\/h5><ul>\n<li>Setting up an SQLCI session<\/li><li>Standard SQLCI commands<\/li><li>Ad hoc query processing<\/li><li>SQLCI Report Writer<\/li><\/ul><h5>Module 6 - Generating Queries for Single Tables<\/h5>\n<ul>\n<li>Core syntax, structure, and function of an SQL query<\/li><\/ul><h5>Module 7 - Generating Queries Against Multiple Tables <\/h5><ul>\n<li>Concept of a &ldquo;join&rdquo;<\/li><li>Simple join examples<\/li><li>How joining works and how to work through a join<\/li><\/ul><h5>Module 8 - SQL Subqueries <\/h5><ul>\n<li>Concept of a subquery<\/li><li>Two types of subqueries<\/li><li>Syntax of subqueries<\/li><\/ul><h5>Module 9 - Creating a NonStop SQL\/MP Database <\/h5><ul>\n<li>Catalog<\/li><li>Table<\/li><li>Partition<\/li><li>Index<\/li><li>Constraint<\/li><li>View<\/li><li>Comment<\/li><li>Collation<\/li><\/ul><h5>Module 10 - Creating Rows and Loading a NonStop SQL\/ MP Database <\/h5><ul>\n<li>Referential integrity<\/li><li>How to use the INSERT statement<\/li><li>SQL utilities, CONVERT, COPY, and LOA<\/li><\/ul><h5>Module 11 - Modifying Database Data <\/h5><ul>\n<li>Business transactions and Transaction Control Language (TCL) SQL commands<\/li><li>SQL UPDATE and DELETE commands<\/li><li>Locking mechanisms<\/li><\/ul><h5>Module 12 - NonStop SQL Management Functions <\/h5><ul>\n<li>Introduction to managing an SQL\/MP database<\/li><li>Syntax to alter or drop a NonStop SQL\/MP object<\/li><li>Impact and considerations to alter or drop SQL objects in the database<\/li><li>Security issues related to adding, altering, or dropping an SQL object from the database<\/li><li>Object  dependencies &bull; SQLCI and NonStop kernel utilities<\/li><\/ul>","summary":"<p>This course is an introduction to the HPE 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% lecture and 30% hands-on labs using HPE NonStop servers.<\/p>","objective_plain":"At the conclusion of this course you should be able to:\n\n\n\n- Understand relational database concepts and terminology\nAt the end of this course students will learn: \n\n\n- Relational database concepts and terminology\n- HPE NonStop SQL\/MP components\n- HPE NonStop SQL\/MP database structures\n- HPE NonStop SQL\/MP conversational interface\n- HPE NonStop SQL\/MP queries\n- HPE NonStop SQL\/MP database object creation and management","essentials_plain":"- U4147S: Concepts and Facilities for HPE NonStop Systems","audience_plain":"- Anyone working with or interested in the HPE NonStop SQL\/MP product\n- Anyone responsible for managing or designing a database or developing embedded SQL programs","outline_plain":"Module 1 - Relational Database Definitions \n\n\n- Flat-file systems and relational database management systems (RDMBS)\n- Components of a relational table\n- Relational database structure\n- Primary and foreign keys in a relational table\n- Different types of relationships\n- How relationships are formed in a relational database\nModule 2 - SQL\/MP Physical Architecture \n\n\n- Characteristics and functions of NonStop SQL\/MP objects\n- Function and important aspects of each of the objects\n\nModule 3 - NonStop SQL\/MP Process Architecture \n\n\n\n- Characteristics and functions of NonStop SQL\/MP processes\n- Function and important aspects of each of the processes\n- Overall data flow\nModule 4 - NonStop SQL\/MP - The SQL Language \n\n\n- Standard types of SQL statements and their functions\nModule 5 - NonStop SQL\/MP Conversational Interface \n\n\n- Setting up an SQLCI session\n- Standard SQLCI commands\n- Ad hoc query processing\n- SQLCI Report Writer\nModule 6 - Generating Queries for Single Tables\n\n\n\n- Core syntax, structure, and function of an SQL query\nModule 7 - Generating Queries Against Multiple Tables \n\n\n- Concept of a \u201cjoin\u201d\n- Simple join examples\n- How joining works and how to work through a join\nModule 8 - SQL Subqueries \n\n\n- Concept of a subquery\n- Two types of subqueries\n- Syntax of subqueries\nModule 9 - Creating a NonStop SQL\/MP Database \n\n\n- Catalog\n- Table\n- Partition\n- Index\n- Constraint\n- View\n- Comment\n- Collation\nModule 10 - Creating Rows and Loading a NonStop SQL\/ MP Database \n\n\n- Referential integrity\n- How to use the INSERT statement\n- SQL utilities, CONVERT, COPY, and LOA\nModule 11 - Modifying Database Data \n\n\n- Business transactions and Transaction Control Language (TCL) SQL commands\n- SQL UPDATE and DELETE commands\n- Locking mechanisms\nModule 12 - NonStop SQL Management Functions \n\n\n- Introduction to managing an SQL\/MP database\n- Syntax to alter or drop a NonStop SQL\/MP object\n- Impact and considerations to alter or drop SQL objects in the database\n- Security issues related to adding, altering, or dropping an SQL object from the database\n- Object  dependencies \u2022 SQLCI and NonStop kernel utilities","summary_plain":"This course is an introduction to the HPE 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% lecture and 30% hands-on labs using HPE NonStop servers.","skill_level":"Beginner","version":"1.0","duration":{"unit":"d","value":4,"formatted":"4 Tage"},"pricelist":{"List Price":{"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":3000},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":3600},"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":3000}}},"lastchanged":"2025-07-29T12:18:23+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/json-course-schedule\/33910","source_lang":"de","source":"https:\/\/portal.flane.ch\/swisscom\/json-course\/hewlettpackard-u4181s"}}