On successful Completion of the Introduction to Data Modeling course you will be able to:

• Fundamentals of normalization and why it's important to transactional databases
• How to develop logical and physical data models
• How to model data security, privacy and protection requirements
• When and where to model database-specific performance requirements
• How model-driven development fits in a DevOps or agile environment
• How to avoid schema drift and other data anti-patterns

Certification: This course will assist in preparation for the Microsoft MCSE & MCSA and Oracle OCA Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Oracle Modelling and Relational Database Design course you will be able to accomplish the following:

• Understand Relational Database Concepts
• Understand Types of Databases Models
• Understand Gathering Requirements for Database Design
• Create an Entity Relationship Diagram by identifying entities, attributes, relationships and constraints from a set of requirements
• Normalize the Entity Relationship Diagram to third Normal form
• Enhance the Entity Relationship Diagram to utilize several data modeling techniques
• Create a Data Flow Diagram by identifying processes, external agents, information stores and information flows
• Create a Data Flow Diagram that show how the information flows and how it is being transformed
• Engineer the Entity Relationship Model into an initial relational database design
• Optimize the Relational Database Design
• Complete the Physical Model and generate the DDL

Product code: WLN-ORADB-MODEL-eLearning

On successful Completion of the Oracle Analytics and Data warehousing Self-Study eLearning course you will be able to:

• Define the terminology and explain basic concepts of data warehousing.
• Identify the technology and some of the tools from Oracle to implement a successful data warehouse
• Describe methods and tools for extracting, transforming and loading data
• Identify some of the tools for accessing and analysing warehouse data
• Describe the benefits of partitioning, parallel operations, materialized views and query rewrite in a data warehouse
• Explain the implementation and organizational issues surrounding a data warehouse project
• Improve performance or manageability in a data warehouse using various Oracle Database features
• Understand the Oracle Business and Analytics Technology Stack
• Understand the Oracle Analytics Reference Architecture
• Build queries in Oracle BI Answers
• Customize the Oracle BI user interface
• Create and modify Oracle BI Interactive Dashboards
• Work with views to display request information
• Create and modify Interactive Dashboards
• Create guided navigation links within Interactive Dashboards
• Use Oracle BI Delivers to configure, schedule, and deliver personalized alerts
• Build Oracle BI Publisher reports based on Answers requests and BI metadata
• Understand and Manage Presentation Layer Security
• Understand Repositories and the Presentation Layer Meta Data
• Understand BI Publisher – BI Presentation Services Integration
• Employ recommended design principles and best practices

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist 1Z0-591 Certification exam..

Product code: WLN-OBIEE-FDN

On successful Completion of the Microsoft Business Intelligence and Data Warehousing BootCamp course you will be able to:

• Learn to Plan and Scope your SQL Server Data Warehouse Projects
• Understand BI and Warehouse Architecture Frameworks
• Understand the BI and Warehouse Development Process
• Learn to Manage SQL Server Warehouse Projects
• Understand the Data Warehouse and ETL Development Lifecycle
• Understand Data Warehousing Concepts
• Understand Dimension Modelling
• Understand SQL Server Warehouse Capabilities
• Understand Data warehouse concepts and architecture considerations
• Understand Data Warehouse Administration
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the SQL Server Integration Service system
• Select an appropriate hardware platform for a data warehouse
• Design and implement a data warehouse
• Implement data flow and control flow in a SSIS package
• Create and Manage Projects
• Define Integration Processes
• Manage metadata in SQL Server Integration Service
• Enforce data quality constraints in a Package
• Debug and troubleshoot SSIS packages
• Implement a SSIS incremental data warehouse loads and extracting data
• Deploy and configure SSIS packages

Certification: This course will assist in preparation for the Microsoft Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Informatica Data Integration & ETL Fundamentals course you will be able to:

• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the complete Informatica system
• Design and build simple mappings and workflows
• Use PowerCenter 9.x Designer to build mappings that extract data from a source to a target
• Use PowerCenter 9.x Designer to build transformations
• Use PowerCenter transformations to cleanse, format and join data
• Use PowerCenter transformations to aggregate and route data to targets
• Perform error handling/trapping using PowerCenter mappings
• Describe the use of Mapping Variables and Parameter Files
• Use PowerCenter 9.x Workflow Manager to build and run a workflow
• Use PowerCenter 9.x Workflow Manager to execute sessions associated with a mapping
• Perform basic troubleshooting using PowerCenter logs and debugger
• Describe the SQL Transformation

Informatica Data Integration & ETL Fundamentals Self-Study eLearning:

Product code: WLN-INF-ETLFNDM

On successful Completion of the Informatica Data Integration & ETL BootCamp Self-Study eLearning course you will be able to:

• Learn to Plan and Scope your ETL/ELT Projects
• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand the Oracle Data Integration Reference Architecture
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the complete Informatica system
• Describe the Informatica domain, nodes, and application services
• Describe the Informatica clients
• Install Informatica 9.6.x domain
• Describe the Administration Console
• Create Privileges and Roles
• Describe PowerCenter repositories
• Deploy PowerCenter metadata from development to test environment
• Describe Domain Management
• Design and build simple mappings and workflows
• Use PowerCenter 9.6.x Designer to build mappings that extract data from a source to a target
• Use PowerCenter 9.6.x Designer to build transformations
• Use PowerCenter transformations to cleanse, format and join data
• Use PowerCenter transformations to aggregate and route data to targets
• Perform error handling/trapping using PowerCenter mappings
• Describe the use of Mapping Variables and Parameter Files
• Use PowerCenter 9.6.x Workflow Manager to build and run a workflow
• Use PowerCenter 9.6.x Workflow Manager to execute sessions associated with a mapping
• Perform basic troubleshooting using PowerCenter logs and debugger
• Perform basic troubleshooting using PowerCenter logs and debugger
• Describe user defined and advanced functions
• Describe how to Normalize and Denormalize data using PowerCenter
• Describe the Stored Procedure transformation and its two modes of use
• Describe the SQL Transformation

Informatica Data Integration & ETL Bootcamp Self-Study eLearning:

Product code: WLN-INF-ETLBC

On successful Completion of the Informatica 9.6.x Data Warehousing Fundamentals Self-Study eLearning course you will be able to:

• Understand the Informatica Data Warehouse and ETL Development Lifecycle
• Understand the BI and Warehouse Development Process
• Learn to Manage Informatica Warehouse Projects
• Understand Data warehousing Concepts
• Understand Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Informatica system
• Manage your Informatica environment using the Informatica Console
• Use PowerCenter 9.x Designer to build mappings
• Use PowerCenter 9.x Designer to extract data from a source to a target
• Use PowerCenter 9.x Designer to build transformations
• Use PowerCenter transformations to cleanse, format and join data
• Use PowerCenter transformations to aggregate and route data to targets
• Perform error handling/trapping using PowerCenter mappings
• Describe the use of Mapping Variables and Parameter Files
• Use PowerCenter 9.x Workflow Manager to build and run a workflow
• Use PowerCenter 9.x Workflow Manager to execute sessions associated with a mapping

Informatica Data Integration & ETL Fundamentals Self-Study eLearning:

Product code: WLN-INF-DWFNDM

On successful Completion of the Informatica 9.6.x Data Warehousing BootCamp Self-Study eLearning course you will be able to:

