Course Number: TT415

Description:

This course teaches the new SQL option of the CA-IDMS/DB Release 14.0. Course identifies steps to create a relational database under CA-IDMS. Reviews the CA-IDMS extensions to SQL. Refers to both immediately and embedded SQL syntax. Discusses CA-IDMS tools that have been enhanced to support SQL.

Topics of discussion include:

• Introduction to CA-IDMS SQL Option
• Defining a database using SQL
• Administering a database defined with SQL
• Embedding SQL in a program
• Optimization and Access Modules
• Accessing a Non-SQL defined database with SQL
• CA-IDMS Tools support for SQL access

Duration:

2 days

Prerequisites:

Introduction to SQL (TT410) or an understanding of SQL and relational database concepts.

Target Audience:

Database administrators or the persons responsible for implementing and supporting the

CA-IDMS/SQL option

Objectives:

Upon completion of this course, student will be able to:

• Describe the features of the CA-IDMS/SQL option
• Identify the steps to define a database defined with CA-IDMS/DB SQL
• Identify database administration procedures, including security and tuning options, for a
• database defined with CA-IDMS/DB SQL
• Explain how to access the database using SQL DML
• Identify procedures for embedding SQL statements in an application program
• Describe the function of an access module and how the optimizer creates an access strategy
• Explain how to use SQL DML to access a non-SQL defined database
• Describe the SQL functionality supported by CA-IDMS tools