Faites confiance à votre formation en TI |

Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

IBM Optim Core Technology for Distributed Systems (DT292)

Catégorie: Formation

Information Management

Format: Formation en classe avec formateur

Autres formats:

This course replaces Implementing Optim Core Technology Workshop for Distributed Systems (DT291). This is the Classroom version of Instructor-Led Online course IBM Optim Core Technology for Distributed Systems - Instructor Led Online (3T292).

This course combines the material of Optim Data Growth for Distributed Systems (DT201) with Optim Data Privacy for Distributed Systems (DT211), and eliminates any material from DT211 taught on Days 4 and 5 that was already covered in DT201 in Days 1 through 3. Thus, anyone taking just DT201 would leave at the end of Day 3. The optional Unit on Data Security (Unit 28) can be taught after Unit 21 on Day 3, or later in the course in the numerical sequence presented in the materials.

IBM Optim Data Growth for Open Systems is designed to provide technical end-users and DBAs with a foundation in the functionality basics of the Optim solution. This course provides both a conceptual understanding of data growth as well as the Optim solution's capabilities for managing data growth and improving the performance of critical business applications. This course serves as a foundation for the Optim solution's business value, features, and functionality.

DT201 focuses on the technical aspects of the Optim solution and is intended for technical audiences. Participants will install and configure Optim and experience a breadth of Optim core functionality. Students will use Optim technology, working through hands-on practice and how to apply the technology to business scenarios.

This course prepares technical users with the Optim knowledge and skills necessary to participate in an Optim implementation project and confidently perform Optim tasks ongoing. During the course, students will participate in both instructor-led, hands-on labs and self-paced labs which apply business scenarios.

This course is designed to introduce the attendee to IBM Optim and to Optim's capabilities in helping clients to manage data growth. Data management basic concepts, functionality and GUI used to implement test data management. Students will use Optim Archive, Optim Delete, Optim Browse, Optim Insert, and ODM to produce archived files and perform management activities. Students will examine scheduling and running processes from the command line. Students will also see how Optim can be used to work with tables in a cross-database environment. Hands-on exercises and checkpoint questions will be used to check the attendee's progress.

From DT211: Optim Data Privacy for Distributed Systems is a three-day course designed to provide technical users with a foundation in the functionality basics of the Optim Solution. This course provides both a conceptual understanding of data privacy as well as the Optim Solutionâ€™s capabilities for de-identifying data for privacy protection and supporting compliance initiatives for critical business applications. This course serves as a foundation for the Optim Solutionâ€™s business value, features, and functionality.

This course focuses on the technical aspects of the Optim Solution and is intended for technical audiences. The focus of the course is hands-on experience building relationally intact subsets of privatized data and creating Optim primary keys and Optim relationships which permit cross database extraction of data. Participants will learn the basics of how the technology works through hands-on practice and how to apply the technology to business scenarios, including installation and configuration.

This course prepares technical users with the Optim knowledge and skills necessary to participate in an Optim implementation project and confidently perform Optim tasks ongoing.

This course is designed to teach the attendee the IBM Optim Data Privacy Solution basic concepts, functionality and GUI used to implement a data privacy solution. Hands-on exercises and checkpoint questions will be used to check the attendeeâ€™s progress.




	Compétences acquises
	How data growth impacts mission critical applications How the Optim solution supports a data growth strategy How the Optim solution fits into the architectural landscape How to install Optim on both a workstation and server How the archiving process works and planning considerations How to set personal options How to define selection criteria How to define Optim relationships and primary keys How to archive data from a source database How to delete data from a source database How to restore data to a target database or storage device How to create table maps and column maps How to search and browse archived data How to implement Optim archive actions How to use custom exits How to retry or restart an Optim process How to schedule an Optim process How to create collections of archived data How to access archived data through the Open Data Manager (ODM) Discuss how data privacy concerns impact mission critical applications Discuss how the Optim Solution supports a data privacy strategy Describe how the Optim Solution fits into the architectural landscape Choose the appropriate transformation technique Describe how the Optim Extract process works and how it differs from Archiving Use Optim to create new tables and load those tables with data Describe how to Convert process works Discuss how to use Optim Compare to compare Extracts of single and multiple tables of data with other Extracts or existing tables Describe to define Optim Relationships and Optim Keys Describe how to insert masked data to a target database Describe how to compare multiple sets of data Transform and mask confidential data including, but not limited to, social security numbers, credit card information, e-mail addresses, and telephone numbers




	Qui peut en profiter
	This is a basic usage course for application developers, business analysts, database administrators, and technical personnel involved in implementing a data growth management solution using the IBM Optim. From DT211: This is a basic usage course for application developers, business analysts, database administrators, and technical personnel involved in implementing a data privacy solution using the IBM Optim Data Privacy Solution.




	Préalables
	You should be able to: Use basic Window functionality Discuss basic relational database concepts and objects, such as tables, indexes, views, and joins Construct and use basic SQL statements




	Abstract
	IBM Education Advantage Program eligibility: Yes - IBM Education Pack - Online Account