• Understand the Informatica Data Warehouse and ETL Development Lifecycle
• Understand the BI and Warehouse Development Process
• Learn to Manage Informatica Warehouse Projects
• Understand Data warehousing Concepts
• Understand Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Describe the Informatica 9.6.x Technical architecture
• Describe the Informatica domain, nodes, and application services
• Describe the Informatica clients
• Install Informatica 9.6.x domain
• Describe the Administration Console
• Create Privileges and Roles
• Describe PowerCenter repositories
• Deploy PowerCenter metadata from development to test environment
• Describe Domain Management
• Describe the Informatica PowerCenter architecture
• Design and build simple mappings and workflows
• Manage your Informatica environment using the Informatica Console
• Use PowerCenter 9.6.x Designer to build mappings
• Use PowerCenter 9.6.x Designer to extract data from a source to a target
• Use PowerCenter 9.6.x Designer to build transformations
• Use PowerCenter transformations to cleanse, format and join data
• Use PowerCenter transformations to aggregate and route data to targets
• Perform error handling/trapping using PowerCenter mappings
• Describe the use of Mapping Variables and Parameter Files
• Use PowerCenter 9.6.x Workflow Manager to build and run a workflow
• Use PowerCenter 9.6.x Workflow Manager to execute sessions associated with a mapping

Informatica 9.6.X Data Warehousing BootCamp Self-Study eLearning:

Product code: WLN-INF-DWBC

On successful Completion of the Oracle Data Integrator 11g Fundamentals course you will be able to:

• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle Data Integrator system
• Define Data Sources
• Define Physical and Logical Architecture
• Create and reverse-engineer models
• Manage Projects
• Define Integration Processes
• Work with projects in Oracle Data Integrator
• Release your ODI work for deployment
• Understand models, reverse-engineering model metadata from your database
• Manage metadata in Oracle Data Integrator: models and data quality
• Create simple interfaces and add multiple sources to an interface
• Launch a session to run an interface
• Enforce data quality constraints in an interface
• Manage packages

Certification: This course will assist in the preparation for the Oracle Data Integrator 11g Certified Implementation Essentials - 1Z0-482 exam.

Product code: WLN-ORA-ODIFNDM

On successful Completion of the Oracle Data Integrator 11g/12c ELT Development course you will be able to:

• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle Data Integrator system
• Define Data Sources
• Define Physical and Logical Architecture
• Create and reverse-engineer models
• Manage Projects
• Define Integration Processes
• Work with projects in Oracle Data Integrator
• Release your ODI work for deployment
• Understand models, reverse-engineering model metadata from your database
• Manage metadata in Oracle Data Integrator: models and data quality
• Create simple interfaces and add multiple sources to an interface
• Launch a session to run an interface
• Enforce data quality constraints in an interface
• Manage packages

Certification: This course will assist in the preparation for the Oracle Data Integrator 11g/12c Certified Implementation Essentials - 1Z0-482 exam.

Product code: WLN-ORA-ODIFNDM

On successful Completion of the Oracle Data Integrator 12c ELT Development course you will be able to:

• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle Data Integrator system
• Define Data Sources
• Define Physical and Logical Architecture
• Create and reverse-engineer models
• Manage Projects
• Define Integration Processes
• Work with projects in Oracle Data Integrator
• Release your ODI work for deployment
• Understand models, reverse-engineering model metadata from your database
• Manage metadata in Oracle Data Integrator: models and data quality
• Create simple interfaces and add multiple sources to an interface
• Launch a session to run an interface
• Enforce data quality constraints in an interface
• Manage packages

Certification: This course will assist in the preparation for the Oracle Data Integrator 12c Certified Implementation Essentials - 1Z0-482 exam.

Product code: WLN-ORA-ODIFNDM

On successful Completion of the Oracle Data Integrator 11g Certified Implementation Essentials - 1Z0-482 course you will be able to:

• Learn to Plan and Scope your ETL/ELT Projects
• Understand the ETL Development Lifecycle
• Describe Oracle Fusion Middleware (FMW)
• Describe the Oracle Data Integrator (ODI) system logical architecture
• Identify and describe Oracle DI Java components
• Identify the system administration tools that are available for managing Oracle DI
• Define the Oracle Data Integrator 11g (ODI) Information System architecture
• Describe scenarios in which FMW Control is available
• Start and stop instances of WebLogic Server by using FMW Control
• Configure ODI11g Java EE Agent Components
• Monitor a WebLogic Server (WLS) domain with FMW Control
• Centrally manage Oracle DI components using Fusion Middleware Control
• Centrally manage Oracle DI Java components using the Oracle WebLogic Server Console
• Stop and start Oracle DI components
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the complete Oracle Data Integrator system
• Create Data Servers and Sources
• Define Physical and Logical Architecture
• Create and reverse-engineer models
• Manage Projects
• Define Integration Processes
• Work with projects in Oracle Data Integrator
• Release your ODI work for deployment
• Understand models, reverse-engineering model metadata from your database
• Manage metadata in Oracle Data Integrator: models and data quality
• Create simple interfaces and add multiple sources to an interface
• Launch a session to run an interface
• Enforce data quality constraints in an interface
• Manage packages
• Manage and Monitor ETL processes in the ODI Console

Certification: This course will assist in the preparation for the Oracle Data Integrator 11g Certified Implementation Essentials - 1Z0-482 exam.

Product code: WLN-ORA-ODIBC

On successful Completion of the Oracle Data Integrator 12c Certified Implementation Essentials - 1Z0-482 course you will be able to:

• Learn to Plan and Scope your ETL/ELT Projects
• Understand the ETL Development Lifecycle
• Describe Oracle Fusion Middleware (FMW)
• Describe the Oracle Data Integrator (ODI) system logical architecture
• Identify and describe Oracle DI Java components
• Identify the system administration tools that are available for managing Oracle DI
• Define the Oracle Data Integrator 11g (ODI) Information System architecture
• Describe scenarios in which FMW Control is available
• Start and stop instances of WebLogic Server by using FMW Control
• Configure ODI11g Java EE Agent Components
• Monitor a WebLogic Server (WLS) domain with FMW Control
• Centrally manage Oracle DI components using Fusion Middleware Control
• Centrally manage Oracle DI Java components using the Oracle WebLogic Server Console
• Stop and start Oracle DI components
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the complete Oracle Data Integrator system
• Create Data Servers and Sources
• Define Physical and Logical Architecture
• Create and reverse-engineer models
• Manage Projects
• Define Integration Processes
• Work with projects in Oracle Data Integrator
• Release your ODI work for deployment
• Understand models, reverse-engineering model metadata from your database
• Manage metadata in Oracle Data Integrator: models and data quality
• Create simple interfaces and add multiple sources to an interface
• Launch a session to run an interface
• Enforce data quality constraints in an interface
• Manage packages
• Manage and Monitor ETL processes in the ODI Console

Certification: This course will assist in the preparation for the Oracle Data Integrator 12c Certified Implementation Essentials - 1Z0-482 exam.

Product code: WLN-ORA-ODIBC-12c

On successful Completion of the Oracle Data Integrator 12c: Integration and Administration course you will be able to:

• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the ODI architecture and Components
• Connect to ODI Master and Work Repositories
• Describe the architecture of Oracle Data Integrator 12c
• Apply ODI Topology concepts for data integration
• Define Data Sources
• Define Physical and Logical Architecture
• Learn to ODI Manage Projects
• Describe ODI Model concepts
• Create and reverse-engineer models
• Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations
• Explore, audit data, and enforce data quality with ODI
• Implement Changed Data Capture with ODI
• Enforce data quality constraints in an interface
• Manage packages
• Describe Oracle Data Integrator and Big Data Integration Patterns

Certification: This course will assist in the preparation for the Oracle Data Integrator 12c: Integration and Administration exam.

Product code: WLN-ORA-GG-11G-12c

On successful Completion of the Oracle Data Integrator 12c: Data Integration and ELT Development course you will be able to:

• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the ODI architecture and Components
• Connect to ODI Master and Work Repositories
• Describe the architecture of Oracle Data Integrator 12c
• Apply ODI Topology concepts for data integration
• Define Data Sources
• Define Physical and Logical Architecture
• Learn to ODI Manage Projects
• Describe ODI Model concepts
• Create and reverse-engineer models
• Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations
• Explore, audit data, and enforce data quality with ODI
• Implement Changed Data Capture with ODI
• Enforce data quality constraints in an interface
• Manage packages
• Describe Oracle Data Integrator and Big Data Integration Patterns

Certification: This course will assist in the preparation for the Oracle Data Integrator 12c: Integration and Administration exam.

Product code: WLN-ORA-GG-11G-12c

On successful Completion of the Oracle Data Integrator 12c: New Features course you will be able to:

• Design ODI mappings and packages to perform ELT data transformations
• Implement multiple target loads and in-session parallelism
• Describe methods of integration of ODI 12c in Enterprise environment
• Perform debugging ODI mappings and packages using Step-by-Step debugger
• Become familiar with various ODI components
• Develop data transformation projects by using ODI 12c Declarative flow-based user interface

Certification: This course will assist in the preparation for the Oracle Data Integrator 12c: Integration and Administration exam.

Product code: WLN-ORA-GG-11G-12c

On successful Completion of the Oracle Data Integrator 11g and 12c: E-L-T/ETL Development course you will be able to:

• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle Data Integrator system
• Understand the architecture of the Oracle Data Integrator 11g system
• Understand the architecture of the Oracle Data Integrator 12c system
• Understand the New Mapping feature in Data Integrator 12c
• Define Data Sources
• Define Physical and Logical Architecture
• Create and reverse-engineer models
• Manage Projects
• Define Integration Processes
• Work with projects in Oracle Data Integrator
• Release your ODI work for deployment
• Understand models, reverse-engineering model metadata from your database
• Manage metadata in Oracle Data Integrator: models and data quality
• Create simple interfaces and add multiple sources to an interface
• Launch a session to run an interface
• Enforce data quality constraints in an interface
• Manage packages
• Understand Oracle DI Studio 12c New Features
• Create Mappings Oracle DI Studio 12c
• Create Mappings Using the Model and Topology Objects Wizard
• Describe Oracle Data Integrator and Big Data Integration Patterns

Certification: This course will assist in the preparation for the Oracle Data Integrator 12c: Integration and Administration exam.

Product code: WLN-ORA-GG-11G-12c

On successful Completion of the Oracle Data Integrator 11g/12c: Data Warehousing Boot Camp course you will be able to:

• Learn to Plan and Scope your Oracle DI 11g/12c Data Warehouse Projects
• Understand BI and Warehouse Architecture Frameworks
• Understand the BI and Warehouse Development Process
• Learn to Manange ODI 11g/12c Warehouse Projects
• Understand Data warehousing Concepts
• Understand the ODI Data Warehouse and ETL Development Lifecycle
• Understand Dimension Modelling
• Understand Oracle Database warehouse Capabilities
• Understand the Official Oracle Data warehouse Reference Architecture
• Understand Data Warehouse Administration
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle Data Integrator system
• Define Data Sources
• Define Physical and Logical Architecture
• Create and reverse-engineer models
• Create and Manage Projects
• Define Integration Processes
• Understand models, reverse-engineering model metadata from your database
• Manage metadata in Oracle Data Integrator: models and data quality
• Create simple interfaces and add multiple sources to an interface
• Launch a session to run an interface
• Enforce data quality constraints in an interface
• Manage packages
• Manage your ODI environment using the ODI Console
• Administer Repositories in ODI Console
• Managing Scenarios and Sessions in DI Console

Certification: This course will assist in the preparation for the Oracle Data Integrator 12c: Integration and Administration exam.

Product code: WLN-ORA-GG-11G-12c

On successful Completion of the Oracle Data Integrator 12c: Data Warehousing Boot Camp course you will be able to:

• Learn to Plan and Scope your Oracle DI 12c Data Warehouse Projects
• Understand BI and Warehouse Architecture Frameworks
• Understand the BI and Warehouse Development Process
• Learn to Manange ODI 11g Warehouse Projects
• Understand Data warehousing Concepts
• Understand the ODI Data Warehouse and ETL Development Lifecycle
• Understand Dimension Modelling
• Understand Oracle Database warehouse Capabilities
• Understand the Official Oracle Data warehouse Reference Architecture
• Understand Data Warehouse Administration
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle Data Integrator system
• Define Data Sources
• Define Physical and Logical Architecture
• Create and reverse-engineer models
• Create and Manage Projects
• Define Integration Processes
• Understand models, reverse-engineering model metadata from your database
• Manage metadata in Oracle Data Integrator: models and data quality
• Create simple interfaces and add multiple sources to an interface
• Launch a session to run an interface
• Enforce data quality constraints in an interface
• Manage packages
• Manage your ODI environment using the ODI Console
• Administer Repositories in ODI Console
• Managing Scenarios and Sessions in DI Console

Certification: This course will assist in the preparation for the Oracle Data Integrator 12c: Integration and Administration exam.

Product code: WLN-ORA-DI-12c

On successful Completion of the Oracle GoldenGate 11g Fundamentals for Oracle course you will be able to:

• Install Oracle GoldenGate and prepare the environment
• Use Oracle GoldenGate utilities
• Perform data transformation using Oracle GoldenGate
• Run and manage Oracle GoldenGate instances
• Describe Oracle GoldenGate solutions
• Describe Oracle GoldenGate architecture
• Configure Oracle GoldenGate for Oracle-to-Oracle replication

Certification: This course will assist in the preparation for the Oracle GoldenGate 11g Fundamentals for Oracle exam.

Product code: WLN-ORA-GG-11G

On successful Completion of the Oracle GoldenGate 11g and 12c Fundamentals for Oracle course you will be able to:

• Install Oracle GoldenGate and prepare the environment
• Use Oracle GoldenGate utilities
• Perform data transformation using Oracle GoldenGate
• Run and manage Oracle GoldenGate instances
• Describe Oracle GoldenGate solutions
• Describe Oracle GoldenGate architecture
• Configure Oracle GoldenGate for Oracle-to-Oracle replication

Certification: This course will assist in the preparation for the Oracle GoldenGate 11g and 12c Fundamentals for Oracle exam.

Product code: WLN-ORA-GG-11G

On successful Completion of the Oracle GoldenGate 12c Fundamentals for Oracle course you will be able to:

• Install Oracle GoldenGate and prepare the environment
• Use Oracle GoldenGate utilities
• Perform data transformation using Oracle GoldenGate
• Run and manage Oracle GoldenGate instances
• Describe Oracle GoldenGate solutions
• Describe Oracle GoldenGate architecture
• Configure Oracle GoldenGate for Oracle-to-Oracle replication

Certification: This course will assist in the preparation for the Oracle GoldenGate 12c Fundamentals for Oracle exam.

Product code: WLN-ORA-GG-11G

On successful Completion of the Oracle GoldenGate 11g: Fundamentals for SQL Server course you will be able to:

• Install Oracle GoldenGate software version 11.1.x
• Describe Oracle GoldenGate Solutions
• Configure and manage Oracle GoldenGate instances
• Describe Oracle GoldenGate Architecture
• Use Oracle GoldenGate for SQL Server Utilities
• Perform Data Transformation using Oracle GoldenGate
• Configure Oracle GoldenGate for SQL Server to SQL Server replication
• Configure Oracle GoldenGate for SQL Server-to-Oracle Data Replication
• Issue GGSCI commands to add, start, monitor, stop, and delete processes
• Configure Extract (Change Capture), Replicat (Change Delivery), and Initial Load
• Manage Extract trails and files using logdump
• Create parameter files
• Manage and troubleshoot Oracle GoldenGate instances

Certification: This course will assist in the preparation for the Oracle GoldenGate 11g Fundamentals for Oracle exam.

