Module 1: Overview of SQL/MX Architecture

• SQL/MX logical structure, catalogs, schemas, and objects
• SQL/MX physical structure: SMD volumes, schema subvolumes, data forks and resource forks
• SQL/MX processes and utilities
• Identify the system catalog, schemas, and objects
• Identify user catalogs, schemas, and objects
• Locate the underlying files for SQL/MX objects
• Metadata basics

Lab

• Overview of SQL/MX Architecture

Module 2: SQL/MX Installation

• Hardware and software requirements for installing SQL/MX
• Installing SQL/MX with the InstallSqlmx utility
• Verifying the SQL/MX Installation
• Create the SQL/MX sample database

Lab

• Perform a post-installation check for SQL/MXs

Module 3: Metadata Migration to SQL/MX R3.0

• Migrating considerations
• Post upgrade scenarios
• FIXRCB operation
• UPGRADE utility

Module 4: Creating SQL/MX Objects

• Creating catalogs, schemas, tables, constraints, indexes, and views
• Viewing object metadata

Lab

• Creating SQL/MX Objects with mxci or NSM/web

Module 5: Referential Integrity Constraints

Module 6: Creating SQL/MX Partitioned Tables and Indexes

• Range and hash partitioned tables
• Creating range and hash partitioned tables and indexes
• Advantages and Disadvantages of each type of partitioning.
• Decoupled keys, co-partitioned tables, and co-located partitions

Lab

• Creating range and hash partitioned tables with mxci or NSM/web

Module 7: Creating SQL/MX Triggers

• Trigger terminology
• Creating BEFORE and AFTER triggers
• Cascading and conflicting triggers

Lab

• Creating SQL/MX Triggers

Module 8: SQL/MX Security

• Object ownership and security rules
• Object Privileges
• Use of Security Administrator’s Group
• Change object ownership
• SQL/MX GRANT and REVOKE commands

Lab

• Granting and Revoking Privileges with mxci or NSM/web

Module 9: Import and Populate Index Utilities

• Importing fixed and delimited data with the import utility
• Importing data in parallel
• Populating (loading) indexes

Lab

• Importing Data into Range and Hash Partitioned Tables and Indexes

Module 10: Reorganizing SQL/MX Tables and Indexes

• Reorganizing data
• Determining file fragmentation
• FUP RELOAD and INFO commands

Lab

• Reorganizing Data

Module 11: Updating Statistics

• Histogram Statistics and histogram metadata tables
• Generating single column and multicolumn statistics
• Using sampling with the update statistics utility

Lab

• Updating and Viewing Statistics

Module 12: Database Protection and Recovery with TMF

• TMF Protection and Recovery Strategies
• MXGNAMES Utility
• Performing Online Dumps
• Recovering dropped SQL/MX Objects

Lab

• SQL/MX Protection and Recovery Using TMF

Module 13: Compiling SQL/MX Programs in the OSS Environment

• Compiling SQL/MX Programs!Preprocessing source files for SQL/MX
• Language compiling SQL/MX annotated source files
• SQL/MX compiling module definition files
• Global or local module files
• Defining search paths for module files

Lab

• Compiling Embedded SQL/MX C or COBOL Programs in the OSS environment

Module 14: PURGEDATA Command and MODIFY Utility

• Purging data from range and hash partitioned tables
• Adding, splitting, merging, and dropping range partitions
• Adding and dropping hash partitions

Lab

• PURGEDATA Command and MODIFY Utility

Module 15: SQL/MX Utilities

• DUP tables, indexes, and constraints
• RECOVER utility
• mxtool (INFO, VERIFY, FIXUP, and GOAWAY) utility

Lab

• SQL/MX Utilities

Module 16: HPE Nonstop MXDM

• Features and requirements of MXDM
• Installing and uninstalling
• Example screens

Module 17: Managing SQL/MX Applications

• Name references in programs
• Compile time and late name resolution
• Similarity checking
• Automatic recompilation
• Methods for moving SQL/MX applications

Lab

• Managing Embedded SQL/MX Programs

Module 18: SQL/MX Distributed Databases

• Distributed databases
• Transparency, visibility, and availability
• ANSI name translation for local and remote objects
• REGISTER and UNREGISTER CATALOG commands

Lab

• SQL/MX Distributed Database Demonstration

Module 19: Adding, Altering, and Dropping SQL/MX Objects

• Authorization for adding, altering, and dropping SQL/MX objects
• Adding SQL/MX objects
• Altering SQL/MX objects
• Dropping SQL/MX objects

Lab

• SQL/MX Distributed Database Demonstration

Module 20: Open Source Tools

• Overview of open source tools available for SQL/MX usage
• Describe usage of Eclipse to access SQL.MX
• Overview of use of DBVisualizer to access SQL/MX