This course is based on SQL/MX release 2.0 (G06.23) and addresses both SQL/MP tables and SQL/MX tables. It describes the facilities available in OSS, in Guardian, and on a client PC to produce SQL/MX programs. The course includes sections on data mining and publish-subscribe. It deals with the various interfaces between Java and SQL/MX, including JDBC Type 2 and Type 4 drivers.
This course also addresses the performance aspects of SQL/MX programming.
This two-day course includes 25 scripts. These are run from the OSS (UNIX-like) environment, where SQL/MX is based. The scripts permit the user to display object names, object versions, and security settings without writing metadata queries.
Extensive hands-on labs will anchor the student's classroom learning.
Course Duration: 2 days
NonStop SQL programmers who are new to SQL/MX, as well as programmers in other SQL environments who are new to NonStop systems and any others who need a solid overview of SQL/MX programming topics..
SQL/MX Programming Environment
SQL/MX and SQL/MP DML Comparison
SQL/MX ANSI Compliance
SQL/MX Language Elements
DML Statements
Data Mining
Data Mining and comparison to OLAP
Transpose, Sample, Sequence functions
Publish/Subscribe concepts and triggers
Program Development
OSH and Windows-based preprocessors
Embedding SQL/MX in Java
SQL/MX Limits
JDBC/MX and Type 4 JDBC Driver
Performance factors and CONTROL statements
MDAM Performance advantages
The audience should have completed NonStop Features and Fundamentals (XI210) or be familiar with the Tandem NonStop environment, including the use of editors and general utilities. The student should have a programming background and be familiar with SQL syntax and relational database concepts. No knowledge of ANSI standards, SQL/MP, OSS, or UNIX is presumed
E-mail:
Phone:
Fax:
Cell/Pager:
Mail: |
sales@xid.com
+1 817-540-0200 x33
+1
817-545-4960
+1 817-247-7587
1001 W. Euless Blvd.
Suite
200
Euless, TX 76040
USA | |
Module 1 - NonStop SQL/MX Programming Environment
o DML comparison between SQL/MX and SQL/MP
o Using SQL/MP tables in SQL/MX
o SQL/MX compliance with ANSI standards
o OSS-, Guardian-, and PC-based tools
o Loading external data
o The SQL/MX compiler and how to influence it
o Multi-dimensional access method (MDAM)
o Data access options
Module 2 - Language Elements
o Character sets
o Collations
o Data types
o Expressions
o Functions
o Literals
o Predicates
Module 3 - DML Statements
o SELECT statement - MXCI and embedded
o INSERT statement - MXCI and embedded
o UPDATE statement - MXCI and embedded
o DELETE statement - MXCI and embedded
o Access and exclusion modes; locking
o Cursors vs. rowsets
Module 4 - Data Mining
o Data mining vs. OLAP
o SQL/MX support for data mining
o SELECT options: Transpose, Sample, Sequence By
o Sequence functions
o Lab 1: Data mining features
Module 5 - Publish/Subscribe
o Enscribe queue files
o Publish-subscribe concepts
o Publish-subscribe vs. triggers
o Basic stream access
o Stream timeout
o Embedded update/delete
o After Last Row access
o Lab 2: Publish-subscribe features
Module 6 - Program Development
o Compiling an SQL/MX program
o Module placement and naming
o Autorecompilation settings
o OSH- and Windows-based preprocessors
o Running the SQL/MX compiler (mxcmp)
o DISPLAY USE OF command
o Building Guardian-based programs
o Embedded SQL/MX statements in Java (SQLJ)
o Stored Procedures in Java (SPJ)
o SQL/MX limits
o Enterprise Tool Kit (ETK)
o Lab 3: Program development
Module 7 - JDBC/MX anf the JDBC Type-4 Driver
o ODBC and JDBC access to SQL data on NonStop
o Java on Nonstop
o JDBC/MX (Type 2 Driver) - architecture and features
o Type 4 JDBC Driver - architecture and features
Module 8 - Performance
o Compile-time factors
o MDAM performance advantages
o Displaying query statistics and execution plans
o Query plan caching
o Java application profiling (hprof utility)
o System default settings
o Modifying the system defaults table
o CONTROL statements
o UPDATE STATISTICS statement
o Lab 4: Performance
|