Product code: WLN-ORA-GG-11G

On successful Completion of the Oracle GoldenGate 11g and 12c: Fundamentals for SQL Server course you will be able to:

• Install Oracle GoldenGate software version 11.1.x
• Describe Oracle GoldenGate Solutions
• Configure and manage Oracle GoldenGate instances
• Describe Oracle GoldenGate Architecture
• Use Oracle GoldenGate for SQL Server Utilities
• Perform Data Transformation using Oracle GoldenGate
• Configure Oracle GoldenGate for SQL Server to SQL Server replication
• Configure Oracle GoldenGate for SQL Server-to-Oracle Data Replication
• Issue GGSCI commands to add, start, monitor, stop, and delete processes
• Configure Extract (Change Capture), Replicat (Change Delivery), and Initial Load
• Manage Extract trails and files using logdump
• Create parameter files
• Manage and troubleshoot Oracle GoldenGate instances

Certification: This course will assist in the preparation for the Oracle GoldenGate 11g Fundamentals for Oracle exam.

Product code: WLN-ORA-GG-11G

On successful Completion of the Oracle GoldenGate 11g: Fundamentals for DB2 course you will be able to:

• Install Oracle GoldenGate software version 11.1.x
• Describe Oracle GoldenGate Solutions
• Configure and manage Oracle GoldenGate instances
• Describe Oracle GoldenGate Architecture
• Use Oracle GoldenGate for DB2 Utilities
• Perform Data Transformation using Oracle GoldenGate
• Run and Manage Oracle GoldenGate Instances
• Configure Oracle GoldenGate for DB2-to-DB2 Data Replication
• Configure Oracle GoldenGate for DB2-to-Oracle Data Replication

Certification: This course will assist in the preparation for the Oracle GoldenGate 11g Fundamentals for Oracle exam.

Product code: WLN-ORA-GG-11G

On successful Completion of the Oracle GoldenGate 11g and 12c: Fundamentals for DB2 course you will be able to:

• Install Oracle GoldenGate software version 11.1.x
• Describe Oracle GoldenGate Solutions
• Configure and manage Oracle GoldenGate instances
• Describe Oracle GoldenGate Architecture
• Use Oracle GoldenGate for DB2 Utilities
• Perform Data Transformation using Oracle GoldenGate
• Run and Manage Oracle GoldenGate Instances
• Configure Oracle GoldenGate for DB2-to-DB2 Data Replication
• Configure Oracle GoldenGate for DB2-to-Oracle Data Replication

Certification: This course will assist in the preparation for the Oracle GoldenGate 11g Fundamentals for Oracle exam.

Product code: WLN-ORA-GG-11G

On successful Completion of the Oracle GoldenGate 11g and 12c Fundamentals for Oracle course you will be able to:

• Install Oracle GoldenGate and prepare the environment
• Use Oracle GoldenGate utilities
• Perform data transformation using Oracle GoldenGate
• Run and manage Oracle GoldenGate instances
• Describe Oracle GoldenGate solutions
• Describe Oracle GoldenGate architecture
• Configure Oracle GoldenGate for Oracle-to-Oracle replication

Certification: This course will assist in the preparation for the Oracle GoldenGate 11g and 12c Fundamentals for Oracle exam.

Product code: WLN-ORA-GG-11G-12c

On successful Completion of the Oracle GoldenGate 12c Fundamentals for Oracle course you will be able to:

• Install Oracle GoldenGate and prepare the environment
• Use Oracle GoldenGate utilities
• Perform data transformation using Oracle GoldenGate
• Run and manage Oracle GoldenGate instances
• Describe Oracle GoldenGate solutions
• Describe Oracle GoldenGate architecture
• Configure Oracle GoldenGate for Oracle-to-Oracle replication

Certification: This course will assist in the preparation for the Oracle GoldenGate 12c Fundamentals for Oracle exam.

Product code: WLN-ORA-GG-11G-12c

On successful Completion of the Microsoft SQL Server Integration Services Essentials course you will be able to:

• Understanding SQL-Server Integration Services and its tools
• Create an Integration Services package
• Implement control flow in an Integration Services package
• Implement data flow in an Integration Services package
• Implement logging in an Integration Services package
• Debug and implement error handling in an Integration Services package
• Implement checkpoints and transactions in an Integration Services package
• Deploy an Integration Services package
• Manage and secure an Integration Services package

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Introduction to Data Modeling course you will be able to:

• Fundamentals of normalization and why it's important to transactional databases
• How to develop logical and physical data models
• How to model data security, privacy and protection requirements
• When and where to model database-specific performance requirements
• How model-driven development fits in a DevOps or agile environment
• How to avoid schema drift and other data anti-patterns

Certification: This course will assist in preparation for the Microsoft MCSE & MCSA Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Oracle Modelling and Relational Database Design course you will be able to accomplish the following:

• Understand Relational Database Concepts
• Understand Types of Databases Models
• Understand Gathering Requirements for Database Design
• Create an Entity Relationship Diagram by identifying entities, attributes, relationships and constraints from a set of requirements
• Normalize the Entity Relationship Diagram to third Normal form
• Enhance the Entity Relationship Diagram to utilize several data modeling techniques
• Create a Data Flow Diagram by identifying processes, external agents, information stores and information flows
• Create a Data Flow Diagram that show how the information flows and how it is being transformed
• Engineer the Entity Relationship Model into an initial relational database design
• Optimize the Relational Database Design
• Complete the Physical Model and generate the DDL

Product code: WLN-ORADB-MODEL-eLearning

On successful Completion of the Oracle Analytics and Data warehousing Self-Study eLearning course you will be able to:

• Define the terminology and explain basic concepts of data warehousing.
• Identify the technology and some of the tools from Oracle to implement a successful data warehouse
• Describe methods and tools for extracting, transforming and loading data
• Identify some of the tools for accessing and analysing warehouse data
• Describe the benefits of partitioning, parallel operations, materialized views and query rewrite in a data warehouse
• Explain the implementation and organizational issues surrounding a data warehouse project
• Improve performance or manageability in a data warehouse using various Oracle Database features
• Understand the Oracle Business and Analytics Technology Stack
• Understand the Oracle Analytics Reference Architecture
• Build queries in Oracle BI Answers
• Customize the Oracle BI user interface
• Create and modify Oracle BI Interactive Dashboards
• Work with views to display request information
• Create and modify Interactive Dashboards
• Create guided navigation links within Interactive Dashboards
• Use Oracle BI Delivers to configure, schedule, and deliver personalized alerts
• Build Oracle BI Publisher reports based on Answers requests and BI metadata
• Understand and Manage Presentation Layer Security
• Understand Repositories and the Presentation Layer Meta Data
• Understand BI Publisher – BI Presentation Services Integration
• Employ recommended design principles and best practices

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist 1Z0-591 Certification exam..

Product code: WLN-OBIEE-FDN

On successful Completion of the Microsoft Business Intelligence and Data Warehousing BootCamp course you will be able to:

• Learn to Plan and Scope your SQL Server Data Warehouse Projects
• Understand BI and Warehouse Architecture Frameworks
• Understand the BI and Warehouse Development Process
• Learn to Manage SQL Server Warehouse Projects
• Understand the Data Warehouse and ETL Development Lifecycle
• Understand Data Warehousing Concepts
• Understand Dimension Modelling
• Understand SQL Server Warehouse Capabilities
• Understand Data warehouse concepts and architecture considerations
• Understand Data Warehouse Administration
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the SQL Server Integration Service system
• Select an appropriate hardware platform for a data warehouse
• Design and implement a data warehouse
• Implement data flow and control flow in a SSIS package
• Create and Manage Projects
• Define Integration Processes
• Manage metadata in SQL Server Integration Service
• Enforce data quality constraints in a Package
• Debug and troubleshoot SSIS packages
• Implement a SSIS incremental data warehouse loads and extracting data
• Deploy and configure SSIS packages

