{"course":{"productid":33914,"modality":6,"active":true,"language":"en","title":"HPE NonStop SQL\/MX Database Management","productcode":"U8617S","vendorcode":"HP","vendorname":"HP","fullproductcode":"HP-U8617S","courseware":{"has_ekit":false,"has_printkit":true,"language":""},"url":"https:\/\/portal.flane.ch\/course\/hewlettpackard-u8617s","objective":"<ul>\n<li>Describe HP NonStop SQL\/MX architecture<\/li><li>Install SQL\/MX and upgrade SQL\/MX metadata to current release<\/li><li>Create, alter, and drop SQL\/MX database objects (catalogs, schemas, tables, constraints, indexes, views, and triggers)<\/li><li>Grant and revoke access privileges to SQL\/MX database objects<\/li><li>Import data into SQL\/MX non-partitioned and range and hash partitioned tables<\/li><li>Protect and recover SQL\/MX database objects with HP NonStop Transaction Management Facility<\/li><li>Use the MODIFY utility to add, split, merge, and drop SQL\/MX range and hash partitioned tables<\/li><li>Describe and use the SQL\/MX utilities (DUP, import, migrate, MODIFY, mxtool, mxexportddl, MXGNAMES, POPULATE INDEX, and PURGEDATA)<\/li><li>Describe the SQL.MX distributed database<\/li><li>Become familiar with the SQL\/MX architecture using SQL\/MX native tables<\/li><li>Create and manage SQL\/MX database objects<\/li><\/ul>","essentials":"<ul>\n<li>NonStop SQL\/MX Basics (U4184S) &bull;NonStop SQL\/MX Quick Start (U4185S)<\/li><\/ul>","audience":"<ul>\n<li>Database administrators &bull;System managers &bull;Personnel responsible for the availability of NonStop SQL\/MX databases and applications<\/li><\/ul>","outline":"<h5>Module 1: Overview of SQL\/MX Architecture <\/h5><ul>\n<li>SQL\/MX logical structure, catalogs, schemas, and objects<\/li><li>SQL\/MX physical structure: SMD volumes, schema subvolumes, data forks and resource forks<\/li><li>SQL\/MX processes and utilities<\/li><li>Lab exercise: Overview of SQL\/MX Architecture<\/li><li>Identify the system catalog, schemas, and objects<\/li><li>Identify user catalogs, schemas, and objects<\/li><li>Locate the underlying files for SQL\/MX objects<\/li><li>Metadata basics<\/li><\/ul><h5>Module 2: SQL\/MX Installation<\/h5>\n<ul>\n<li>Hardware and software requirements for installing SQL\/MX<\/li><li>Installing SQL\/MX with the InstallSqlmx utility<\/li><li>Verifying the SQL\/MX Installation<\/li><li>Create the SQL\/MX sample database<\/li><li>Lab exercise: Perform a post-installation check for SQL\/MX.<\/li><\/ul><h5>Module 3: Metadata Migration to SQL\/MX R3.0 <\/h5><ul>\n<li>Migrating considerations<\/li><li>Post upgrade scenarios<\/li><li>FIXRCB operation<\/li><li>UPGRADE utility<\/li><\/ul><h5>Module 4: Creating SQL\/MX Objects<\/h5><ul>\n<li>Creating catalogs, schemas, tables, constraints, indexes, and views<\/li><li>Viewing object metadata<\/li><li>Lab exercise: Creating SQL\/MX Objects with mxci or NSM\/web<\/li><\/ul><h5>Module 5: Referential Integrity Constraints <\/h5><ul>\n<li>Referential Integrity<\/li><li>Creating referential integrity constraints as column or table constraints<\/li><li>Lab exercise: Creating Referential Integrity constraints with mxci or NSM\/web<\/li><\/ul>\n<h5>Module 6: Creating SQL\/MX Partitioned Tables and Indexes<\/h5>\n<ul>\n<li>Range and hash partitioned tables<\/li><li>Creating range and hash partitioned tables and indexes<\/li><li>Advantages and Disadvantages of each type of partitioning.<\/li><li>Decoupled keys, co-partitioned tables, and co-located partitions<\/li><li>Lab exercise: Creating range and hash partitioned tables with mxci or NSM\/web<\/li><\/ul>\n\n<h5>Module 7: Creating SQL\/MX Triggers <\/h5><ul>\n<li>Trigger terminology<\/li><li>Creating BEFORE and AFTER triggers<\/li><li>Cascading and conflicting triggers<\/li><li>Lab exercise: Creating SQL\/MX Triggers<\/li><\/ul><h5>Module 8: SQL\/MX Security<\/h5><ul>\n<li>Object ownership and security rules<\/li><li>Object Privileges<\/li><li>Use of Security Administrator&rsquo;s Group<\/li><li>Change object ownership<\/li><li>SQL\/MX GRANT and REVOKE commands<\/li><li>Lab exercise: Granting and Revoking Privileges with mxci or NSM\/web<\/li><\/ul><h5>Module 9: Import and Populate Index Utilities<\/h5>\n<ul>\n<li>Importing fixed and delimited data with the import utility<\/li><li>Importing data in parallel<\/li><li>Populating (loading) indexes<\/li><li>Lab exercise: Importing Data into Range and Hash Partitioned Tables and Indexes<\/li><\/ul><h5>Module 10: Reorganizing SQL\/MX Tables and Indexes <\/h5><ul>\n<li>Reorganizing data<\/li><li>Determining file fragmentation<\/li><li>FUP RELOAD and INFO commands<\/li><li>Lab exercise: Reorganizing Data<\/li><\/ul><h5>Module 11: Updating Statistics <\/h5><ul>\n<li>Histogram Statistics and histogram metadata tables<\/li><li>Generating single column and multicolumn statistics<\/li><li>Using sampling with the update statistics utility<\/li><li>Lab exercise: Updating and Viewing Statistics<\/li><\/ul><h5>Module 12: Database Protection and Recovery with TMF <\/h5><ul>\n<li>TMF Protection and Recovery Strategies<\/li><li>MXGNAMES Utility<\/li><li>Performing Online Dumps<\/li><li>Recovering dropped SQL\/MX Objects<\/li><li>Lab exercise: SQL\/MX Protection and Recovery Using TMF<\/li><\/ul><h5>Module 13: Compiling SQL\/MX Programs in the OSS Environment <\/h5><ul>\n<li>Compiling SQL\/MX Programs!Preprocessing source files for SQL\/MX<\/li><li>Language compiling SQL\/MX annotated source files<\/li><li>SQL\/MX compiling module definition files<\/li><li>Global or local module files<\/li><li>Defining search paths for module files<\/li><li>Lab exercise: Compiling Embedded SQL\/MX C or COBOL Programs in the OSS environment<\/li><\/ul><h5>Module 14: PURGEDATA Command and MODIFY Utility <\/h5><ul>\n<li>Purging data from range and hash partitioned tables<\/li><li>Adding, splitting, merging, and dropping range partitions<\/li><li>Adding and dropping hash partitions<\/li><li>Lab exercise: PURGEDATA Command and MODIFY Utility<\/li><\/ul><h5>Module 15: SQL\/MX Utilities <\/h5><ul>\n<li>DUP tables, indexes, and constraints<\/li><li>RECOVER utility<\/li><li>mxtool (INFO, VERIFY, FIXUP, and GOAWAY) utility<\/li><li>Lab exercise: SQL\/MX Utilities<\/li><\/ul><h5>Module 16: NonStop MXDM <\/h5><ul>\n<li>Features and requirements of MXDM<\/li><li>Installing and uninstalling<\/li><li>Example screens<\/li><\/ul><h5>Module 17: Managing SQL\/MX Applications <\/h5><ul>\n<li>Name references in programs<\/li><li>Compile time and late name resolution<\/li><li>Similarity checking<\/li><li>Automatic recompilation<\/li><li>Methods for moving SQL\/MX applications<\/li><li>Lab exercise: Managing Embedded SQL\/MX Programs<\/li><\/ul><h5>Module 18: SQL\/MX Distributed Databases<\/h5>\n<ul>\n<li>Distributed databases<\/li><li>Transparency, visibility, and availability<\/li><li>ANSI name translation for local and remote objects<\/li><li>REGISTER and UNREGISTER CATALOG commands<\/li><li>Lab exercise: SQL\/MX Distributed Database Demonstration<\/li><\/ul><h5>Module 19: Adding, Altering, and Dropping SQL\/MX Objects<\/h5>\n<ul>\n<li>Authorization for adding, altering, and dropping SQL\/MX objects<\/li><li>Adding SQL\/MX objects<\/li><li>Altering SQL\/MX objects<\/li><li>Dropping SQL\/MX objects<\/li><li>Lab exercise: Altering and dropping SQL\/MX objects<\/li><\/ul><h5>Module 20: Open Source Tools <\/h5><ul>\n<li>Overview of open source tools available for SQL\/MX usage<\/li><li>Describe usage of Eclipse to access SQL.MX<\/li><li>Overview of use of DBVisualizer to access SQL\/MX<\/li><\/ul>","summary":"<p>This course introduces tasks used by database administrators or system managers to manage and protect a NonStop SQL\/MX database and applications that access the database.<\/p>","objective_plain":"- Describe HP NonStop SQL\/MX architecture\n- Install SQL\/MX and upgrade SQL\/MX metadata to current release\n- Create, alter, and drop SQL\/MX database objects (catalogs, schemas, tables, constraints, indexes, views, and triggers)\n- Grant and revoke access privileges to SQL\/MX database objects\n- Import data into SQL\/MX non-partitioned and range and hash partitioned tables\n- Protect and recover SQL\/MX database objects with HP NonStop Transaction Management Facility\n- Use the MODIFY utility to add, split, merge, and drop SQL\/MX range and hash partitioned tables\n- Describe and use the SQL\/MX utilities (DUP, import, migrate, MODIFY, mxtool, mxexportddl, MXGNAMES, POPULATE INDEX, and PURGEDATA)\n- Describe the SQL.MX distributed database\n- Become familiar with the SQL\/MX architecture using SQL\/MX native tables\n- Create and manage SQL\/MX database objects","essentials_plain":"- NonStop SQL\/MX Basics (U4184S) \u2022NonStop SQL\/MX Quick Start (U4185S)","audience_plain":"- Database administrators \u2022System managers \u2022Personnel responsible for the availability of NonStop SQL\/MX databases and applications","outline_plain":"Module 1: Overview of SQL\/MX Architecture \n\n\n- SQL\/MX logical structure, catalogs, schemas, and objects\n- SQL\/MX physical structure: SMD volumes, schema subvolumes, data forks and resource forks\n- SQL\/MX processes and utilities\n- Lab exercise: Overview of SQL\/MX Architecture\n- Identify the system catalog, schemas, and objects\n- Identify user catalogs, schemas, and objects\n- Locate the underlying files for SQL\/MX objects\n- Metadata basics\nModule 2: SQL\/MX Installation\n\n\n\n- Hardware and software requirements for installing SQL\/MX\n- Installing SQL\/MX with the InstallSqlmx utility\n- Verifying the SQL\/MX Installation\n- Create the SQL\/MX sample database\n- Lab exercise: Perform a post-installation check for SQL\/MX.\nModule 3: Metadata Migration to SQL\/MX R3.0 \n\n\n- Migrating considerations\n- Post upgrade scenarios\n- FIXRCB operation\n- UPGRADE utility\nModule 4: Creating SQL\/MX Objects\n\n\n- Creating catalogs, schemas, tables, constraints, indexes, and views\n- Viewing object metadata\n- Lab exercise: Creating SQL\/MX Objects with mxci or NSM\/web\nModule 5: Referential Integrity Constraints \n\n\n- Referential Integrity\n- Creating referential integrity constraints as column or table constraints\n- Lab exercise: Creating Referential Integrity constraints with mxci or NSM\/web\n\nModule 6: Creating SQL\/MX Partitioned Tables and Indexes\n\n\n\n- Range and hash partitioned tables\n- Creating range and hash partitioned tables and indexes\n- Advantages and Disadvantages of each type of partitioning.\n- Decoupled keys, co-partitioned tables, and co-located partitions\n- Lab exercise: Creating range and hash partitioned tables with mxci or NSM\/web\n\n\nModule 7: Creating SQL\/MX Triggers \n\n\n- Trigger terminology\n- Creating BEFORE and AFTER triggers\n- Cascading and conflicting triggers\n- Lab exercise: Creating SQL\/MX Triggers\nModule 8: SQL\/MX Security\n\n\n- Object ownership and security rules\n- Object Privileges\n- Use of Security Administrator\u2019s Group\n- Change object ownership\n- SQL\/MX GRANT and REVOKE commands\n- Lab exercise: Granting and Revoking Privileges with mxci or NSM\/web\nModule 9: Import and Populate Index Utilities\n\n\n\n- Importing fixed and delimited data with the import utility\n- Importing data in parallel\n- Populating (loading) indexes\n- Lab exercise: Importing Data into Range and Hash Partitioned Tables and Indexes\nModule 10: Reorganizing SQL\/MX Tables and Indexes \n\n\n- Reorganizing data\n- Determining file fragmentation\n- FUP RELOAD and INFO commands\n- Lab exercise: Reorganizing Data\nModule 11: Updating Statistics \n\n\n- Histogram Statistics and histogram metadata tables\n- Generating single column and multicolumn statistics\n- Using sampling with the update statistics utility\n- Lab exercise: Updating and Viewing Statistics\nModule 12: Database Protection and Recovery with TMF \n\n\n- TMF Protection and Recovery Strategies\n- MXGNAMES Utility\n- Performing Online Dumps\n- Recovering dropped SQL\/MX Objects\n- Lab exercise: SQL\/MX Protection and Recovery Using TMF\nModule 13: Compiling SQL\/MX Programs in the OSS Environment \n\n\n- Compiling SQL\/MX Programs!Preprocessing source files for SQL\/MX\n- Language compiling SQL\/MX annotated source files\n- SQL\/MX compiling module definition files\n- Global or local module files\n- Defining search paths for module files\n- Lab exercise: Compiling Embedded SQL\/MX C or COBOL Programs in the OSS environment\nModule 14: PURGEDATA Command and MODIFY Utility \n\n\n- Purging data from range and hash partitioned tables\n- Adding, splitting, merging, and dropping range partitions\n- Adding and dropping hash partitions\n- Lab exercise: PURGEDATA Command and MODIFY Utility\nModule 15: SQL\/MX Utilities \n\n\n- DUP tables, indexes, and constraints\n- RECOVER utility\n- mxtool (INFO, VERIFY, FIXUP, and GOAWAY) utility\n- Lab exercise: SQL\/MX Utilities\nModule 16: NonStop MXDM \n\n\n- Features and requirements of MXDM\n- Installing and uninstalling\n- Example screens\nModule 17: Managing SQL\/MX Applications \n\n\n- Name references in programs\n- Compile time and late name resolution\n- Similarity checking\n- Automatic recompilation\n- Methods for moving SQL\/MX applications\n- Lab exercise: Managing Embedded SQL\/MX Programs\nModule 18: SQL\/MX Distributed Databases\n\n\n\n- Distributed databases\n- Transparency, visibility, and availability\n- ANSI name translation for local and remote objects\n- REGISTER and UNREGISTER CATALOG commands\n- Lab exercise: SQL\/MX Distributed Database Demonstration\nModule 19: Adding, Altering, and Dropping SQL\/MX Objects\n\n\n\n- Authorization for adding, altering, and dropping SQL\/MX objects\n- Adding SQL\/MX objects\n- Altering SQL\/MX objects\n- Dropping SQL\/MX objects\n- Lab exercise: Altering and dropping SQL\/MX objects\nModule 20: Open Source Tools \n\n\n- Overview of open source tools available for SQL\/MX usage\n- Describe usage of Eclipse to access SQL.MX\n- Overview of use of DBVisualizer to access SQL\/MX","summary_plain":"This course introduces tasks used by database administrators or system managers to manage and protect a NonStop SQL\/MX database and applications that access the database.","skill_level":"Beginner","version":"1.0","duration":{"unit":"d","value":5,"formatted":"5 days"},"pricelist":{"List Price":{"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":3750},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":4500},"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":3750}}},"lastchanged":"2025-07-29T12:18:23+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course-schedule\/33914","source_lang":"en","source":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course\/hewlettpackard-u8617s"}}