Faites confiance à votre formation en TI |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.
ExitCertified renforce sa relation avec Red Hat en obtenant le statut de revendeur avancés.
Oracle University décerne à ExitCertified le prix de Qualité exceptionnelle des instructeurs.
ExitCertified en vedette dans le répertoire des Entrepreneurs dynamiques du 21e siècle.
ExitCertified est mis en candidature une troisième fois pour les prix de la Chambre de commerce.
ExitCertified élargit sa relation avec Apple en ajoutant la diffusion de formation agréée Mac OS à Phoenix, en Arizona.
 |
Installing and Using Optim Test Data Management with Data Privacy (ILO) (3T211) |
 |
|
| Format: Formation virtuelle avec formateur |
| Autres formats: |
|
|
|
|
|
|
| |
This is an online course. Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs. 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. You 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 |
| |
- 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
- Discuss how to define selection criteria
- Describe how the Optim Extract process works
- Transform and mask confidential data including, but not limited to social security numbers, credit card information, e-mail addresses, and telephone numbers
- Create table maps and column maps
- 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
|
|
|
|
| |
 | 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: |
3T211 |
| Format: |
Formation virtuelle avec formateur |
|
| Durée: |
3 days |
| Certifié par: |
IBM |
|
| Frais d’inscription (CAD): $contact |
|
|
 |
|
|
|
|
 | Ce cours n'est pas prévu à l'horaire pour l'instant. Si vous êtes intéressé à suivre ce cours, utilisez le lien ci-dessous pour demander une date. |
|
|
|
Installing and Using Optim Test Data Management with Data Privacy (ILO) (3T211) 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 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
| |
- 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
| |
- Install Optim on a Windows workstation and Server
- Configure the First workstation
- Configure additional workstations
- Understand use of the Optim Server
| |
- 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
| |
| 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
| |
- 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
| |
- 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
| |
| 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
| |
- Develop Column and Table Maps for a Convert process
- Apply Optim's data masking functions
- Propagate changes from a primary key to foreign keys
| |
- 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
| |
- Apply Optim 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
| |
- 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
- Describe the differences between Optim relationships and database relationships
- Create, edit and delete Optim relationships
- Convert an explicit Optim relationship to generic
| |
- 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
| |
- 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
| |
- 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
| |
- 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 data growth
| |
| 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
| |
- Schedule a process
- Modify and Override a scheduled job
- Schedule steps within jobs
- Monitor jobs
- Set Personal Options related to job scheduling
| |
- Evaluate the benefits of existing security versus Optim Security
- Evaluate features of Functional, Object, Program, Archive, and ODM security as they related 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
| |
| |
- Welcome
- Unit 1: Introduction to IBM Optim
- Unit 2: Optim Architecture
- Unit 3: Optim Installation
- Unit 4: The Optim Directory
- Unit 5: Securing Private Information
- Unit 6: The Extract Process
- Exercise 1: Extract
- Unit 7: The Edit Process
- Exercise 2: Edit
| |
- Exercise 3: Edit (Part 2)
- Unit 8: Multi-Byte Character Support
- Unit 9: Convert
- Exercise 4: Extract
- Unit 10: Compare
- Exercise 5: Compare
- Unit 11: Insert and Load
- Unit 12: The Create Process
- Unit 13: Defining Optim Primary Keys and Relationships
- Exercise 6: Extract
- Unit 14: Traversing Relationships
- Unit 15: Custom Exits
- Unit 16: Restart/Retry
| |
- Unit 17: Export/Import
- Unit 18: The Command Line Interface
- Unit 19: Scheduling
- Unit 20: Optim Security
- Unit 21: Optim Data Privacy Workshop
| |
| |
|