Certification: This course will assist in preparation for the Microsoft Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Data Engineering Bootcamp course you will be able to:

• Gain a high-level understanding of big data and Hadoop
• Understand Hadoop Components: MapReduce and HDFS
• Understand Hadoop Components: YARN and Apache Tez
• Understand HCatalog
• Understand development with Hive
• Understand development with Pig
• Understand development with HBase
• Gain a high-level understanding of Apache Spark
• Understand Resilient Distributed Datasets (RDDs) in Apache Spark
• Understand Spark ML
• launch data analytics applications for companies
• You will be instrumental in getting data from a variety of different sources
• Learn how these data will be parsed in the right formats, assuring that they adhere to data
• Understand data quality standards
• Learn to perform downstream tasks such as reporting or exploratory analytics
• Understand NoSQL Databases

Certification: This course will assist in the preparation for the IBM, Oracle and Microsoft Data Engineering Certification exams.

Product code: WLN-ORA-DENGBC

On successful Completion of the Informatica 9.6.x and Oracle Data Integrator 11g:ETL/ELT Development course you will be able to:

• Learn to Plan and Scope your ETL/ELT Projects
• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle Data Integrator system
• Define Data Sources
• Define Physical and Logical Architecture
• Create and reverse-engineer models
• Manage Projects
• Define Integration Processes
• Work with projects in Oracle Data Integrator
• Release your ODI work for deployment
• Understand models, reverse-engineering model metadata from your database
• Manage metadata in Oracle Data Integrator: models and data quality
• Create simple interfaces and add multiple sources to an interface
• Launch a session to run an interface
• Enforce data quality constraints in an interface
• Manage packages
• Manage and Monitor ETL processes in the ODI Console

Course Objectives for Informatica 9.6.x

• Learn to Plan and Scope your ETL/ELT Projects
• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the complete Informatica system
• Design and build simple mappings and workflows
• Use PowerCenter 9.x Designer to build mappings that extract data from a source to a target
• Use PowerCenter 9.x Designer to build transformations
• Use PowerCenter transformations to cleanse, format and join data
• Use PowerCenter transformations to aggregate and route data to targets
• Perform error handling/trapping using PowerCenter mappings
• Describe the use of Mapping Variables and Parameter Files
• Use PowerCenter 9.x Workflow Manager to build and run a workflow
• Use PowerCenter 9.x Workflow Manager to execute sessions associated with a mapping
• Perform basic troubleshooting using PowerCenter logs and debugger

Certification: This course will assist in the preparation for the Oracle Data Integrator 12c Certified Implementation Essentials - 1Z0-482 exam.

Product code: WLN-ORA-ODIBC-12c

On successful Completion of the Informatica 9.6.x and Oracle Data Integrator 11g: Data Warehousing course you will be able to:

• Understand the ODI Data Warehouse and ETL Development Lifecycle
• Understand the BI and Warehouse Development Process
• Learn to Manange ODI 11g Warehouse Projects
• Understand Data warehousing Concepts
• Understand Dimension Modelling
• Understand Oracle Database warehouse Capabilities
• Understand the Official Oracle Data warehouse Reference Architecture
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle Data Integrator system
• Define Data Sources
• Define Physical and Logical Architecture
• Create and reverse-engineer models
• Create and Manage Projects
• Define Integration Processes
• Understand models, reverse-engineering model metadata from your database
• Manage metadata in Oracle Data Integrator: models and data quality
• Create simple interfaces and add multiple sources to an interface
• Launch a session to run an interface
• Enforce data quality constraints in an interface
• Manage packages
• Manage your ODI environment using the ODI Console

Course Objectives for Informatica 9.6.x

• Understand the Informatica Data Warehouse and ETL Development Lifecycle
• Understand the BI and Warehouse Development Process
• Learn to Manage Informatica Warehouse Projects
• Understand Data warehousing Concepts
• Understand Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Informatica system
• Manage your Informatica environment using the Informatica Console
• Use PowerCenter 9.x Designer to build mappings
• Use PowerCenter 9.x Designer to extract data from a source to a target
• Use PowerCenter 9.x Designer to build transformations
• Use PowerCenter transformations to cleanse, format and join data
• Use PowerCenter transformations to aggregate and route data to targets
• Perform error handling/trapping using PowerCenter mappings
• Describe the use of Mapping Variables and Parameter Files
• Use PowerCenter 9.x Workflow Manager to build and run a workflow
• Use PowerCenter 9.x Workflow Manager to execute sessions associated with a mapping

Certification: This course will assist in the preparation for the Oracle Data Integrator 12c Certified Implementation Essentials - 1Z0-482 exam.

Product code: WLN-ORA-ODIBC-12c

On successful Completion of the Informatica 9.6.x and Microsoft SQL Server SSIS ETL course you will be able to:

Course Objectives for ODI 11g/12c:

• Learn to Plan and Scope your ETL/ELT Projects
• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Learn to Manage SSIS Warehouse Projects
• Understand Data warehousing Concepts
• Understand Dimension Modelling
• Understand Microsoft SQL Server warehouse Capabilities
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Microsoft SSIS system
• Define Data Sources
• Define Integration Processes
• Work with projects in Microsoft SSIS and release your work for deployment
• Manage metadata in Microsoft SSIS: models and data quality
• Manage SSIS packages

Course Objectives for Informatica 9.6.x/Cloud

• Learn to Plan and Scope your ETL/ELT Projects
• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the complete Informatica system
• Design and build simple mappings and workflows
• Use PowerCenter 9.x Designer to build mappings that extract data from a source to a target
• Use PowerCenter 9.x Designer to build transformations
• Use PowerCenter transformations to cleanse, format and join data
• Use PowerCenter transformations to aggregate and route data to targets
• Perform error handling/trapping using PowerCenter mappings
• Describe the use of Mapping Variables and Parameter Files
• Use PowerCenter 9.x Workflow Manager to build and run a workflow
• Use PowerCenter 9.x Workflow Manager to execute sessions associated with a mapping
• Perform basic troubleshooting using PowerCenter logs and debugger

Certification: This course will assist in the preparation for the Oracle Data Integrator 12c Certified Implementation Essentials - 1Z0-482 exam.

Product code: WLN-ORA-ODIBC-12c

On successful Completion of the Informatica 9.6.x and Microsoft SQL Server Data warehousing course you will be able to:

Course Objectives for ODI 11g/12c:

• Learn to Plan and Scope your SQL Server Data Warehouse Projects
• Understand BI and Warehouse Architecture Frameworks
• Understand Microsoft Analytics and Big Data Platform
• Understand the BI and Warehouse Development Process
• Learn to Manage SQL Server Warehouse Projects
• Understand the Data Warehouse Development Lifecycle
• Understand Data Warehousing Concepts
• Understand Dimension Modelling
• Understand SQL Server Warehouse Capabilities
• Understand Data warehouse concepts and architecture considerations
• Understand Data Warehouse Administration
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the SQL Server Integration Service system
• Select an appropriate hardware platform for a data warehouse
• Design and implement a data warehouse
• Implement data flow and control flow in a SSIS package
• Create and Manage Projects
• Define Integration Processes
• Enforce data quality constraints in a Package
• Debug and troubleshoot SSIS packages
• Deploy and configure SSIS packages

Course Objectives for Informatica 9.6.x/Cloud

