Oracle LSDH 2 Essentials Exam Study Guide (PDF)
Oracle LSDH 2 Essentials Exam Study Guide (Online Course)
Oracle's Life Sciences Data Hub Implementation Boot Camp

OPN Guided Learning Path
Oracle Life Sciences Data Hub 2 Implementation Specialist

Introduction and Navigating LSH

• Log in and navigate (Home Page, Applications Tab and Reports Tab, Search, Advanced Search)
• Look for Outputs, print Outputs, and submit Jobs
• Use Snapshots
• Use Blinding, Blind Breaks and Dummy Data
• Launch Visualizations
• Install Work Areas

Security and Classification

• Assign Functional Security to Users
• Create and assign Security Roles, Users and User Groups
• Create and use Security Subtypes
• Assign Object Security and classify Objects
• Create Classification Hierarchies and use Classification Subtypes

Load Sets and Tables

• Load data from Oracle Databases (move data into LSH and work with pass-through views)
• Load data from SAS (from data sets and transport formats)
• Load data from Text Files
• Build Tables ( Columns, Variables, Constraints)
• Leverage Table Processing Types and Auditing
  • Perform Data Blinding
  • Use Authorized Tables

Programs & Parameters

• Create Programs (program source codes, table descriptors, parameters, planned outputs)
• Use existing Programs (Searching, Copy and Move, Mapping, Upgrading Instances)
• Program with SAS (Interactive Development Environment and SAS Macros and Formats)
• Program with PL/SQL (Interactive Development and PL/SQL Function and Procedure Libraries)
• Program With Informatica
• Program with Oracle Reports
• Program with BI Publisher
• Create Execution Setups
• Execute Jobs
• Classify Planned Outputs
• Use Parameters
• Use Programmatic LOVs and Validation

Business Areas, Report Sets, Workflows, and Data Marts

• Create Business Areas ( Create Joins, Hierarchies or OBIEE, Oracle Discoverer, JReview)
• Create Report Sets (Entries, Parameter Propagation, Create Overlay Templates, Post Processing, Execution Setups and Running)
• Create Workflows (Create Transitions, Design Workflows, Notifications, Approvals)
• Create Data Marts

Validation and Production Scenarios

• Implement a Validation Lifecycle (Validation Status, Work Area Cloning, Work Area usage intent)
• Implement Standards, Hierarchy (Global / TA / Drug) and Multiple (Internal, CDISC, et cetera)
• Validate Data (Verifying data accuracy LSH – Source to Staging, Staging to Transformed, Transformed to Data Mart, et cetera)
• Manage Protocol Amendments (new source table columns, et cetera)

Installing LSH &Administering LSH

• Configure Hardware
• Install Oracle E-Business Suite (Summary only)
• Upgrade the Database
• Install Oracle Warehouse Builder
• Install Oracle Thesaurus Management
• Install/Load LSH Jar Files to Oracle Warehouse Builder
• Create Services
• Configure OBIEE
• Configure Informatica
• Configure SAS
• Configure BI Publisher
• Configure Oracle Reports
• Configure the Discoverer Middle Tier
• Configure the environment for High Availability
• Start and stop Services And Queues
• Search for and stop LSH Jobs
• Create and manage Database Accounts
• Manage Statistics and Table Spaces
• Manage Start and Stop Queues
• Manage DP Server

Data Model and APIs

• Use the Data Model (Namings, Naming Versions, Satellite Tables)
• Test Database Views
• Execute APIs
• Create, modify, and remove Definitional APIs
• Create Classification APIs, Security APIs and Validation APIs

LSH Automation / Interface Scenarios

• Perform daily data loads of data from Oracle Clinical upon batch validation completion for a study
• Perform a data load of Lab data when files arrive in a pre-defined folder
• Report on objects ‘close in structure’ to objects in a given study, for easy reuse
• Use LSH full and partial Export and Import functions (Metadata, Data, Source Code, et cetera)

Building Adapters

• Load Adapters Design Pattern
• Build CDR_Adapter_Areas and CDR_Technology_Types
• Build Source Data Adapters (Oracle Tables, SAS and OC Adapters)
• Build Load Adapter for a file system-based adapter
• Build Visualization and Reporting Adapters (Discoverer, OBIEE)
• Build Transformation Adapters (SAS or Informatics)
• Build LSH Adapters

Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.