Oracle Enterprise Data Quality 12c: Profile, Audit and Operate Ed 1

Duration : 3 Days (24 Hours)

Oracle Enterprise Data Quality 12c: Profile, Audit and Operate Ed 1 Course Overview:

Oracle Enterprise Data Quality 12c: Profile, Audit and Operate Ed 1 course is designed to give users a comprehensive understanding of the Oracle Enterprise Data Quality platform and demonstrate how it can be used to identify, remediate and operationalize data. Through hands-on activities, you will learn how to take advantage of advanced features such as Data Lookup, Data Entity, Data Stewardship and Validations to gain maximum value from your data assets.
You will learn how to effectively use the Oracle Enterprise Data Quality platform to discover, analyze, profile and report on data to obtain insights and identify anomalies. Participants will also explore the usage of the Data Management Console, enabling them to maintain governance over their data assets.
This course will teach you to create data stewardship workflows to directly address inconsistencies and anomalies in data. You will be able to define validations and apply profiling to identify and review data outliers, taking necessary actions to remediate data inconsistencies. In addition, this course will discuss how to use data quality metrics and the impact of errors on business decisions.
You will have the opportunity to put your data cleansing process into production. You will gain the skills to monitor, maintain and periodically audit your data to ensure accuracy and consistency. At the end of the course you will have the knowledge to work with data assets and quality control data management processes across the enterprise.

Intended Audience:

  1. Data Architects: Professionals responsible for designing data structures and data management strategies.
  2. Application Developers: Developers involved in creating and maintaining applications that handle data.
  3. Data Modelers: Experts in designing and defining data models for databases and applications.
  4. System Administrators: IT professionals responsible for managing and maintaining system-level configurations.
  5. Database Administrators: Professionals involved in managing and maintaining databases.

Learning Objectives of Oracle Enterprise Data Quality 12c: Profile, Audit and Operate Ed 1:

1. Identify the features and components of Oracle Enterprise Data Quality 12c.
2. Describe how to configure data quality profiles and rules.
3. Explain how to audit and monitor data quality operations.
4. Demonstrate how to use the tools and techniques provided to integrate the EDQ solution into an enterprise data quality management system.
5. Learn to develop customer use cases and test results for validation.
6. Design and execute data quality-auditing reports.
7. Operate data quality processes in production systems efficiently and with minimal errors.
8. Create and maintain Data Quality dashboards, scorecards and reports.
9. Use rules and profiles for exception management.
10. Monitor Operations and performance at the item, data and operator levels.

 Module 1: Enterprise Data Quality Overview
  • Overview of Enterprise Data Quality and its Features
  • Overview of High-level architecture
  • About Process Canvas, Tool Palette, Results Browser and Project Browser
  • Saving Results to a Results Book
  • Setting up Projects, Data Stores, Snapshots and Processes
  • Using the Quickstats Profiler for a Fast Overview of Data
  • dentifying Trends with the Frequency Profiler
  • Examining Outliers with the Max / Min Profiler
  • Profiling Patterns
  • Assessing Record Completeness
  • Using Audit Processors to Check Your Data
  • Understanding Flags
  • Using Audit Processors to Branch Processes
  • Using Lookup and Return to Enrich Your Data
  • Using the Group and Merge Processor
  • Transforming Data to enable better auditing
  • Using the Writer
  • Setting up an Export
  • Configuring and scheduling jobs
  • Publishing processors
  • Creating and importing packages
  • Understanding the use of Customer Data Extension Pack
  • Installing the Customer Data Extension Pack
  • Examining a Customer Data Extension Pack Processor
  • Configuring a web service within Enterprise Data Quality
  • Creating and testing a real-time process
  • Introducing Data Interfaces
  • Creating a data interface
  • Using a data interface in a process
  • Overview of the Server Console user interface
  • Running, Scheduling and Monitoring jobs from the Server Console user interface
  • Overview of Run Profiles
  • Creating a Run Profile
  • Running a job with a Run Profile
  • Sampling options
  • Overview of Case Management Functionality

Oracle Enterprise Data Quality 12c: Profile, Audit and Operate Ed 1 Course Prerequisites:

The course you are referring to requires participants to be familiar with one or more of the following areas:

  1. Relational Databases: Having knowledge of relational databases and their concepts is essential, as data integration often involves working with data stored in these databases.
  2. Data Integration Techniques: Familiarity with data integration techniques is important, as the course may cover various methods to combine data from multiple sources.
  3. ETL Tools: Experience with Extract, Transform, Load (ETL) tools is beneficial, as they are commonly used for data integration and migration.
  4. Business Intelligence and Reporting Concepts: Understanding business intelligence and reporting concepts is valuable, as data quality and analytics are essential for effective reporting.
  5. Process and Data Modeling Techniques: Knowledge of process and data modeling techniques helps in understanding data flows and data relationships.
  6. Data Quality Analytics and Processes: Familiarity with data quality analytics and processes is relevant, as data quality is a crucial aspect of data integration.
  7. The Use of the Command Line Interface: Experience with using the command line interface is helpful, as it is often used for certain data integration tasks.
  8. Experience with Oracle Database and/or Other RDBMS Technologies: Having experience with Oracle Database or other relational database management systems is advantageous, as the course may involve hands-on exercises using these technologies.

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability


  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention


  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.