• Understand the Informatica Data Warehouse and ETL Development Lifecycle
• Understand the BI and Warehouse Development Process
• Learn to Manage Informatica Warehouse Projects
• Understand Data warehousing Concepts
• Understand Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Informatica system
• Manage your Informatica environment using the Informatica Console
• Use PowerCenter 9.x Designer to build mappings
• Use PowerCenter 9.x Designer to extract data from a source to a target
• Use PowerCenter 9.x Designer to build transformations
• Use PowerCenter transformations to cleanse, format and join data
• Use PowerCenter transformations to aggregate and route data to targets
• Perform error handling/trapping using PowerCenter mappings
• Describe the use of Mapping Variables and Parameter Files
• Use PowerCenter 9.x Workflow Manager to build and run a workflow
• Use PowerCenter 9.x Workflow Manager to execute sessions associated with a mapping

Certification: This course will assist in the preparation for the Oracle Data Integrator 12c Certified Implementation Essentials - 1Z0-482 exam.

Product code: WLN-ORA-ODIBC-12c

On successful Completion of the Microsoft SQL Server SSIS and Oracle Data Integartor ETL/ELT Development course you will be able to:

Course Objectives for SQL Server SSIS:

• Learn to Plan and Scope your ETL/ELT Projects
• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Learn to Manage SSIS Warehouse Projects
• Understand Data warehousing Concepts
• Understand Dimension Modelling
• Understand Microsoft SQL Server warehouse Capabilities
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Microsoft SSIS system
• Define Data Sources
• Define Integration Processes
• Work with projects in Microsoft SSIS and release your work for deployment
• Manage metadata in Microsoft SSIS: models and data quality
• Manage SSIS packages

Course Objectives for Oracle ODI 11g/12c

• Learn to Plan and Scope your ETL/ELT Projects
• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle Data Integrator system
• Define Data Sources
• Define Physical and Logical Architecture
• Create and reverse-engineer models
• Manage Projects
• Define Integration Processes
• Work with projects in Oracle Data Integrator
• Release your ODI work for deployment
• Understand models, reverse-engineering model metadata from your database
• Manage metadata in Oracle Data Integrator: models and data quality
• Create simple interfaces and add multiple sources to an interface
• Launch a session to run an interface
• Enforce data quality constraints in an interface
• Manage packages
• Manage and Monitor ETL processes in the ODI Console

Certification: This course will assist in the preparation for the Oracle Data Integrator 12c Certified Implementation Essentials - 1Z0-482 exam.

Product code: WLN-ORA-ODIBC-12c

On successful Completion of the Microsoft SQL Server SSIS and Oracle Integartor Data Warehousing course you will be able to:

Course Objectives for SQL Server SSIS:

• Learn to Plan and Scope your SQL Server Data Warehouse Projects
• Understand BI and Warehouse Architecture Frameworks
• Understand Microsoft Analytics and Big Data Platform
• Understand the BI and Warehouse Development Process
• Learn to Manage SQL Server Warehouse Projects
• Understand the Data Warehouse Development Lifecycle
• Understand Data Warehousing Concepts
• Understand Dimension Modelling
• Understand SQL Server Warehouse Capabilities
• Understand Data warehouse concepts and architecture considerations
• Understand Data Warehouse Administration
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the SQL Server Integration Service system
• Select an appropriate hardware platform for a data warehouse
• Design and implement a data warehouse
• Implement data flow and control flow in a SSIS package
• Create and Manage Projects
• Define Integration Processes
• Enforce data quality constraints in a Package
• Debug and troubleshoot SSIS packages
• Deploy and configure SSIS packages

Course Objectives for Oracle ODI 11g/12c

• Understand the ODI Data Warehouse and ETL Development Lifecycle
• Understand the BI and Warehouse Development Process
• Learn to Manange ODI 11g Warehouse Projects
• Understand Data warehousing Concepts
• Understand Dimension Modelling
• Understand Oracle Database warehouse Capabilities
• Understand the Official Oracle Data warehouse Reference Architecture
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle Data Integrator system
• Define Data Sources
• Define Physical and Logical Architecture
• Create and reverse-engineer models
• Create and Manage Projects
• Define Integration Processes
• Understand models, reverse-engineering model metadata from your database
• Manage metadata in Oracle Data Integrator: models and data quality
• Create simple interfaces and add multiple sources to an interface
• Launch a session to run an interface
• Enforce data quality constraints in an interface
• Manage packages
• Manage your ODI environment using the ODI Console

Certification: This course will assist in the preparation for the Oracle Data Integrator 12c Certified Implementation Essentials - 1Z0-482 exam.

Product code: WLN-ORA-ODIBC-12c

On successful Completion of the Oracle 11g Data Warehousing Fundamentals Self-Study eLearning course you will be able to:

• Define the terminology and explain the basic concepts of data warehousing
• Understand the Oracle Data Warehouse Technology Stack
• Understand the Oracle Data Warehouse Reference Architecture
• Understand the Oracle Business Intelligence and Analytics Technology Stack
• Describe methods and tools for extracting, transforming, and loading data
• Use Oracle Data Integrator 11g ETL for extracting, transforming, and loading data
• Identify some of the tools for accessing and analysing warehouse data
• Identify the technology and some of the tools from Oracle to implement a successful data warehouse
• Define the decision support purpose and end goal of a data warehouse
• Describe the benefits of partitioning, parallel operations, materialized views, and query rewrite in a data warehouse
• Understand the implementation and organisational issues surrounding a data warehouse project
• Use materialised views and query rewrite to improve the data warehouse performance
• Develop familiarity with some of the technologies required to implement a data warehouse

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist 1Z0-591 Certification exam.

Product code: WLN-ORA-DWFNDM

On successful Completion of the Oracle 12c Data Warehousing Fundamentals Self-Study eLearning course you will be able to:

• Define the terminology and explain the basic concepts of data warehousing
• Understand the Oracle Data Warehouse Technology Stack
• Understand the Oracle Data Warehouse Reference Architecture
• Understand the Oracle Business Intelligence and Analytics Technology Stack
• Describe methods and tools for extracting, transforming, and loading data
• Use Oracle Data Integrator 11g ETL for extracting, transforming, and loading data
• Identify some of the tools for accessing and analysing warehouse data
• Identify the technology and some of the tools from Oracle to implement a successful data warehouse
• Define the decision support purpose and end goal of a data warehouse
• Describe the benefits of partitioning, parallel operations, materialized views, and query rewrite in a data warehouse
• Understand the implementation and organisational issues surrounding a data warehouse project
• Use materialised views and query rewrite to improve the data warehouse performance
• Develop familiarity with some of the technologies required to implement a data warehouse

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist 1Z0-591 Certification exam.

Product code: WLN-ORA-DWFNDM

On successful Completion of the Oracle 18c Data Warehousing Fundamentals Self-Study eLearning course you will be able to:

• Define the terminology and explain the basic concepts of data warehousing
• Define the terminology and explain the basics of Oracle Big data warehousing
• Understand the Oracle 18c Data Warehouse Technology Stack
• Understand the Oracle 18c Multitenant Architecture for Data Warehousing
• Understand the Oracle 18c Data Warehouse Reference Architecture
• Discuss the different Oracle tools to implement data warehousing on-premise
• Discuss Autonomous Data Warehouse Cloud (ADWC) and Data Integration Platform Cloud (DIPC)
• Understand the Oracle Business Intelligence and Analytics Technology Stack
• Describe methods and tools for extracting, transforming, and loading data
• Use Oracle Data Integrator ETL for extracting, transforming, and loading data
• Identify some of the tools for accessing and analysing warehouse data
• Understand the Oracle 18c AI & Machine Learning Tools for data warehousing
• Identify the technology and some of the tools from Oracle to implement a successful data warehouse
• Define the decision support purpose and end goal of a data warehouse
• Describe the benefits of partitioning, parallel operations, materialized views, and query rewrite in a data warehouse
• Understand the implementation and organisational issues surrounding a data warehouse project
• Use materialised views and query rewrite to improve the data warehouse performance
• Develop familiarity with some of the technologies required to implement a data warehouse

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist 1Z0-591 Certification exam.

