{"course":{"productid":33911,"modality":6,"active":true,"language":"de","title":"HPE NonStop SQL\/MX Basics","productcode":"U4184S","vendorcode":"HP","vendorname":"HP","fullproductcode":"HP-U4184S","courseware":{"has_ekit":false,"has_printkit":true,"language":""},"url":"https:\/\/portal.flane.ch\/course\/hewlettpackard-u4184s","objective":"<ul>\n<li>Describe relational database concepts and terminology<\/li><li>Describe the HPE NonStop SQL\/MX processes and objects<\/li><li>Use a mxci session and reference ANSI names for SQL\/MX database objects<\/li><li>Describe the basic process to write queries and the tools to evaluate the query performance<\/li><li>Use the mxci SELECT statement and predicates to retrieve data from single tables<\/li><li>List the types of functions supported in SQL\/MX<\/li><li>Retrieve data from multiple tables using joins and union operations &ndash; derived tables using Query Expression by using subqueries<\/li><li>Create a SQL\/MX database (Catalog, Schema, Tables, Indexes, Views, and Constraints)<\/li><li>Modify data in a table using SQL\/MX INSERT, UPDATE, and DELETE statements<\/li><li>Describe the SQL\/MX access options and isolation levels<\/li><li>Describe SQL\/MX database management functions<\/li><\/ul><h5>Upon completion of this course, you will:<\/h5><ul>\n<li>Understand key relational database concepts and terminology<\/li><li>Be able to use mxci commands to create SQL\/MX objects<\/li><li>Be able to use SQL statements to retrieve or modify data in SQL\/MX tables<\/li><\/ul>","essentials":"<ul>\n<li>Concepts and Facilities course (U4147S)<\/li><\/ul>","audience":"<ul>\n<li>Anyone requiring an introduction to SQL and working with the HPE NonStop SQL\/MX product<\/li><\/ul>","outline":"<h5>Module 1: Introduction to SQL Relational Databases <\/h5><ul>\n<li>Definition of a relational database<\/li><li>Components of a relational database table<\/li><li>Forming relationships in a relational database<\/li><li>Types of relationships<\/li><li>Description of Structured Query Language: Data Definition Language, Data Manipulation Language, Data Control Language, and Transaction Control Language<\/li><li>Characteristics of a Relational Database Management System (RDBMS)<\/li><li>Lab exercise<\/li><\/ul><h5>Module: 2 Overview of SQL\/MX Architecture<\/h5>\n<ul>\n<li>SQL\/MX Architecture<\/li><li>SQL\/MX System Metadata<\/li><li>User Metadata (UMD) Tables<\/li><li>User Catalog and Schemas<\/li><li>SQL\/MX User Tables, Objects, Tables, Indexes, Views, Constraints, Triggers, Object Namespaces-Object Type, Security Model, Process Architecture, Components, Catalog Manager, DDL Operations, Utilities<\/li><li>NSM\/web Architecture<\/li><li>Lab exercise<\/li><\/ul><h5>Module: 3 Introduction to mxci <\/h5><ul>\n<li>SQL\/MX Help Facilities<\/li><li>Starting an mxci session<\/li><li>mxci Prompts and Termination Character<\/li><li>SQL\/MX Identifiers<\/li><li>Logical (ANSI) Names<\/li><li>Specifying ANSI<\/li><li>Using Logical Names in an mxci Session<\/li><li>mxci: &ndash;SET NAMETYPE Command (ANSI) &ndash;SET CATALOG Command &ndash;SET SCHEMA Command<\/li><li>mxci cd Command, Is Commands<\/li><li>mxci&mdash;LOG Command<\/li><li>Lab exercise<\/li><\/ul><h5>Module: 4 Query Writing Process <\/h5><ul>\n<li>Overview of query execution<\/li><li>Overview of query development process<\/li><li>Analyzing the query objective, Generating the query, Executing the query<\/li><li>Verifying the results, Assessing performance<\/li><li>Lab exercise<\/li><\/ul><h5>Module: 5 Retrieving Data from a Single Table <\/h5><ul>\n<li>Data Types, Character Data Types, Numeric Data Types-Exact and Approximate, Datetime Data Types, Interval Data Types<\/li><li>INVOKE Command<\/li><li>SELECT Statement-Clauses, Syntax, Select List<\/li><li>SELECT-Select List, ALL or DISTINCT Rows, [ANY N] or [FIRST N]<\/li><li>FROM and WHERE Clause<\/li><li>Predicates<\/li><li>Row-Value-Constructor<\/li><li>Comparison Predicates-Syntax, Examples<\/li><li>LIKE, BETWEEN, and IN Predicates<\/li><li>Boolean Operators and Compound Predicates<\/li><li>NULL Values<\/li><li>IS [NOT] Predicate<\/li><li>ORDER BY, GROUP By, HAVING Clause<\/li><li>Lab exercise<\/li><\/ul><h5>Module: 6 Functions and Expressions <\/h5><ul>\n<li>Aggregate functions<\/li><li>Character functions<\/li><li>Datetime functions<\/li><li>Mathematical functions<\/li><li>Types of expressions<\/li><li>Literal expressions<\/li><li>Numeric expressions<\/li><li>Lab exercise<\/li><\/ul>\n<h5>Module: 7 Retrieving Data from Multiple Tables<\/h5>\n<ul>\n<li>Generating the following types of joins: CROSS, NATURAL, INNER, EQUI, LEFT, RIGHT, Self<\/li><li>Correlation Names<\/li><li>Join with Additional Search Conditions<\/li><li>UNION Operation<\/li><li>Lab exercise<\/li><\/ul><h5>Module: 8 Query Expressions <\/h5><ul>\n<li>Query expression: Definition, Types, Joined Table, Syntax<\/li><li>Non-Joined Query Expression Table: VALUES Statement, TABLE Statement, SELECT Query Specification<\/li><li>Simple Table&mdash;SELECT expression<\/li><li>Subquery: Definition, Non-Correlated, Correlated, Evaluation of a Correlated Subquery, Classification, SELECT Form of a subquery<\/li><li>Predicates: Subquery, Comparison, BETWEEN, IN, and EXISTS, and EXISTS Examples<\/li><li>Subqueries using the Comparison, BETWEEN, and IN Predicates<\/li><li>Subquery key points<\/li><li>Lab exercise<\/li><\/ul>\n<h5>Module: 9 Creating SQL\/MX Objects <\/h5><ul>\n<li>Creating SQL\/MX Objects<\/li><li>SQL\/MX Object Naming<\/li><li>CREATE CATALOG Command&mdash;Syntax, REGISTER CATALOG Command&mdash;Syntax, UNREGISTER CATALOG Command&mdash;Syntax, Catalog Considerations<\/li><li>CREATE SCHEMA Command&mdash;Syntax<\/li><li>Rules for Naming SQL\/MX Schema Subvolumes, Schema Considerations, Creating a User Schema<\/li><li>Creating a SQL\/MX Table&mdash;Topics<\/li><li>Column Definitions, Column Name Rules, Character Sets, Default Value, ISO88591 Character Set Examples<\/li><li>SYSTEM_DEFAULTS Table&mdash; NOT_NULL_CONSTRAINT_DROPPABLE_OPTION<\/li><li>Constraints, Constraints Names, Table Constraints<\/li><li>Specifying Physical Location and Name for the Underlying Guardian File<\/li><li>Specifying a Clustering Key, Specifying a Clustering Key&mdash;STORE BY Clause, Terminology<\/li><li>Clustering Key&mdash;No STORE BY Clause and No Primary Key Specified, Clustering Key&mdash;STORE BY PRIMARY KEY: Primary Key Specified As DROPPABLE<\/li><li>Specifying Guardian File Attributes<\/li><li>CREATE INDEX&mdash;Syntax, CREATE VIEW&mdash;Syntax, CREATE VIEW&mdash;Example, Considerations for Creating a View<\/li><li>Lab exercise<\/li><\/ul>\n<h5>Module: 10 Inserting Data and Updating Statistics <\/h5><ul>\n<li>Methods for Loading Multiple Rows of Data<\/li><li>Inserting Data into the Database, INSERT Statement&mdash;Syntax, Inserting a Single Row, Inserting Multiple Rows, INSERT Considerations<\/li><li>SQL\/MX Histogram Statistics, Statistics Tables, mxci UPDATE STATISTICS Utility, Examples of mxci UPDATE STATISTICS<\/li><li>Lab exercise<\/li><\/ul><h5>Module: 11 Modifying Data <\/h5><ul>\n<li>Maintaining Database Consistency<\/li><li>Transaction Management Statements<\/li><li>Explicit Transaction: User-Defined Transaction, INSERT, UPDATE, DELETE<\/li><li>Implicit Transaction: System-Defined Transactions, SELECT, INSERT, UPDATE, DELETE<\/li><li>Modifying Existing Data<\/li><li>UPDATE Statement&mdash;Syntax, Updating a Single Row, Updating Multiple Rows, UPDATE Statement&mdash;Scalar Subquery, UPDATE Considerations<\/li><li>Removing Data from the Database<\/li><li>DELETE Statement&mdash;Syntax, Deleting Data, DELETE Considerations<\/li><li>Lab exercise<\/li><\/ul><h5>Module: 12 Access Options and Isolation Levels <\/h5><ul>\n<li>Concurrency Control and Contention<\/li><li>Locking Considerations, Dirty Reads, Non-Repeatable Reads, Phantoms<\/li><li>Access Options and Isolation Levels, READ UNCOMMITTED Access Option, READ COMMITTED Access Option, READ COMMITTED Considerations, SERIALIZABLE or REPEATABLE READ Access Option<\/li><li>Lock Modes, Access Options and Lock Modes<\/li><li>SET TRANSACTION Statement, SET TRANSACTION Statement&mdash;Example, Transaction Isolation-Level Rules<\/li><li>DEADLOCK, Viewing Locks on a Table<\/li><li>Lab exercise<\/li><\/ul><h5>Module: 13 Management Functions<\/h5>\n<ul>\n<li>SQL\/MX Object Dependencies<\/li><li>SQL Authorization ID<\/li><li>Object Ownership and Security Rules<\/li><li>Granting Privileges to Users&mdash;Example<\/li><li>Altering SQL\/MX Objects in a SQL\/MX Database<\/li><li>Authorization Requirements for Altering Database Object<\/li><li>Altering TABLE or INDEX FILE Attributes, Adding Columns to a Table, Altering Considerations<\/li><li>Removing SQL\/MX Database Objects, Dropping SQL\/MX Objects From a SQL\/MX Database, Removing Your Database Objects<\/li><li>Managing Data<\/li><li>mxtool VERIFY Utility, mxtool VERIFY Utility&mdash;Security Considerations, mxtool VERIFY Utility&mdash;Syntax<\/li><li>Performance, Monitoring Performance<\/li><li>Using the EXPLAIN Function with a Prepared Query<\/li><li>EXPLAIN statement with OPTIONS &lsquo;f&rsquo;<\/li><li>NSM\/web Connectivity Services, Visual Query Planner DISPLAY STATISTICS<\/li><li>Lab exercise<\/li><\/ul>\n<h5>Module: 14 Advanced Topics <\/h5><ul>\n<li>Referential Integrity (RI)<\/li><li>Trigger Definition<\/li><li>Partitioning&mdash;Range Partitioning, Hash Partitioning<\/li><li>Publish and Subscribe Services<\/li><li>Rowsets<\/li><li>Compound Statements<\/li><li>SELECT statement&mdash;TRANSPOSE Clause, SAMPLE Clause<\/li><li>Sequence Function<\/li><\/ul>\n\n<h5>Module: 15 MXDM<\/h5>\n<ul>\n<li>Features and requirements of MXDM<\/li><li>Installing and Uninstalling MXDM<\/li><li>Example screens<\/li><\/ul>","summary":"<p>This course is an introduction to SQL, relational database principles, and the HPE NonStop SQL\/MX product and serves as a prerequisite to more advanced HPE NonStop SQL\/MX courses. Hands-on lab sessions provide practical experience with generating SQL\/MX queries to access data and creating database objects (catalogs, tables, indexes, views, and constraints).<\/p>","objective_plain":"- Describe relational database concepts and terminology\n- Describe the HPE NonStop SQL\/MX processes and objects\n- Use a mxci session and reference ANSI names for SQL\/MX database objects\n- Describe the basic process to write queries and the tools to evaluate the query performance\n- Use the mxci SELECT statement and predicates to retrieve data from single tables\n- List the types of functions supported in SQL\/MX\n- Retrieve data from multiple tables using joins and union operations \u2013 derived tables using Query Expression by using subqueries\n- Create a SQL\/MX database (Catalog, Schema, Tables, Indexes, Views, and Constraints)\n- Modify data in a table using SQL\/MX INSERT, UPDATE, and DELETE statements\n- Describe the SQL\/MX access options and isolation levels\n- Describe SQL\/MX database management functions\nUpon completion of this course, you will:\n\n\n- Understand key relational database concepts and terminology\n- Be able to use mxci commands to create SQL\/MX objects\n- Be able to use SQL statements to retrieve or modify data in SQL\/MX tables","essentials_plain":"- Concepts and Facilities course (U4147S)","audience_plain":"- Anyone requiring an introduction to SQL and working with the HPE NonStop SQL\/MX product","outline_plain":"Module 1: Introduction to SQL Relational Databases \n\n\n- Definition of a relational database\n- Components of a relational database table\n- Forming relationships in a relational database\n- Types of relationships\n- Description of Structured Query Language: Data Definition Language, Data Manipulation Language, Data Control Language, and Transaction Control Language\n- Characteristics of a Relational Database Management System (RDBMS)\n- Lab exercise\nModule: 2 Overview of SQL\/MX Architecture\n\n\n\n- SQL\/MX Architecture\n- SQL\/MX System Metadata\n- User Metadata (UMD) Tables\n- User Catalog and Schemas\n- SQL\/MX User Tables, Objects, Tables, Indexes, Views, Constraints, Triggers, Object Namespaces-Object Type, Security Model, Process Architecture, Components, Catalog Manager, DDL Operations, Utilities\n- NSM\/web Architecture\n- Lab exercise\nModule: 3 Introduction to mxci \n\n\n- SQL\/MX Help Facilities\n- Starting an mxci session\n- mxci Prompts and Termination Character\n- SQL\/MX Identifiers\n- Logical (ANSI) Names\n- Specifying ANSI\n- Using Logical Names in an mxci Session\n- mxci: \u2013SET NAMETYPE Command (ANSI) \u2013SET CATALOG Command \u2013SET SCHEMA Command\n- mxci cd Command, Is Commands\n- mxci\u2014LOG Command\n- Lab exercise\nModule: 4 Query Writing Process \n\n\n- Overview of query execution\n- Overview of query development process\n- Analyzing the query objective, Generating the query, Executing the query\n- Verifying the results, Assessing performance\n- Lab exercise\nModule: 5 Retrieving Data from a Single Table \n\n\n- Data Types, Character Data Types, Numeric Data Types-Exact and Approximate, Datetime Data Types, Interval Data Types\n- INVOKE Command\n- SELECT Statement-Clauses, Syntax, Select List\n- SELECT-Select List, ALL or DISTINCT Rows, [ANY N] or [FIRST N]\n- FROM and WHERE Clause\n- Predicates\n- Row-Value-Constructor\n- Comparison Predicates-Syntax, Examples\n- LIKE, BETWEEN, and IN Predicates\n- Boolean Operators and Compound Predicates\n- NULL Values\n- IS [NOT] Predicate\n- ORDER BY, GROUP By, HAVING Clause\n- Lab exercise\nModule: 6 Functions and Expressions \n\n\n- Aggregate functions\n- Character functions\n- Datetime functions\n- Mathematical functions\n- Types of expressions\n- Literal expressions\n- Numeric expressions\n- Lab exercise\n\nModule: 7 Retrieving Data from Multiple Tables\n\n\n\n- Generating the following types of joins: CROSS, NATURAL, INNER, EQUI, LEFT, RIGHT, Self\n- Correlation Names\n- Join with Additional Search Conditions\n- UNION Operation\n- Lab exercise\nModule: 8 Query Expressions \n\n\n- Query expression: Definition, Types, Joined Table, Syntax\n- Non-Joined Query Expression Table: VALUES Statement, TABLE Statement, SELECT Query Specification\n- Simple Table\u2014SELECT expression\n- Subquery: Definition, Non-Correlated, Correlated, Evaluation of a Correlated Subquery, Classification, SELECT Form of a subquery\n- Predicates: Subquery, Comparison, BETWEEN, IN, and EXISTS, and EXISTS Examples\n- Subqueries using the Comparison, BETWEEN, and IN Predicates\n- Subquery key points\n- Lab exercise\n\nModule: 9 Creating SQL\/MX Objects \n\n\n- Creating SQL\/MX Objects\n- SQL\/MX Object Naming\n- CREATE CATALOG Command\u2014Syntax, REGISTER CATALOG Command\u2014Syntax, UNREGISTER CATALOG Command\u2014Syntax, Catalog Considerations\n- CREATE SCHEMA Command\u2014Syntax\n- Rules for Naming SQL\/MX Schema Subvolumes, Schema Considerations, Creating a User Schema\n- Creating a SQL\/MX Table\u2014Topics\n- Column Definitions, Column Name Rules, Character Sets, Default Value, ISO88591 Character Set Examples\n- SYSTEM_DEFAULTS Table\u2014 NOT_NULL_CONSTRAINT_DROPPABLE_OPTION\n- Constraints, Constraints Names, Table Constraints\n- Specifying Physical Location and Name for the Underlying Guardian File\n- Specifying a Clustering Key, Specifying a Clustering Key\u2014STORE BY Clause, Terminology\n- Clustering Key\u2014No STORE BY Clause and No Primary Key Specified, Clustering Key\u2014STORE BY PRIMARY KEY: Primary Key Specified As DROPPABLE\n- Specifying Guardian File Attributes\n- CREATE INDEX\u2014Syntax, CREATE VIEW\u2014Syntax, CREATE VIEW\u2014Example, Considerations for Creating a View\n- Lab exercise\n\nModule: 10 Inserting Data and Updating Statistics \n\n\n- Methods for Loading Multiple Rows of Data\n- Inserting Data into the Database, INSERT Statement\u2014Syntax, Inserting a Single Row, Inserting Multiple Rows, INSERT Considerations\n- SQL\/MX Histogram Statistics, Statistics Tables, mxci UPDATE STATISTICS Utility, Examples of mxci UPDATE STATISTICS\n- Lab exercise\nModule: 11 Modifying Data \n\n\n- Maintaining Database Consistency\n- Transaction Management Statements\n- Explicit Transaction: User-Defined Transaction, INSERT, UPDATE, DELETE\n- Implicit Transaction: System-Defined Transactions, SELECT, INSERT, UPDATE, DELETE\n- Modifying Existing Data\n- UPDATE Statement\u2014Syntax, Updating a Single Row, Updating Multiple Rows, UPDATE Statement\u2014Scalar Subquery, UPDATE Considerations\n- Removing Data from the Database\n- DELETE Statement\u2014Syntax, Deleting Data, DELETE Considerations\n- Lab exercise\nModule: 12 Access Options and Isolation Levels \n\n\n- Concurrency Control and Contention\n- Locking Considerations, Dirty Reads, Non-Repeatable Reads, Phantoms\n- Access Options and Isolation Levels, READ UNCOMMITTED Access Option, READ COMMITTED Access Option, READ COMMITTED Considerations, SERIALIZABLE or REPEATABLE READ Access Option\n- Lock Modes, Access Options and Lock Modes\n- SET TRANSACTION Statement, SET TRANSACTION Statement\u2014Example, Transaction Isolation-Level Rules\n- DEADLOCK, Viewing Locks on a Table\n- Lab exercise\nModule: 13 Management Functions\n\n\n\n- SQL\/MX Object Dependencies\n- SQL Authorization ID\n- Object Ownership and Security Rules\n- Granting Privileges to Users\u2014Example\n- Altering SQL\/MX Objects in a SQL\/MX Database\n- Authorization Requirements for Altering Database Object\n- Altering TABLE or INDEX FILE Attributes, Adding Columns to a Table, Altering Considerations\n- Removing SQL\/MX Database Objects, Dropping SQL\/MX Objects From a SQL\/MX Database, Removing Your Database Objects\n- Managing Data\n- mxtool VERIFY Utility, mxtool VERIFY Utility\u2014Security Considerations, mxtool VERIFY Utility\u2014Syntax\n- Performance, Monitoring Performance\n- Using the EXPLAIN Function with a Prepared Query\n- EXPLAIN statement with OPTIONS \u2018f\u2019\n- NSM\/web Connectivity Services, Visual Query Planner DISPLAY STATISTICS\n- Lab exercise\n\nModule: 14 Advanced Topics \n\n\n- Referential Integrity (RI)\n- Trigger Definition\n- Partitioning\u2014Range Partitioning, Hash Partitioning\n- Publish and Subscribe Services\n- Rowsets\n- Compound Statements\n- SELECT statement\u2014TRANSPOSE Clause, SAMPLE Clause\n- Sequence Function\n\n\nModule: 15 MXDM\n\n\n\n- Features and requirements of MXDM\n- Installing and Uninstalling MXDM\n- Example screens","summary_plain":"This course is an introduction to SQL, relational database principles, and the HPE NonStop SQL\/MX product and serves as a prerequisite to more advanced HPE NonStop SQL\/MX courses. Hands-on lab sessions provide practical experience with generating SQL\/MX queries to access data and creating database objects (catalogs, tables, indexes, views, and constraints).","skill_level":"Beginner","version":"1.0","duration":{"unit":"d","value":5,"formatted":"5 Tage"},"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\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/json-course-schedule\/33911","source_lang":"de","source":"https:\/\/portal.flane.ch\/swisscom\/json-course\/hewlettpackard-u4184s"}}