About This Course
Introduction
PeopleSoft Data Management Training
At the time of researching on a project, huge data are generated and data management is nothing but a specialized process of calculating/controlling this information. Usually, any kind of research involves certain kind of data management, and funding agencies are expecting the scholars to put more emphasis on planning as well as executing best data management practices in the research. It will be a challenging task if the research studies involve several researchers or if these studies are carried out from different locations. Data management largely depends on the kind of data that is involved in the research process, how this data is stored and collected and on how it will be used across the research lifecycle etc.
Course Objectives :
What you’ll learn in PeopleSoft Data Management Training Course?
- Fundamentals of PeopleSoft Data Management concepts
- Performing up-gradation of Peoplesoft Data Management
- Managing customizations at the time of implementation
- Analyze and compare definitions between various databases
- Applying application updates
What are the pre-requisites to learn PeopleSoft Data Management Course?
Peoplesoft Architecture working knowledge, Peoplesoft People Tools, Application Designer experience, Peoplesoft Applications Data structure
Course Curriculum
MODULE 1: OVERVIEW OF TECHNOLOGY
TOPICS: Data Management Tasks & Tools, Change Assistant, PeopleSoft Database Tables, Application Upgrades & Updates
MODULE 2: EXPLORING PEOPLESOFT DATABASES
TOPICS: Components of Peoplesoft, Content Versus Structure, Exploring PeopleSoft Databases, Tracking various Definition Changes, what are Customizations? Definition of Upgrade Terminology, Identification of Databases
MODULE 3: ALTERING & BUILDING TABLES
TOPICS: Identification of PeopleTools Tables affecting System Catalog, Building as well as Altering Tables, Configuration of DDL (Data Definition Language) Parameters, How to use Build Process? Altering Tables, Creating Indexes, Triggers, and Views, How to Run reports of Database Integrity?
MODULE 4: IDENTIFICATION OF PEOPLE-TOOLS TABLES
TOPICS : How to Identify PeopleTools Tables ? Exploring and Securing PeopleTools Tables, How to Run SYSAUDIT Reports?
MODULE 5: MERGING VARIOUS PROJECTS
TOPICS : Documenting Changes & Customizations, Merging Projects, Printing Definitions, determination of how various definitions are inter-related ?
MODULE 6: USAGE OF CHANGE CONTROL
TOPICS : Searching for various Strings in PeopleCode, How to Use Change Control ? Identification of components of Change Control, How to administer Change Controlling Options ? How to set Workstation Preferences ? How to copy locked definitions ? Locking & Unlocking Definitions
MODULE 7: CUSTOMIZATIONS
TOPICS : How to Describe Migration Process ? Creation of Upgrade Projects, How to Copy Projects to different Databases ? Adjusting definitions, Validating & Reusing Projects, Merging Projects, How to Copy Projects from and to Files ?
MODULE 8: USAGE OF REPORT AND COMPARE PROCESS
TOPICS : How to use report and compare process, running report and compare, How to describe compare process ? How to Set Upgrade Options ?
MODULE 9: ANALYZING AND VIEWING COMPARE REPORTS
TOPICS : Merging and Comparing Files and Text Definitions, Merging and comparing pages, Running PeopleCode Merge /Diff, How to move Data with the help of Data Mover ?
MODULE 10: MOVING DATA
TOPICS : How to list data mover syntax and commands ? How to export and import data ? How to use set commands ? Renaming Fields and Records
MODULE 11: CREATION OF CHANGE PACKAGES
TOPICS : Creating Change Packages Change projects and file references, What is Change Packager ? How to create Change Package in an Application Designer ? Updation of Change, Assistant Template, Finalizing and testing Change Packages
MODULE 12: CONFIGURATION OF CHANGE ASSISTANT
TOPICS : How to Configure Change Assistant ? How to Apply Change Packages and to Prepare the Environment ? How to Set options of Change Assistant and apply Change Packages ?
MODULE 13: COMPARING, DEPLOYING AND TESTING UPDATES
TOPICS : What is Update Deployment, Reapplying Customizations, Migrating Change Packages, How to Apply Application Updates ? How to Search for Updates ? Downloading & Reapplying Change Packages
MODULE 14 : PEOPLESOFT APPLCIATION UPGRADATION
TOPICS : PeopleSoft Application Upgradation, Exploring PeopleSoft Upgrade Process & Types, How to Gather Upgrade Documentation ? How to Identify Upgradation Planning Tasks, Software Installation, Configuration of Change Assistant (for various Upgrades), Creating Environments and Upgrade Job
MODULE 15: PREPARING A DATABASE
TOPICS : Preparing Database for up-gradation, How to Compare Customizations ? How to Identify Customizations ?
MODULE 16: APPLYING CHANGES OF PeopleTools
TOPICS: Steps in PeopleTools Upgrade, Reviewing and Running Compare Reports
MODULE 17: APPLICATION CHANGES PREPARATION
TOPICS: Running & Reviewing New Release Compare Reports, How to Apply Application Changes ? Customization of New Release ? Modification of Database Structures and Running various Data Conversion Programs, Database Structures finalization, Reapplying Customizations
MODULE 18: COMPLETING DATABASE CHANGES & MOVING TO PRODUCTION
TOPICS: Configuring Security, Testing and Stamping Database, Developing Test Plans, Preserving Queries, Tree structure, and Tree
Your Instructors