Product code: WLN-ORA-DW18cFNDM

On successful Completion of the Oracle 19c Data Warehousing Fundamentals Self-Study eLearning course you will be able to:

• Define the terminology and explain the basic concepts of data warehousing
• Define the terminology and explain the basics of Oracle Big data warehousing
• Understand the Oracle 18c Data Warehouse Technology Stack
• Understand the Oracle 18c Multitenant Architecture for Data Warehousing
• Understand the Oracle 18c Data Warehouse Reference Architecture
• Discuss the different Oracle tools to implement data warehousing on-premise
• Discuss Autonomous Data Warehouse Cloud (ADWC) and Data Integration Platform Cloud (DIPC)
• Understand the Oracle Business Intelligence and Analytics Technology Stack
• Describe methods and tools for extracting, transforming, and loading data
• Use Oracle Data Integrator ETL for extracting, transforming, and loading data
• Identify some of the tools for accessing and analysing warehouse data
• Understand the Oracle 18c AI & Machine Learning Tools for data warehousing
• Identify the technology and some of the tools from Oracle to implement a successful data warehouse
• Define the decision support purpose and end goal of a data warehouse
• Describe the benefits of partitioning, parallel operations, materialized views, and query rewrite in a data warehouse
• Understand the implementation and organisational issues surrounding a data warehouse project
• Use materialised views and query rewrite to improve the data warehouse performance
• Develop familiarity with some of the technologies required to implement a data warehouse

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist 1Z0-591 Certification exam.

Product code: WLN-ORA-DW18cFNDM

On successful Completion of the Oracle and Microsoft Database Administration course you will be able to:

• Describe Oracle and Microsoft Database Architecture
• Manage the Oracle and Microsoft Database Instance
• Manage Oracle and Microsoft Database Storage structures
• Create and Administer User Accounts
• Monitor the Database
• Manage Database Performance
• Implement Database Auditing
• Configure Oracle and Microsoft Database Instance
• Configure Oracle Net Services
• Configure Database For Backup and Recovery Operations
• Schedule Jobs to Run Inside or Outside of the Database

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Oracle and Microsoft Database Administration course you will be able to:

• Describe Oracle and Microsoft Database Architecture
• Manage the Oracle and Microsoft Database Instance
• Manage Oracle and Microsoft Database Storage structures
• Create and Administer User Accounts
• Monitor the Database
• Manage Database Performance
• Implement Database Auditing
• Configure Oracle and Microsoft Database Instance
• Configure Oracle Net Services
• Configure Database For Backup and Recovery Operations
• Schedule Jobs to Run Inside or Outside of the Database

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Oracle and Microsoft Database Administration course you will be able to:

• Describe Oracle and Microsoft Database Architecture
• Manage the Oracle and Microsoft Database Instance
• Manage Oracle and Microsoft Database Storage structures
• Create and Administer User Accounts
• Monitor the Database
• Manage Database Performance
• Implement Database Auditing
• Configure Oracle and Microsoft Database Instance
• Configure Oracle Net Services
• Configure Database For Backup and Recovery Operations
• Schedule Jobs to Run Inside or Outside of the Database

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Oracle and Microsoft Database Administration course you will be able to:

• Describe Oracle and Microsoft Database Architecture
• Manage the Oracle and Microsoft Database Instance
• Manage Oracle and Microsoft Database Storage structures
• Create and Administer User Accounts
• Monitor the Database
• Manage Database Performance
• Implement Database Auditing
• Configure Oracle and Microsoft Database Instance
• Configure Oracle Net Services
• Configure Database For Backup and Recovery Operations
• Schedule Jobs to Run Inside or Outside of the Database

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Oracle Database 11g and SQL Server 2014 Data Warehousing Boot Camp course you will be able to:

• Learn to Plan and Scope your Oracle and SQL Server Data Warehouse Projects
• Understand BI and Warehouse Architecture Frameworks
• Understand Microsoft Analytics and Big Data Platform
• Understand the BI and Warehouse Development Process
• Learn to Manage Oracle and SQL Server Warehouse Projects
• Understand the Data Warehouse Development Lifecycle
• Understand Data Warehousing Concepts
• Understand Dimension Modelling
• Understand Oracle and SQL Server Warehouse Capabilities
• Understand Data warehouse concepts and architecture considerations
• Understand Data Warehouse Administration
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle DI and SQL Server Integration Service system

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Oracle Database 12c and SQL Server 2016 Data Warehousing Boot Camp course you will be able to:

• Learn to Plan and Scope your Oracle and SQL Server Data Warehouse Projects
• Understand BI and Warehouse Architecture Frameworks
• Understand Microsoft Analytics and Big Data Platform
• Understand the BI and Warehouse Development Process
• Learn to Manage Oracle and SQL Server Warehouse Projects
• Understand the Data Warehouse Development Lifecycle
• Understand Data Warehousing Concepts
• Understand Dimension Modelling
• Understand Oracle and SQL Server Warehouse Capabilities
• Understand Data warehouse concepts and architecture considerations
• Understand Data Warehouse Administration
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle DI and SQL Server Integration Service system

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Oracle Database 18c and SQL Server 2017 Data Warehousing Boot Camp course you will be able to:

• Learn to Plan and Scope your Oracle and SQL Server Data Warehouse Projects
• Understand BI and Warehouse Architecture Frameworks
• Understand Microsoft Analytics and Big Data Platform
• Understand the BI and Warehouse Development Process
• Learn to Manage Oracle and SQL Server Warehouse Projects
• Understand the Data Warehouse Development Lifecycle
• Understand Data Warehousing Concepts
• Understand Dimension Modelling
• Understand Oracle and SQL Server Warehouse Capabilities
• Understand Data warehouse concepts and architecture considerations
• Understand Data Warehouse Administration
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle DI and SQL Server Integration Service system

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Oracle Database 19c and SQL Server 2019 Data Warehousing Boot Camp course you will be able to:

• Learn to Plan and Scope your Oracle and SQL Server Data Warehouse Projects
• Understand BI and Warehouse Architecture Frameworks
• Understand Microsoft Analytics and Big Data Platform
• Understand the BI and Warehouse Development Process
• Learn to Manage Oracle and SQL Server Warehouse Projects
• Understand the Data Warehouse Development Lifecycle
• Understand Data Warehousing Concepts
• Understand Dimension Modelling
• Understand Oracle and SQL Server Warehouse Capabilities
• Understand Data warehouse concepts and architecture considerations
• Understand Data Warehouse Administration
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle DI and SQL Server Integration Service system

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the OOracle Database Administration for Microsoft SQL Server DBAs course you will be able to:

• The Database Administrator
• Oracle Internals
• Oracle Installation
• Database Definitions and Setup
• DBA Tools
• Database Backup, Restore, and Recovery
• Database Maintenance
• Performance and Tuning
• PL/SQL
• High-Availability Architecture

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Microsoft SQL Server Database Administration for Oracle DBA'scourse you will be able to:

• Introduction to the SQL Server Platform
• Database and Instances
• Instance Architecture
• Database Architecture
• Data Objects
• Data Access
• Basic Administration
• Managing Schema Operations
• Protection and Security
• Data Transport
• Backup and Recovery
• Performance Tuning
• High Availability

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the IBM DB2 Database Administration for Oracle DBA's course you will be able to:

• Introduction to the IBM DB2 Platform
• Database and Instances
• Instance Architecture
• Database Architecture
• Data Objects
• Data Access
• Basic Administration
• Managing Schema Operations
• Protection and Security
• Data Transport
• Backup and Recovery
• Performance Tuning
• High Availability

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