Ce cours est donnÃ© par des formateurs certifiÃ©s IBM.

Ã€ titre de partenaire en formation agrÃ©Ã©e , ExitCertified peut vous inscrire Ã nâ€™importe quel cours en AmÃ©rique du Nord.

Il y a une diffÃ©rence. DÃ©couvrez-la

Code:	DT292
Format:	Formation en classe avec formateur

Durée:	5 days
Certifié par:	IBM

Frais d’inscription (CAD): $contact

TrainingIndustry.com selects ExitCertified as a Top 20 IT Training Company for 2011

IBM Optim Core Technology for Distributed Systems (DT292) Contenu détaillé

Introduction to IBM Optim

Understand the capabilities of IBM Optim solution
Understand how Optim can improve Enterprise Data Management for your business
Understand the four pillars of EDM
Understand the benefits Optim offers for your companyâ€™s data and resource management
Understand how Optim can better meet the needs of both your company and your customers through improved performance

Managing data growth

See the benefits Optim offers in managing data growth
Understand the costs of unmanaged data growth
Understand the benefits of aligning EDM with your business
Discuss and plan for the major factors affecting data growth
Plan for regulated data retention through archival of data
Discuss and analyze tiered storage needs and benefits

Optim architecture

Plan the best Optim configuration for your needs
Plan for implementation of Optim with use of the numerous services provided
Evaluate Optimâ€™s multi-threading capability in terms of your own needs
Plan your Optim environment best using the archive catalog, metadata, and attributes of the Optim Directory
Plan for Optimâ€™s cross database and legacy data capabilities

Optim installation

Install Optim on a Windows workstation and Server
Configure the first workstation
Configure additional workstations
Understand use of the Optim server

The Optim Directory

Describe the function of the Optim Directory
Name the types of objects stored in the Optim Directory
Explain the purpose of a DB Alias
Explain the difference between named and local definitions
Describe how to open an existing action request

The Archive process

Design and construct an archive request and the related access definition
Plan for the use of local/named processing
Create an archive Index file and use it to locate files
Use a control file to check archive error conditions
Plan your archive process and select a start table and related tables
Plan for the use of selection criteria in the Archive process
Check and use information provided on the archive process report
Create table maps for restoring archive data
Determine at which time in your process archived data should be deleted

The Delete process

Create Delete requests
Locate previously created delete requests
Modify Delete requests using the Table Strategy screen
Use Delete process reports to verify results

Multi-byte character support

Successfully enable multi-byte character support in Optim
Identify the usage limitations of multi-byte character columns in various Optim functions
Determine whether an Optim Directory is enabled to support an MBCS database

Insert and Load

Apply Uptime Trigger and Constraint handling
Plan whether Insert or Load is more practical for your situation
Plan Insert processing for Insert, Update, Update/Insert, and Mixed scenarios
Use Table Maps to transform data
Apply the correct options for Load processing depending on your operating system

The Restore process

Process either a full or selective restore of data from an Archive file
Modify a Restore Request using the Restore Request Editor
Develop unique SQL for use in Optimâ€™s Restore process

The Create process

Use Create with Insert, Restore, and Load processing
Construct a copy, subset, or new database
Create and/or drop selected table objects
Edit the SQL generated by Optim during the Create process

Defining Optim primary keys and relationships

List the Optim requirements for primary keys
Create, edit and delete Optim primary keys
Convert an explicit Optim primary key to generic
List the differences between database and Optim relationships
Create, edit and delete Optim relationships
Convert an explicit Optim relationship to a generic relationship

Traversing relationships

Evaluate selection criteria
Construct ADs using the best Start Tables
Construct ADs applying Options 1 and 2 to produce the desired results
Design ADs using Child Limits to limit traversed paths
Plan the use of ADs using the Show Steps report

Archive Actions

Construct Archive Actions for various phases of an Archive process
Insert SQL into an Archive Action
Apply global and local actions appropriately

Custom Exits

Determine which type of Exit is required for a process
Call an Exit from a column map
Plan Exit and subroutine calls using the appropriate language
Design Exits capable of setting derived destination column values

Restart/Retry

Use the pending process List to Restart/Retry a process
Restart an Optim process from its last commit point
Retry failed rows from an Optim process
Apply Global Aging functions to adjust columns

Archive directory

Maintain the Archive Directory entries using the Archive Directory Maintenance Utility
Maintain Archive Indexes using the Archive Index Maintenance Utility
Register Archive File entries in the Archive Directory using the Archive

Export/Import

Successfully execute both Export and Import processes
Understand possible error situations and to avoid or correct those errors
Plan and execute the movement of Optim objects between environments
Design a site methodology for the Export/Import of Optim objects
Use the Export/Import feature to produce a more efficient development/production environment when working with Optim

The command line interface

Write a Command Line Interface
Run an Archive Process from the Command Line Interface
Use some of the most frequently-used options in a CLI
Execute a CLI from both a .bat file and the command line
Use return codes and simple error handling routines
Use the Search and Restore process for unknown Archive files

