XS203 - NonStop SQL/MP™ Management
DESCRIPTION
This course is an excellent and complete introduction managing the NonStop SQL/MP™ product. The student will learn how to manage the SQL/MP™ database arena to meet the practical needs of today’s organizations. A NonStop SQL/MP database administrator or a NonStop system manager will learn various topics that can ensure the correct configuration and management of a NonStop SQL/MP database The student will also gain a much deeper understanding of database performance and management issues.

Extensive hands-on labs will anchor the student's classroom learning.

Course Duration: 5 days (on-site)

WHO SHOULD ATTEND
Those DBAs and System Managers who need to learn how to create and configure databases, manage, tune and reorganize databases and their environments, and understand the performance and management implications of their work.

PROGRAM HIGHLIGHTS
  • Describe and create relational databases
  • Describe the NonStop architecture as it pertains to a relational database.
  • Installation Requirements, operating under multiple versions, version control.
  • Creating, altering, deleting, renaming and backup/restoring DB objects
  • Loading, reorganizing and converting Data
  • Program compilation, recompilation, and validity
  • Database security and performance
  • Licensing, Format1 and Format2 partitioning
  • This course includes many comprehensive and instructional lab exercises.

PREREQUISITES
  • Minimum of 2 years operational experience on Tandem NonStop systems.
  • Minimum 2 years hands-on experience with NonStop SQL/MP Databases.
QUESTIONS/COMMENTS?
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
COURSE DETAILS
  • Module 1 - Relational Database Concepts
    • What makes up a Database?
    • Database Terms, Processes, Access
    • Database Catalogs, Structures and Relationships
    • Database Interfaces
  • Module 2 - Installations and Version Management
    • SQL/MP Installation Requirements
    • Verifying Version Information
    • Upgrading and Downgrading Versions
    • Supporting Mixed Versions
  • Module 3 - NonStop SQL/MP Database Objects
    • Creating, Altering and Moving Objects
    • Renaming and Deleting Objects
    • Backing Up and Restoring Objects
  • Module 4 - Working With NonStop SQL/MP Databases
    • Loading, Copying and Appending Data
    • Reorganizing and Converting Data
    • Moving Databases
    • DataLoader/MP
  • Module 5 - NonStop SQL/MP Programs (Embedded SQL)
    • Program Validity, Compilation and Recompilation
    • Name Resolution
    • Compilation Options
    • DEFINEs
    • Manipulating and Moving Programs
    • NonStop Transaction Services/MP (TS/MP) Requirements
    • Various Languages
  • Module 6 - Database Protection and Recovery
    • Security
    • TMF Considerations
    • Backup Strategies
    • Restoring Databases and Individual Objects
    • Recovery from Error Situations and Damanged Objects
  • Module 7 - Database Security
    • Security Guidelines
    • Authorization Requirements
    • Safeguard Security Product
  • Module 8 - Database Performance Concerns
    • Statistics and Tools (SQLCI, Measure, TPDC)
    • DP2 and Partitions
    • Sorts
    • Processes
    • Performance Considerations
  • Module 9 - Database Management Concerns
    • Licensing SQLCI2
    • Removing SQL/MP from a node
    • Partitions (Format 1 and 2)
    • SQLCI Utilities
    • System Utilities

©2003-2004 XID, LTD.
  All rights reserved.