This course introduces students to the fundamentals of SQL using Oracle Database 11g database technology. In this course students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.
On successful Completion of the course you will be able to accomplish the following:

• Understand Relational Database Modelling
• Identify Oracle Database Development Tools
• Install your Oracle Software
• Understand the Oracle Database 11g Enterprise Edition Options
• Understand the Oracle Database Architecture
• Identify the major structural components of the Oracle Database 11g
• Manage objects with data dictionary views
• Manage schema objects
• Run data definition language (DDL) statements to create and manage schema objects
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data
• Employ SQL & PL/SQL functions to generate and retrieve customized data
• Create PL/SQL Triggers
• Create PL/SQL Stored Procedures and Functions
• Create PL/SQL Packages

Oracle Database 11g Essentials Self-Study eLearning: Certified Implementation Specialist..

Product code: 367DDF5p

The Oracle 11g training course will teach students how to install and maintain an Oracle database, how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.
On successful Completion of the course you will be able to accomplish the following:

• Basics of the Oracle® Database Architecture
• Shared Memory Areas
• Installing Oracle Software
• Managing an Oracle® Instance
• Oracle® Managed Files
• Server Side Parameter File
• Oracle® Data Dictionary
• Control Files and Redo Log Files
• Managing the Physical Database Structure
• Managing Tablespaces and Datafiles
• Temporary Segments
• Storage Structures and Undo Data
• Block Utilization
• Undo Space Management
• Managing Database Objects
• Indexes
• Integrity Constraints
• Managing Database Users
• System Privileges
• Object Privileges
• Roles
• Backup and Recovery Concepts
• Perform Database Backups

This course will assist in preparation for the Oracle Database 11g Administration OCA Certification exams.

Product code: 367DDF5p

On successful Completion of the Oracle Database 11g SQL Essentials course you will be able to:

• Run data definition language (DDL) statements
• Identify the major structural components of the Oracle Database
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data

This course will assist in preparation for the Oracle Database 11g: OCA 1Z0-051 Certification exams.

Product code: 367DDF5p

This course introduces students to the fundamentals of PL/SQL using Oracle Database 11g database technology. In this course students learn the concepts of relational databases and the powerful PL/SQL programming language.
On successful Completion of the course you will be able to accomplish the following:

• Write Executable Statements
• Declaring PL/SQL Variables
• Working with Composite Data Types
• Conditionally control code flow (loops, control structures)
• Explicit cursors
• Handle runtime errors
• Describe stored procedures and functions

This course will assist in preparation for the Oracle Database 11g: Certification exams.

Product code: 367DDF5p

On successful Completion of the course you will be able to accomplish the following:

• Run data definition language (DDL) statements
• Identify the major structural components of the Oracle Database
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data
• Employ SQL & PL/SQL functions to generate and retrieve customized data
• Create PL/SQL Triggers
• Create PL/SQL Stored Procedures and Functions

Certification: This course will assist in preparation for the Oracle Database 11g: 1Z0-051 and 1Z0-144 certification exams.

Product code: WLN-ORA-SQPLSQL

On successful Completion of the Oracle Database 12c: SQL Fundamentals - 1Z0-061 Self-Study eLearning course you will be able to:

• Run data definition language (DDL) statements
• Identify the major structural components of the Oracle Database
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist Certification exam.

Product code: WLN-ORA12SQL

On successful Completion of the course you will be able to accomplish the following:

• Run data definition language (DDL) statements
• Identify the major structural components of the Oracle Database
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data
• Employ SQL & PL/SQL functions to generate and retrieve customized data
• Create PL/SQL Triggers
• Create PL/SQL Stored Procedures and Functions

Certification: This course will assist in preparation for the Oracle Database 12c: certification exams.

Product code: WLN-ORA-DB12C-SQPLSQL

This course introduces students to the fundamentals of PL/SQL using Oracle Database 12c database technology. In this course students learn the concepts of relational databases and the powerful PL/SQL programming language.
On successful Completion of the course you will be able to accomplish the following:

• Introduction to PL/SQL Programming
• PL/SQL Blocks
• Creating an Anonymous Block
• Write Executable Statements
• Declaring PL/SQL Variables
• Working with Composite Data Types
• Conditionally control code flow (loops, control structures)
• Explicit cursors
• Handle runtime errors
• Describe stored procedures and functions

This course will assist in preparation for the Oracle Database 12c: Certification exams.

Product code: WLN-ORA-DB12C-PLSQL

On successful Completion of the Oracle Database 12c Administration Self-Study eLearning course you will be able to:

• Install your Oracle Software
• Oracle Architecture
• Oracle Multi-Tenant Architecture
• Database Schema
• Backup and Recovery Concepts
• Perform Database Backups
• Recovery Manager
• Retrieve Data using the SQL SELECT Statement
• Learn to Restrict and Sort Data
• Usage of Single-Row Functions to Customize Output
• Describe the differences between single row and multiple row functions
• Invoke Conversion Functions and Conditional Expressions
• Aggregate Data Using the Group Functions
• Display Data from Multiple Tables Using Joins
• Use Sub-queries to Solve Queries
• Use of DDL Statements to Create and Manage Tables
• Create a simple and complex view
• Retrieve data from views
• Create, maintain, and use sequences
• Management of Schema Objects
• Query External Tables

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist 1Z0-591 Certification exam.

Product code: WLN-ORA12-ADM

On successful Completion of the Microsoft SQL Server Data Warehousing Fundamentals course you will be able to:

• Understand the Data Warehouse and ETL Development Lifecycle
• Understand the BI and Warehouse Development Process
• Understand Data Warehousing Concepts
• Understand Dimension Modelling
• Understand SQL Server Warehouse Capabilities
• Understand Data warehouse concepts and architecture considerations
• Design and implement a data warehouse
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the SQL Server Integration Service system
• Select an appropriate hardware platform for a data warehouse
• Implement data flow and control flow in a SSIS package
• Define Integration Processes
• Manage metadata in SQL Server Integration Service
• Enforce data quality constraints in a Package
• Debug and troubleshoot SSIS packages
• Implement a SSIS incremental data warehouse loads and extracting data
• Deploy and configure SSIS packages

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Microsoft Business Intelligence and Data Warehousing Fundamentals course you will be able to:

• Understand the SSIS Data Warehouse and ETL Development Lifecycle
• Understand the BI and Warehouse Development Process
• Learn to Manage SSIS Warehouse Projects
• Understand Data warehousing Concepts
• Understand Dimension Modelling
• Understand Microsoft SQL Server warehouse Capabilities
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Microsoft SSIS system
• Define Data Sources
• Define Integration Processes
• Work with projects in Microsoft SSIS and release your work for deployment
• Manage metadata in Microsoft SSIS: models and data quality
• Manage SSIS packages

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Microsoft Business Intelligence and Data Warehousing BootCamp course you will be able to:

• Learn to Plan and Scope your SQL Server Data Warehouse Projects
• Understand BI and Warehouse Architecture Frameworks
• Understand the BI and Warehouse Development Process
• Learn to Manage SQL Server Warehouse Projects
• Understand the Data Warehouse and ETL Development Lifecycle
• Understand Data Warehousing Concepts
• Understand Dimension Modelling
• Understand SQL Server Warehouse Capabilities
• Understand Data warehouse concepts and architecture considerations
• Understand Data Warehouse Administration
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the SQL Server Integration Service system
• Select an appropriate hardware platform for a data warehouse
• Design and implement a data warehouse
• Implement data flow and control flow in a SSIS package
• Create and Manage Projects
• Define Integration Processes
• Manage metadata in SQL Server Integration Service
• Enforce data quality constraints in a Package
• Debug and troubleshoot SSIS packages
• Implement a SSIS incremental data warehouse loads and extracting data
• Deploy and configure SSIS packages

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW