Översikt
| Kurskod | 1T292SE | Leveranstyp | Web Based Training |
|---|---|---|---|
| Kurslängd | 40.0 timmar | Kurstyp | |
| Listpris |
SEK 3 493,00 exkl moms
SEK 4 366,25 inkl moms |
This is a self-paced online course. The average amount of time to complete this course is 40 hours. Once you receive your access information, you will have 1 year to complete this 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 the course.
This course combines the material of Installing, Configuring, and Using Optim Data Growth for Archiving on Distributed Systems (DT201) with Installing, Configuring, and Using Optim Test Data Management with Data Privacy (DT211), and eliminates any material from Installing, Configuring, and Using Optim Test Data Management with Data Privacy (DT211) taught on Days 4 and 5 that was already covered in Installing, Configuring, and Using Optim Data Growth for Archiving on Distributed Systems (DT201) in Days 1 through 3. Thus, anyone taking just Installing, Configuring, and Using Optim Data Growth for Archiving on Distributed Systems (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.
Installing, Configuring, and Using Optim Data Growth for Archiving on Distributed Systems (DT201) focuses on the technical aspects of the Optim solution and is intended for technical audiences. You will install and configure Optim and experience a breadth of Optim core functionality. You 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, you 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. You will use Optim Archive, Optim Delete, Optim Browse, Optim Insert, and ODM to produce archived files and perform management activities. You will examine scheduling and running processes from the command line. You 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 Installing, Configuring, and Using Optim Test Data Management with Data Privacy (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 underThe self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours.tanding 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.
The self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours.
This is the Web-based version of Classroom Course IBM Optim Core Technology for Distributed Systems (DT292), Instructor-led Online Course IBM Optim Core Technology for Distributed Systems - Instructor Led Online (3T292) and Self-paced Virtual Course IBM Optim Core Technology for Distributed Systems - SPVC (2T292SE).
Visa den här kursen i andra länder
Roadmaps:
Målgrupp
This basic course is for application developers, business analysts, database administrators, and technical personnel involved in implementing a data growth management solution using the IBM Optim.
From Installing, Configuring, and Using Optim Test Data Management with Data Privacy (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.
Förkunskaper
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
Mål
- 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
Nyckelområden
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
Hårdvarukrav
HW/SW CONFIGURATION
The minimum hardware and software required to launch the course are:
- Reliable HIGH-SPEED INTERNET connection (min 200 kbps up and down)
- Windows 2000 or XP or Vista
- Computer with soundcard
- Headset or computer speakers
- Internet Explorer 5.01 or later, or Firefox 1.0 or later
Network Speed Test
http://clpext.moppssc.com/index.php?option=com_wrapper&view=wrapper&Itemid=8
User: clp
Pass: ibmeduc
For example, a speed test against the server with a slow connection of 140 Kbps download and 28 Kbps upload took 14 minutes to load a 30min recording before the video began. Extrapolate from this result to estimate approximately how fast your network internet access would be.
High-speed broadband internet access is the recommended configuration for this course.
Keyboard Configuration
If you use a different character keyboard, you may experience errors when entering passwords. If possible, change your language/country settings for your keyboard to USA, which allows you to enter characters as in a QWERTY keyboard.