On successful Completion of the Career Enabler: Introduction to Big Data course you will be able to:

• Store, manage, and analyze unstructured data
• Select the correct big data stores for disparate data sets
• Process large data sets using Hadoop to extract value
• Query large data sets in near real time with Pig and Hive
• Plan and implement a big data strategy for your organization

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

Product code: CEN-BIG-SQFK-CBT

On successful Completion of the Career Enabler: Building Enterprise Solutions with MongoDB course you will be able to:

• Develop highly scalable and cost-efficient applications with MongoDB
• Build efficient MongoDB data models for enterprise-scale applications
• Enhance performance with indexing and sharding
• Manage consistency with write concern and read preference
• Process data and compute results with aggregation pipelines and MapReduce

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

Product code: CEN-BIG-SQFK-CBT

On successful Completion of the Career Enabler: Data Science Methodology course you will be able to:

• The major steps involved in tackling a data science problem
• The major steps involved in practicing data science, from forming a concrete business or research problem
• The major steps involved in collecting and analyzing data
• The major steps involved in building a model, and understanding the feedback after model deployment
• How data scientists think through tackling interesting real-world examples

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

Product code: CEN-DSC-PYTH-CBT

On successful Completion of the Career Enabler: Data Science with Open Source Tools course you will be able to:

• Describe key concepts of Data Science and Machine Learning
• Understand Open Source Data Science tools including R and Python
• Understand Open Source Machine learning Tools and Platforms
• Describe and Understand the Data Scientist Workbench
• Work with Jupyter Notebooks for interactive data science
• Work with Zeppelin Notebooks for interactive data analytics
• Work with RStudio IDE for creating and running R apps
• Work with Seahorse for creating and uploading workflows

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

Product code: CEN-DSC-PYTH-CBT

On successful Completion of the Career Enabler: Building Data Pipelines with Apache Kafka course you will be able to:

• The history of Kafka and its architecture
• How to setup Kafka, create topics, and use command-line tools
• How to configure, setup, and manage Producers and Consumers in the Java API
• Learn about Kafka Connect and how to use Kafka and Spark together
• Learn about the different use cases of Kafka

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

Product code: CEN-DSC-PYTH-CBT

On successful Completion of the Career Enabler: Apache Pig Fundamentals course you will be able to:

• The different Pig data types
• The built-in functions used with the LOAD and STORE operators
• The difference between storing and dumping a relation
• The Pig operators
• The Pig evaluation functions

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

Product code: CEN-DSC-PYTH-CBT

On successful Completion of the Career Enabler: Exploring Hadoop Data Using Hive course you will be able to:

• What Apache Hive is, the Hive architecture, and Hive use cases
• Using Data Definition Language (DDL) to create new Hive databases and tables with a variety of different data types
• Creating partitioned tables that are optimized for Hadoop
• Creating and running a variety of useful Data Manipulation Language (DML) queries against Hive data warehouse
• Using built-in Hive operators and functions to get work done
• Creating your own user-defined functions in Hive

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

Product code: CEN-DSC-PYTH-CBT

On successful Completion of the Career Enabler: Mastering Apache Hadoop course you will be able to:

• Comprehend key Hadoop distributors
• Comprehend Hadoop Architecture
• Comprehend HDFS
• Comprehend MapReduce
• Comprehend Backup and Recovery
• Comprehend Monitoring the Cluster
• Comprehend Hadoop Resource Management
• Comprehend Cluster Troubleshooting
• Comprehend Installation, Configuration and Implementation
• Comprehend Hadoop debugging, development, and execution of workflows and algorithms
• leverage Hive, Oozie, Pig, Flume, Sqoop, and other Hadoop ecosystem projects
• Create custom components such as InputFormats and WritableComparables to administer complex data types
• Write and execute joins to link data sets in MapReduce

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

Product code: CEN-BIG-HADO-CBT

On successful Completion of the Career Enabler: Hadoop YARN & Ambari course you will be able to:

• Hadoop fundamentals
• Big Data Approach
• RDBMS Vs. Hadoop
• Introduction to Hadoop
• Hadoop Architecture
• HDFS, YARN, Hadoop setup
• Cloudera Manager
• Ambari
• Job scheduling and monitoring

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

