This course is a complete introduction to the NonStop SQL/MP product and how to embed SQL/MP statements into COBOL85 servers.
The course combines the functions of an introduction to SQL/MP and embedding SQL/MP into servers into a concise 5-day course.
The student will learn how to use SQL/MP to meet the practical needs of todays organizations, how to list, modify and delete database items; and how to define and create databases. The student will become strongly versed in the aspects of embedding SQL/MP into the server, how to code dynamic SQL statements, and how to use timestamp and interval data types.
Eight extensive hands-on labs will reinforce and anchor the student's classroom learning.
Course Duration: 5 days
Application Programmers and Analysts, who need to learn how to create databases, develop and execute queries, use Report Writer, and are able to competently add queries to their programs.
Describe a relational database including the various entities associated with this type of database.
Describe the NonStop architecture as it pertains to a relational database.
List the steps to create a relational database.
Use Report Writer to format query output.
Format, List, Modify, and Delete the desired data items within a relational database.
Embed all forms of SQL/MP statements into server code.
This course includes eight comprehensive and instructional lab exercises.
Ability to LOGON and LOGOFF a Tandem NonStop system.
Use standard utilities (EDIT/TEDIT, FUP, PERUSE), and basic TACL commands for a user session.
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 - Relational Database Concepts
o Database Beginnings
o Database Terms
o Database Access
o Queries and Reports
o Catalogs
Module 2 - NonStop SQL/MP Architecture
o NonStop System Features
o Interface to SQL/MP
o Optimizer, Compiler, and Executor functions
o Parallel Activity
o Data Protection
o SQL/MP Lab
Module 3 - Simple Database Queries
o Source for the Query
o Restrictions
o Query Formats
o Basic Query Lab
Module 4 - More Complex Database Queries
o Multiple Tables
o Joins and Unions
o Subqueries
o Join, Union and Subquery Lab
Module 5 - Views
o Protection Views
o Shorthand Views
o Views Lab
Module 6 - Report Writer
o Select Statement Impact
o Style and Layout Topics
o Clauses
o Functions
o Report Writer Lab
Module 7 - Concepts of Embedding SQL/MP into Programs
o Compilation Environment
o SQLCOMP Utility and Parameters
o Defines Names and Define Name Resolution
o Use of EXEC SQL and END-EXEC
o Definitions and Host Variables
o INVOKE Directives
o Different SQL Statement Types
o Embedding Basic SQL Statements Lab
Module 8 - Basic Embedded SQL Statements
o Standalone and Single Select Statements
o Set Processing Concerns
o Embedding SELECT, UPDATE and DELETE statements
o Alternate Index Positioning, Context Free Positioning
o NULL Values and NULL-allowed column handling
o Locking Concepts, Locking and Error Handling
o Basic SQL Statements Lab
Module 9 - Advanced Embedded SQL Statements
o Defining and Using Cursors
o Date and Time Variables in SQL/MP
o Handling INTERVAL Datatypes and Time Intervals
o Dynamic SQL, EXECUTE and EXECUTE IMMEDIATE differences
o Use of LIKE with Host Variables
o Advanced SQL Statements Lab
|