Scheduling

Schedule a process
Modify and Override a scheduled job
Schedule steps within jobs
Monitor jobs
Set Personal Options related to job scheduling

Archive collections

Plan for and build Archive Collections
Produce unioned Archive Files for access with ODM
Work with the Archive File Collection Editor
Plan for and build collections which may have different attributes
Construct and use Archive Indexes with unioned tables

Using ODM

Start Attunity studio
Add a machine to ODM
Properly edit the Archive File/Collection source information
Add the Attunity Connect Driver to an ODBC connection
Define the Attunity Connection to ODBC
Connect to and Open the defined data source in Excel

Securing Private Information

Discuss current issues related to data privacy
Define PID and CDF
Plan for role-base data privacy management
Discuss and plan data privacy using the four goals

The Extract Process

Create an Access Definition for an Extract process
Apply selection criteria to an Extract
Create and Point and Shoot File
Create variables and recognize times when the use of variables is of benefit
Use a Show Steps report to verify the process trail prior to execution

Edit

Complete a Relational Edit of data
Select a subset of your data for editing
Undo errors and changes you do not wish to make permanent

Convert

Develop Column and Table Maps for a Convert process
Apply Optimâ€™s data masking functions
Propagate changes from a primary key to foreign keys

Compare

Develop Compare processes for both single and multiple tables
Locate rows which are unchanged or changed using the find function
Set options found in the Browse tab in Personal Options to aid in the Compare process
Verify whether results meet the masking expectations

Optim Security

Evaluate the benefits of existing security versus Optim Security
Evaluate features of Functional, Object, Program, Archive, and ODM security as they relate to your environment

Optim Data Privacy Workshop

Design Column Maps using three types of Look-Up routines
Apply CCN, SSN, and EML functions to the appropriate data
Successfully adhere to the proposed data privacy methodology
Use Compare to evaluate data changes
Plan, design, and develop an entire data privacy flow of Extract, Convert, and Compare processes

Agenda

Day 1

Unit 1: Introduction to IBM Optim
Unit 2: Managing Data Growth
Unit 3: Optim Architecture
Unit 4: Optim Installation
Unit 5: The Optim Directory
Unit 6: The Archive Process
Unit 7: The Delete Process

Day 2

Unit 8: Multi-Byte Character Support
Insert and Load
Unit 10: The Restore Process
Archive Lab #1
Unit 11: The Create Process
Archive Lab #2
Unit 12: Defining Optim Primary Keys and Relationships
Unit 13: Traversing Relationships
Unit 14: Archive Actions
Archive Lab #3
Unit 15: Custom Exits

Day 3

Unit 16: Restart/Retry
Unit 17: Archive Directory
Unit 18: Export/Import
Unit 19: The Command Line Interface
Unit 20: Scheduling
Archive Lab #4
Unit 21: Archive Collections
Unit 22: Using ODM

Day 4

Unit 23: Securing Private Information
Unit 24: The Extract Process
Exercise 5: Extract
Unit 25: The Edit Process
Exercise 6: Edit
Exercise 7: Edit (Part 2)

Day 5

Unit 26: Convert
Exercise 8: Extract
Unit 27: Compare
Exercise 9: Compare
Exercise 10: Extract
Unit 28: Optim Security
Unit 29: Optim Data Privacy Workshop

Your Name:

Your Email:

Sign up for newsletter:

Send Email To:

Course Link:

http://exitcertified.ca/ibm-training/DT292.html

Message:


	Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source. Il y a une différence. Apprenez directement de la source.



Canada	United States
Formation à Montréal :: 514.876.1666 Formation à Ville de Québec :: 514.876.1666 Formation à Ottawa :: 613.232.3948 Formation à Toronto :: 416.487.3948 Formation à Vancouver :: 604.633.3948 Formation à Victoria :: 1.866.328.3948 Formation à Calgary :: 403.291.2855 Formation à Edmonton :: 780.441.3948 Formation à Regina :: 1.866.328.3948	Formation à Sacramento :: 916.669.3970 Formation à San Francisco :: 415.975.3948 Formation à San Jose :: 408.288.3948 Formation à Las Vegas :: 1.800.803.3948 Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948	Des questions? Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.

ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :

Formation Sun	Formation Oracle	Formation Symantec	Formation IBM	Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris	Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle	Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec	DB2, OS/400, Formation zSeries, s/390, iSeries, AIX	SUSE, Formation RedHat

Formation MySQL	Formation Apple	Formation en gestion de projet
Base de données MySQL	Cours Apple, Formation Leopard	Formation du PMI

IBM Optim Core Technology for Distributed Systems (DT292)

Compétences acquises

Qui peut en profiter

Préalables

Abstract

Formation de IBM (2375 cours)

Formation de Information Management (101 cours)

Formation de Optim (19 cours)

IBM Optim Core Technology for Distributed Systems (DT292) Contenu détaillé