Product code: CEN-BIG-HYAMB-CBT

On successful Completion of the Career Enabler: Sqoop, Flume & Kafka course you will be able to:

• Ingesting Data using Sqoop
• Sqoop properties and commands
• Integrating Sqoop with RDBMS
• Sqoop features and example scenarios
• Ingesting Data using Flume
• Flume properties and setup
• Flume and streaming
• Flume Vs. Kafka

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

Product code: CEN-BIG-SQFK-CBT

On successful Completion of the Career Enabler: Pig, Hive & Impala course you will be able to:

• Introduction to Pig
• Pig programming and commands
• Pig interactive shell
• Analyzing complex data using Pig
• Using Pig functions
• Introduction to Hive
• Hive Metastore
• Writing queries using Hive
• Joins and grouping
• Impala architecture
• Impala Vs. Hive
• Queries using Impala

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

Product code: CEN-BIG-PHI-CBT

On successful Completion of the Career Enabler: MapReduce and YARN course you will be able to:

• Describe the MapReduce model v1
• List the limitations of Hadoop 1 and MapReduce 1
• Review the Java code required to handle the Mapper class, the Reducer class, and the program driver needed to access MapReduce
• Describe the YARN model
• Compare YARN / Hadoop 2 / MR2 vs Hadoop 1 / MR1

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

Product code: CEN-BIG-HYAMB-CBT

On successful Completion of the Career Enabler: Apache Spark Fundamentals course you will be able to:

• the purpose of Spark and understand why and when you would use Spark
• how to list and describe the components of the Spark unified stack
• the basics of the Resilient Distributed Dataset, Spark's primary data abstraction
• Learn how Spark performs at speeds up to 100 times faster than Map Reduce for iterative algorithms or interactive data mining.
• Learn how Spark provides in-memory cluster computing for lightning fast speed and supports Java, Python, R, and Scala APIs for ease of development
• Learn how Spark can handle a wide range of data processing scenarios by combining SQL, streaming and complex analytics together seamlessly in the same application
• Learn how Spark runs on top of Hadoop, Mesos, standalone, or in the cloud. It can access diverse data sources such as HDFS, Cassandra, HBase, or S3
• how to download and install Spark standalone
• an overview of Scala and Python

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

Product code: CEN-DSC-PYTH-CBT

On successful Completion of the Career Enabler: Introdution to Apache Hadoop course you will be able to:

• The definition of Big Data
• The Hadoop architecture including MapReduce and HDFS
• How to use the Hadoop file system shell and the Ambari Console to work with HDFS
• Starting and stopping Hadoop components
• How to add/remove a node to/from a Hadoop Cluster
• Determining how much space is available on each node in a Hadoop cluster
• How to modify Hadoop configuration parameters
• The concepts and purpose of other components such as MapReduce, Pig, Hive, Flume, Sqoop, and Oozie

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

Product code: CEN-DSC-PYTH-CBT

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 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 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 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 CBT:

Product code: WLN-INF-ETLFNDM

On successful Completion of the Informatica Data Integration & ETL BootCamp Self-Study CBT 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 CBT:

Product code: WLN-INF-ETLBC

On successful Completion of the Informatica 9.6.x Data Warehousing Fundamentals Self-Study CBT 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 CBT:

Product code: WLN-INF-DWFNDM

On successful Completion of the Informatica 9.6.x Data Warehousing BootCamp Self-Study CBT 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 CBT:

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 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 Career Enabler: 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-CBT

On successful Completion of the Oracle Analytics and Data warehousing Self-Study CBT 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 Oracle 11g Data Warehousing Fundamentals Self-Study CBT 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 CBT 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 CBT 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 Career Enabler: 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 Career Enabler: 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 Career Enabler: 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 Career Enabler: 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 CBT: 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 - 1Z0-052 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: OCA 1Z0-144 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 CBT 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 1Z0-591 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: 1Z0-061 and 1Z0-144 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: OCA 1Z0-144 Certification exams.

Product code: WLN-ORA-DB12C-PLSQL

On successful Completion of the Oracle Database 12c Administration Self-Study CBT 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 Career Enabler: 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 Career Enabler: 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 Career Enabler: 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