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 Career Enabler™ for SQL Server Business Intelligence course you will be able to:

• Comprehend fundamentals of Database Administration
• Comprehend Querying Databases
• Comprehend Data warehouse fundamentals
• Comprehend fundamentals of OLAP cubes
• Use SQL Server to implement a Data Warehouse
• Manage operations in SQL Server 2012 Databases
• Design and implement Business Intelligence Solutions in SQL Server 2012
• Comprehend fundamentals of Cloud Computing and SQL Azure

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

Product code: WLN-MSFT-BIDW

On successful Completion of the Career Enabler for MCSA: SQL Server 2014/2016 Certification course you will be able to:

• Create database objects
• Work with data
• Modify data
• Troubleshoot and optimize
• Install and configure
• Maintain instances and databases
• Optimize and troubleshoot
• Manage data
• Implement security
• Extract and transform data
• Load data
• Configure and deploy SSIS solutions
• Build data quality solutions

Certification: This course will assist in preparation for the MCSA SQL Server 2014/2016 Certification Certification exams.

Product code: WLN-MCSA-BIDW

On successful Completion of the Career Enabler: for MCSE SQL Server 2014/2016 BI Platform course you will be able to:

• Designing, configuring, installing, and administering the business intelligence platform of SQL 2014
• Designing databases for Analysis Services
• Designing BI solution architecture
• Administering, maintaining and troubleshooting SSAS database
• Designing tabular data models
• Generating reports with SRSS (SQL Server Reporting Services)
• Planning the complete BI infrastructure
• Creating Reporting Solutions
• Designing ETL Solutions
• Provisioning Hardware and Software services
• Designing Data mart and data warehouse structure
• Designing OLAP (Online Analytical Processing) cubes
• Integrating applications with business applications such as SharePoint etc.

Certification: This course will assist in preparation for the MCSE SQL Server BI Platform Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Career Enabler: for MCSE SQL Server 2014/2016 Data Platform course you will be able to:

• Designing, configuring, installing, and maintaining databases in a Microsoft enterprise set up
• Implementing and troubleshooting database objects in SQL Server
• Querying SQL 2014/2016 Server
• Administering SQL Server 2014 database environments
• Implementing data warehouse with SQL server 2014/2016
• Designing solutions for SQL 2014/2016 databases

Certification: This course will assist in preparation for the MCSE SQL Server 2014/2016 Data Platform Certification exams.

Product code: WLN-MSFT-DATPLAT

On successful Completion of the Data Science for Microsoft Developers course you will be able to:

• Describe and Understand Data Science and Machine Learning
• Describe the main categories of machine learning techniques
• Describe and Understand the Data Science Process
• Identify the steps in the machine learning process
• Describe what CRISP-DM is
• Describe and Understand Microsoft Analytics Tools
• Describe Oracle Data Miner
• Understand R Technologies in Microsoft
• Describe Microsoft R Enterprise Server
• Describe and Understand Data Science Algorithms supported by Microsoft
• Describe and Understand AI and Machine Learning Techniques supported by Microsoft
• Install and Configure Microsoft Advanced Analytics
• Describe Data Exploration and Preparation
• Describe classification and how classification can be supervised or unsupervised
• Understand and Perform Clustering Methods
• Understand and apply Association Rules
• Understand and apply Regression Analysis
• Understand and apply Classification Methods
• Understand and apply Neural Networks
• Understand and apply Solutions Deployment

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

Product code: CEN-DSORA-eBook

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

• Describe key concepts of Data Science
• Understand Open Source Data Science tools including R and Python
• Understand Open Source Data Science Tools and Platforms
• Understand Commercial Data Science tools including Microsoft Azure Machine Learning
• Prepare data for predictive modelling
• Visualize and explore data
• Develop Data Science solutions using R
• Develop R based Data Science solutions using Microsoft Azure ML
• Develop Data Science solutions using Microsoft Azure ML Studio
• Create supervised and unsupervised machine learning models

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

Product code: FND-DSCR-eBook

On successful Completion of the Foundations of Data Science with Microsoft Azure ML Self-Study eBook course you will be able to:

• Describe key concepts of Data Science
• Understand Open Source Data Science tools including R and Python
• Understand Open Source Data Science Tools and Platforms
• Understand Commercial Data Science tools including Microsoft Azure Machine Learning
• Prepare data for predictive modelling
• Visualize and explore data
• Develop Data Science solutions using Python
• Develop R based Data Science solutions using Microsoft Azure ML
• Develop Machine learning solutions using Microsoft Azure ML Studio
• Create supervised and unsupervised Data Science models

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

Product code: FDN-DSMSAZ-eBook

On successful Completion of the Foundations of Machine Learning with Azure ML course you will be able to:

• Describe key concepts of machine learning
• Understand Open Source Machine learning tools including Python
• Understand Open Source Machine learning Tools and Platforms
• Understand Commercial Machine learning tools including Microsoft Azure Machine Learning
• Prepare data for predictive modelling
• Visualize and explore data
• Develop Machine learning solutions using Python
• Develop R and Python Machine learning solutions using Microsoft Azure ML
• Develop Machine learning solutions using Microsoft AzureML Studio
• Create supervised and unsupervised machine learning models

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

Product code: FDN-MLMSAZ-eBook

On successful Completion of the Foundations of Data Science and Machine Learning course you will be able to:

• Describe key concepts of data science and machine learning
• Describe key concepts of machine learning
• Understand Open Source Machine learning tools including R and Python
• Understand Open Source Machine learning Platforms
• Understand Commercial Machine learning tools including Microsoft Azure Machine Learning
• Prepare data for predictive modelling
• Visualize and explore data
• Develop Machine learning solutions using R and Python
• Develop R Machine learning solutions using Microsoft AzureML
• Develop Machine learning solutions using Microsoft AzureML Studio
• Create supervised and unsupervised machine learning models

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

Product code: FDN-DSML-eBook

On successful Completion of the Data Science and Machine Learning Bootcamp course you will be able to:

• Describe key concepts of data science and machine learning
• Describe key concepts of machine learning
• Understand Open Source Data Science tools and Platforms including Spark, R and Python
• Understand Open Source Machine learning Tools and Platforms
• Understand Commercial Data Science tools including Microsoft Azure ML Studio and Oracle Advanced Analytics
• Learn to Install and Configure R and Python
• Learn to Configure Microsoft Azure ML for R and Python Development
• Prepare data for predictive modelling
• Visualize and explore data
• Create supervised and unsupervised machine learning models
• Develop Data Science solutions using R on Azure ML Platform
• Develop Machine learning solutions using R and Python
• Develop Machine learning solutions Microsoft Azure Notebooks
• Develop Data Science solutions using Microsoft Azure ML Studio

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

Product code: DSML-BCAMP-eBook

On successful Completion of the Data Science and Machine Learning with Azure ML course you will be able to:

• Describe key concepts of data science and machine learning
• Understand Open Source Machine learning tools including R and Python
• Understand Open Source Machine learning Platforms
• Understand Commercial Machine learning tools including Microsoft Azure Machine Learning
• Set Up a R Environment for Development
• Set Up a Python Environment for Development
• Prepare data for predictive modelling
• Visualize and explore data
• Develop Data Science solutions using R
• Develop R solutions using Microsoft Azure ML
• Develop Data Science solutions using Microsoft Azure ML Studio
• Develop Machine learning solutions using Microsoft Azure ML Studio
• Create supervised and unsupervised machine learning models

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

Product code: DSML-AZU-eBook

On successful Completion of the Career Enabler: Microsoft Big Data Analytics: Hadoop and Spark on HDInsight course you will be able to:

• Gain a high-level understanding of big data and Hadoop on HDInsight
• Understand Hadoop Components: MapReduce and HDFS
• Understand Hadoop Components: YARN and Apache Tez
• Understand HDInsight
• Understand HCatalog
• Understand development with Hive
• Understand development with Pig
• Understand development with HBase
• Understand Apache Storm on HDInsight
• Understand HDInsight clusters, cluster type, and configuration
• Understand extensibility and customizing HDInsight clusters using script actions
• Understand cluster security and operations
• Understand monitoring and managing Hadoop with Ambari web UI
• Understand Hadoop Clusters in HDInsight
• Gain a high-level understanding of Apache Spark
• Understand Resilient Distributed Datasets (RDDs) in Apache Spark
• Understand notebooks on Apache Spark
• Understand Spark with Azure HDInsight
• Understand Spark ML
• Understand Spark SQL
• Understand Hive and Power BI in Apache Spark
• Understand Spark Streaming
• Understand machine learning with Spark MLlib
• Understand R Server on HDInsight with Apache Spark

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-eBook

On successful Completion of the Career Enabler: Microsoft Big Data Analytics: Hadoop on HDInsight course you will be able to:

• Gain a high-level understanding of big data and Hadoop on HDInsight
• Understand Hadoop Components: MapReduce and HDFS
• Understand Hadoop Components: YARN and Apache Tez
• Understand HDInsight
• Understand HCatalog
• Understand development with Hive
• Understand development with Pig
• Understand development with HBase
• Understand Apache Storm on HDInsight
• Understand HDInsight clusters, cluster type, and configuration
• Understand extensibility and customizing HDInsight clusters using script actions
• Understand cluster security and operations
• Understand monitoring and managing Hadoop with Ambari web UI
• Understand Hadoop Clusters in HDInsight

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-eBook

On successful Completion of the Career Enabler: Microsoft Big Data Analytics: Spark on HDInsight course you will be able to:

• Gain a high-level understanding of Apache Spark
• Understand Resilient Distributed Datasets (RDDs) in Apache Spark
• Understand notebooks on Apache Spark
• Understand Spark with Azure HDInsight
• Understand Spark ML
• Understand Spark SQL
• Understand Hive and Power BI in Apache Spark
• Understand Spark Streaming
• Understand machine learning with Spark MLlib
• Understand R Server on HDInsight with Apache Spark

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

Product code: CEN-BIG-SPK-eBook

On successful Completion of the Career Enabler: Microsoft Big Data Analytics: Hadoop on Azure course you will be able to:

• Microsoft Big Data Fundamentals
• How to implement Hadoop on HDInsight
• Hive and Tez: Querying Big Data Essentials
• Pig, Sqoop, Oozie, and Mahout Essentials
• HBase Essentials
• Storm Essentials

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

Product code: CEN-BIG-HADAZU-eBook

On successful Completion of the Career Enabler: Foundations of Microsoft AI, Machine Learning and Big Data Platform course you will be able to:

• Gain a high-level understanding of SQL Server 2016/2017
• Understand the mission-critical and hybrid capabilities of SQL Server
• Gain a high-level understanding of Azure Data Services
• Gain a high-level understanding of Modern Data Warehouse
• Gain a high-level understanding of SQL Server BI
• Gain a high-level understanding of SQL Server Enterprise Information Management
• Gain a high-level understanding of Power BI
• Gain a high-level understanding of Azure Machine Learning
• Gain a high-level understanding of Azure Data Factory
• Gain a high-level understanding of SQL Server R Services
• Gain a high-level understanding of Hadoop on Azure
• Gain a high-level understanding of Azure Data Lake
• Gain a high-level understanding of Apache Spark

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

Product code: CEN-BIG-MSPLT-eBook

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

• Understand Data Warehousing Concepts
• Understand key SQL Data Warehouse concepts
• Understand the Data Warehouse and ETL Development Lifecycle
• Understand SQL Data Warehouse topology and architecture
• Understand Azure Data Warehouse database design
• Understand ETL (data access, data export) in SQL Data Warehouse
• Learn how to Extract, Transform, and Load (ETL) Data in Azure SQL Data Warehouse
• Understand data movement and distribution theory in SQL Data Warehouse
• Understand big data and SQL Server integration
• Understanding Azure Data Warehouse to BI integration, including with Power BI

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

Product code: WLN-MSFT-AZUDW

On successful Completion of the Fundamentals of SQL Server 2016 Platform course you will be able to:

• Gain a high-level understanding of SQL Server
• Understand the new features in SQL Server 2016
• Understand SQL Server In-Memory Optimization (OLTP)
• Understand SQL Server In-Memory Data Warehouse capabilities
• Understand SQL Server 2016 high-availability features
• Understand SQL Server 2016 SQL Server security features
• Understand SQL Server 2016 Query Store and Live Query Statistics
• Understand SQL Server 2016 Temporal Tables
• Understand the integration of SQL Server 2016 with big data sources with PolyBase
• Understand SQL Server 2016 Stretch Database
• Gain a high-level understanding of SQL Server R Services Analytics
• Understand SQL Server 2016 R Services integration

Certification: This course will assist in preparation for the Fundamentals of SQL Server 2016 Platform Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Fundamentals of SQL Server 2017 Platform course you will be able to:

• Gain a high-level understanding of SQL Server
• Understand the new features in SQL Server 2017
• Understand SQL Server In-Memory Optimization (OLTP)
• Understand SQL Server In-Memory Data Warehouse capabilities
• Understand SQL Server 2017 high-availability features
• Understand SQL Server 2017 SQL Server security features
• Understand SQL Server 2017 Query Store and Live Query Statistics
• Understand SQL Server 2017 Temporal Tables
• Understand the integration of SQL Server 2017 with big data sources with PolyBase
• Understand SQL Server 2017 Stretch Database
• Gain a high-level understanding of SQL Server R Services Analytics
• Understand SQL Server 2017 R Services integration

Certification: This course will assist in preparation for the Fundamentals of SQL Server 2017 Platform Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Fundamentals of Microsoft On-Premise and Cloud Data Warehousing 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 key SQL Server Data Warehouse concepts
• Understand SQL Data Warehouse topology and architecture
• Understand Azure Data Warehouse database design
• Understand ETL (data access, data export) in SQL Data Warehouse
• Understand data movement and distribution theory in SQL Data Warehouse
• Understand big data and SQL Server integration
• Understanding Azure Data Warehouse to BI integration, including with Power BI

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

Product code: WLN-MSFT-AZUDW

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 Career Enabler: Decision Modeling course you will be able to:

• Decision Modeling
• Decision Tree
• Supervised learning
• Unsupervised learning
• Artificial Neural Networks
• Twitter Data Processing with R

Certification: This course will assist in preparation for the Decision Modeling 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

On successful Completion of the Career Enabler: Microsoft Business Intelligence: Reporting and Analysis course you will be able to:

• Understanding the Microsoft BI Project Planning and Scoping Activities
• Capture Requirements for your BI Environment
• Understand the creation of Report ApplicationS
• Understand the creation of Technical Design Specification documents
• Components, architecture and nature of a BI solution
• Implement Dimensions in a cube
• Implement Measures and measure groups in a cube
• Understand Multidimensional Expressions (MDX) syntax
• Understand Cube customisation
• Implement tabular data model in SQL Server Analysis Services
• Enhance a tabular model using DAX
• Build queries in Microsoft BI Reporting Services
• Enhance Reports using charts and parameters
• Manage Report execution and Delivery

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 Microsoft SQL Server Analysis Services Essentials course you will be able to:

• Understand Key BI and OLAP Concepts
• Understand the BI and OLAP Development Life-cycle
• Implement analytical solutions
• Create multidimensional analysis solutions
• Implement dimensions and cubes
• Implement measures and measure groups
• Query a multidimensional Database
• Customise an Analysis Services cube
• Deploy and secure an Analysis Services database
• Maintain a multidimensional Analysis Services solution

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 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 Career Enabler: Microsoft SQL Server Reporting Services - Reporting Fundamentals course you will be able to:

• Understand SQL Server Reporting Services and its components
• Create a Reporting Services report
• Enhance a Reporting Services report
• Create and manipulate data sets
• Use report models to implement reporting for business users
• Configure report publishing and execution settings
• Implement subscriptions for reports
• Administer Reporting Services
• Implement custom Reporting Services applications

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 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 Microsoft Business Intelligence: Modelling and Reporting course you will be able to:

• Understanding the Microsoft BI Project Planning and Scoping Activities
• Capture Requirements for your BI Environment
• Understand the creation of Report Applications
• Understand the creation of Technical Design Specification documents
• Components, architecture and nature of a BI solution
• Implement Dimensions in a cube
• Implement Measures and measure groups in a cube
• Understand Multidimensional Expressions (MDX) syntax
• Understand Cube customisation
• Implement tabular data models in SSAS
• Enhance a tabular model using DAX
• Build queries in Microsoft BI Reporting Services
• Enhance Reports using charts and parameters
• Manage Report execution and Delivery

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

• Design, build, and use a relational database using proven methods
• Ensure database designs accurately model business requirements
• Normalize and denormalize your data to optimize performance
• Work with integrity constraints
• Automatically generate database documentation using CASE tools

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 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 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 Microsoft Database Design and Programming with SQL course you will be able to:

• Understand Relational Database Concepts
• Understand Types of Databases Models
• Understand Gathering Requirements for Database Design
• Understand the Stages of Database system Development
• Writing SELECT queries
• Sorting and filtering data
• Using SQL aggregate functions
• Using SET operators
• Writing joins to query multiple tables
• Using built-in functions
• Using Subqueries
• Inserting, updating, deleting and merging rows
• Transaction control
• Creating and using views
• Using table expressions
• Enhanced Grouping and Pivoting data
• Using Windowing ranking, offset and ranking functions
• Creating and using Stored Procedures
• Controlling Program Flow
• Using Dynamic SQL
• Implementing Error Handling
• Improving Query Performance

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

Product code: WLN-MSSQL-DEV

On successful Completion of the Microsoft SQL Server Database Query using T-SQL Fundamentals course you will be able to:

• Describe the basic architecture and concepts of Microsoft SQL Server 2014
• Understand the similarities and differences between Transact-SQL and other computer languages
• Write SELECT queries
• Query multiple tables
• Sort and filter data
• Describe the use of data types in SQL Server
• Modify data using Transact-SQL
• Use built-in functions
• Group and aggregate data
• Use subqueries
• Use table expressions
• Use set operators
• Use window ranking, offset and aggregate functions
• Implement pivoting and grouping sets
• Execute stored procedures
• Program with T-SQL
• Implement error handling
• Implement transactions

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

Product code: WLN-MSSQL-TSQL

On successful Completion of the Microsoft SQL Server 2016 Database Administration and Development course you will be able to:

• Understand SQL Server Data Tools
• Learn Data Definition Lanaguage - DDL
• Learn Data Manipulation Language - DML
• Learn Data Control Language - DCL
• Describe Microsoft Database Architecture
• Manage the Microsoft Database Instance
• Manage Microsoft Database Storage structures
• Create and Administer User Accounts
• Monitor the Database
• Manage Database Performance
• Implement Database Auditing
• Configure Microsoft Database Instance
• 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 MCSE Certification exams.

Product code: WLN-MSSQL-ADMIN

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

• Understand SQL Server Data Tools
• Describe Microsoft Database Architecture
• Manage the Microsoft Database Instance
• Manage Microsoft Database Storage structures
• Create and Administer User Accounts
• Monitor the Database
• Manage Database Performance
• Implement Database Auditing
• Configure Microsoft Database Instance
• 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 MCSE Certification Examinations

Product code: WLN-MSSQL-ADMIN

On successful Completion of the Microsoft SQL Server Database Development course you will be able to:

• Understand Relational Database Concepts
• Understand SQL Server Data Tools
• Writing SELECT queries
• Sorting and filtering data
• Using SQL aggregate functions
• Using SET operators
• Writing joins to query multiple tables
• Using built-in functions
• Using Subqueries
• Inserting, updating, deleting and merging rows
• Transaction control
• Creating and using views
• Using table expressions
• Enhanced Grouping and Pivoting data
• Using Windowing ranking, offset and ranking functions
• Creating and using Stored Procedures
• Controlling Program Flow
• Using Dynamic SQL
• Implementing Error Handling
• Improving Query Performance

Certification: This course will assist in preparation for the Microsoft SQL Server MCSE Certification Examinations.

Product code: WLN-MSSQL-ADMIN

On successful Completion of the Microsoft SQL Server 2016 Database Development course you will be able to:

• Understand Relational Database Concepts
• Designing and implementing normalized database schemas
• Understand SQL Server Data Tools
• Writing SELECT queries
• Sorting and filtering data
• Using SQL aggregate functions
• Using SET operators
• Writing joins to query multiple tables
• Using built-in functions
• Using Subqueries
• Inserting, updating, deleting and merging rows
• Transaction control
• Creating and using views
• Using table expressions
• Enhanced Grouping and Pivoting data
• Using Windowing ranking, offset and ranking functions
• Creating and using Stored Procedures
• Controlling Program Flow
• Using Dynamic SQL
• Creating Programmatic Database Objects
• Managing Transactions and Concurrency
• Implementing In-Memory Database Objects
• Optimizing Performance for SQL Based Applications
• Implementing Error Handling
• Improving Query Performance

Certification: This course will assist in preparation for the Microsoft SQL Server MCSE Certification Examinations.

Product code: WLN-MSSQL-ADMIN

On successful Completion of the SQL Server Database Design and Development course you will be able to:

• Understand Relational Database Concepts
• Understand Types of Databases Models
• Understand Gathering Requirements for Database Design
• Understand the Stages of Database system Development
• Designing and implementing normalized database schemas
• Understand SQL Server Data Tools
• Writing SELECT queries
• Sorting and filtering data
• Using SQL aggregate functions
• Using SET operators
• Writing joins to query multiple tables
• Using built-in functions
• Using Subqueries
• Inserting, updating, deleting and merging rows
• Transaction control
• Creating and using views
• Using table expressions
• Enhanced Grouping and Pivoting data
• Using Windowing ranking, offset and ranking functions
• Creating and using Stored Procedures
• Controlling Program Flow
• Using Dynamic SQL
• Implementing Error Handling
• Improving Query Performance

Certification: This course will assist in preparation for the Microsoft SQL Server MCSE Certification Examinations.

Product code: WLN-MSSQL-ADMIN

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

• 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
• Normalize the Entity Relationship Diagram to third Normal form
• Enhance the Entity Relationship Diagram to utilize several data modeling techniques
• Engineer the Entity Relationship Model into an initial relational database design
• Optimize the Relational Database Design
• Complete the Physical Model and generate the DDL

Certification: This course will assist in preparation for the Microsoft SQL Server MCSE Certification Examinations.

Product code: WLN-MSSQL-ADMIN

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

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Understand the steps for completing the full accounting cycle
• Understand the ledger concept
• Apply concepts of Legal Entity and Ledger
• Understand how Oracle General Ledger integrates with the eBusiness Suite of applications
• Implement features of Journal Creation, Posting, Reversal, Recurring of Journal
• Implement functionalities around Mass Allocation and Revaluation
• Apply concepts of Consolidation
• Implement features of Translation
• Implement features of Financial Reporting

Certification: This course will assist in preparation for the Oracle Financial Management Certified Implementation Specialist (1Z0-516) Certification exams.

Product code: WLN-EBSGL-1Z0-516

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

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Understand the Order to Cash Lifecycle
• Understand the Oracle Receivables process
• Manage parties and customer accounts
• Process invoices using Auto-Invoice
• Utilize the bill presentment architecture processes
• Set up credit management
• Implement the receipt process
• Implement tax processing and period closing

Certification: This course will assist in preparation for the Oracle Financial Management Certified Implementation Specialist (1Z0-518) Certification exams.

Product code: WLN-EBSAR-1Z0-518

On successful Completion of the Oracle Financials R12.1: Payables Essentials Self-Study eBook course you will be able to:

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Apply concepts of Procure-to-Pay process flow
• Implement key features of Oracle Payables
• Implement key functionalities of Suppliers
• Implement functionalities around Invoices
• Implement key features of Payments
• Implement key features of Expense Reports and Credit Cards

Certification: This course will assist in preparation for the Oracle Financial Management Certified Implementation Specialist (1Z0-517) Certification exams..

Product code: WLN-EBSAP-1Z0-517

On successful Completion of the Oracle EBS R12.1 HR Compensation and Benefits Management course you will be able to:

• Identify the compensation management tools that Oracle HRMS provides
• Identify and explain compensation management features and benefits
• Identify salary components, salary basis, and salary elements
• Learn how to administer salary changes
• Learn how to enter and maintain compensation survey data
• Learn how to set up grade rates, pay scales, and scale rates
• Understand the grade/step progression business process
• Understand the HCM/HRMS Total Compensation model
• Define and manage elements
• Handle benefits enrollments
• Explain the framework for Compensation and Benefits setup and administration in Oracle HCM/HRMS
• Discuss the use of elements to represent different types of earnings and deductions in Oracle HCM
• Discuss how the same elements are used by HCM, Payroll and Benefits and discuss any differences
• Explain the difference between recurring and nonrecurring types of elements
• Recognise the predefined elements in Oracle HCM
• Identify the predefined elements installed with Oracle HRMS products
• Explain the use of Elements to represent values for different types of earnings and deductions
• Explain the differences between recurring and nonrecurring types of elements
• Implement and administer Compensation Workbench
• Set up and administer Individual Compensation Distributions (ICD)
• Maintain a vehicle repository and allocate company vehicles to employees
• Use absence types, categories, and reasons to track and report employee absences

Certification: This course will assist in preparation for the Oracle Human Capital Management Certified Implementation Specialist (1Z0-548) Certification exams.

Product code: WLN-EBSHCM-BM

On successful Completion of the Oracle EBS R12.1 HR Payroll Administration course you will be able to:

• Understand the Oracle Applications Footprint
• Navigate Oracle Applications
• Identify the types of payroll processes available in Oracle HRMS
• Identify the payroll lifecycle periods
• Use Advance Pay and RetroPay
• Make balance adjustments
• Make corrections, rollbacks, reversals, and retries
• Use the special features of Oracle Payroll
• View and adjust employee balances
• Understand the payroll lifecycle
• Run payrolls using batch and QuickPay processes
• Run prepayments and payments processes
• Run costing and transfer to GL processes
• Manage exceptions and corrections

Certification: This course will assist in preparation for the Oracle Human Capital Management Certified Implementation Specialist (1Z0-548) Certification exams.

Product code: WLN-EBSHCM-PY

On successful Completion of the Oracle EBS R12.1 HR Talent and Performance Management course you will be able to:

• Create competencies and competency profiles
• Define competency requirements for business groups, organizations, and jobs
• Record worker qualifications
• Configure appraisals using appraisal and assessment templates and conduct appraisals
• Assess competencies and objectives during appraisals
• Create objectives in the Objectives Library
• Create performance management plans to manage workforce performance
• Use performance management tasks to set objectives and manage appraisals in a performance management plan

Certification: This course will assist in preparation for the Oracle Human Capital Management Certified Implementation Specialist (1Z0-548) Certification exams.

Product code: WLN-EBSHCM-TPM

On successful Completion of the Oracle EBS R12.1 HR Self-Service Applications course you will be able to:

• Understand the terminology and concepts used in SSHR
• Identify which functions are available and understand the difference between employee and manager functions
• Understand how different users can use self-service applications
• Understand the architecture of the E-business Suite
• Understand how self-service functions operate
• Understand how different elements determine how the function operates
• Understand how Workflow Builder operates
• Understand how Oracle Application Framework operates
• Understand how Data Security operates
• Learn how to create custom menus containing required functions
• Understand the different approvals mechanisms
• Use Oracle Approvals Management
• Configure approvals
• Understand which self-service applications are available in HRMS
• Integrate and access personal information and absence policies on a third party applications
• Configure elements of SSHR to suit your requirements

Certification: This course will assist in preparation for the Oracle Human Capital Management Certified Implementation Specialist (1Z0-548) Certification exams.

Product code: WLN-EBSHCM-SSHR

On successful Completion of the Primavera P6 Project Management Fundamentals course you will be able to:

• Create a project
• Create a Work Breakdown Structure
• Add activities
• Customize activity views
• Create relationships
• Schedule the project
• Assign constraints
• View the Enterprise Project Structure
• Optimize the project schedule
• Assign roles and resources
• Analyze resources and costs
• Baseline the project plan
• Execute the project
• Customize dashboards
• Manage risk
• View reports

Certification: This course will assist in preparation for the Primavera P6 Enterprise Project Portfolio Management 8 Essentials - 1Z0-567 Exam.

Product code: WLN-P6-PMF

On successful Completion of the Primavera Portfolio Management Essentials course you will be able to:

• Understand portfolio management
• Understand the Primavera approach to portfolio management
• Use and create forms and scorecards
• Customise a scorecard
• Use investor maps, workbooks and dashboards
• Create portfolios
• Enter data in a form
• Use and create processes
• Start a workflow
• Create process links
• Track deliverables in a workbook
• View dashboards
• View an investor map
• View items in Primavera portfolio management

Certification: This course will assist in preparation for the Primavera Portfolio Management Essentials - 1Z0-544 Exam

Product code: WLN-P6-POM

On successful Completion of the Weblogic Server 11g: Administration Fundamentals course you will be able to:

• Describe the architecture of WebLogic Server including domains, servers and machines
• Install, configure and use WebLogic Server
• Perform routine Oracle WebLogic Server administration functions
• Set up a cluster of servers and distribute applications and resources to the cluster
• Deploy different types of Java EE applications to Oracle WebLogic Server

This course will assist in preparation for the Oracle Certified Associate - OCA 1Z0-102 and 1Z0-133 Certification exams.

Product code: WLN-WLS11G-FDM-eBook

On successful Completion of the Weblogic Server 11g: Advanced Administration course you will be able to:

• Describe the architecture of WebLogic Server including domains, servers and machines
• Install and configure WebLogic Server and SIP Container
• Define a JDBC data source for load balancing and failover
• Configure JMS to guarantee message delivery
• Configure JMS load balancing and failover in a cluster
• Configure JMS store and forward features
• Replicate HTTP sessions using multiple clusters
• Integrate WebLogic Server with an external LDAP server
• Utilise LDAP for authentication
• Configure and monitor server network channels
• Define server work managers
• Create custom domain and extension templates
• Set up a cluster of servers and distribute applications and resources to the cluster
• Deploy different types of Java EE applications to Oracle WebLogic Server
• Describe the architecture of WebLogic Server SIP Container and Coherence
• Configure a highly available database infrastructure using Oracle RAC
• Monitor servers using Diagnostics Framework or WLDF
• Tune a Java VM for performance

This course will assist in preparation for the Oracle Certified Associate - OCA 1Z0-102 and 1Z0-133 Certification exams.

Product code: WLN-WLS11G-FDM-eBook

On successful Completion of the Weblogic Server 11g: Administration I course you will be able to:

• Describe the architecture of WebLogic Server including domains, servers and machines
• Install and configure WebLogic Server and SIP Container
• Define a JDBC data source for load balancing and failover
• Configure JMS to guarantee message delivery
• Configure JMS load balancing and failover in a cluster
• Configure JMS store and forward features
• Replicate HTTP sessions using multiple clusters
• Integrate WebLogic Server with an external LDAP server
• Utilise LDAP for authentication
• Configure and monitor server network channels
• Define server work managers
• Create custom domain and extension templates
• Set up a cluster of servers and distribute applications and resources to the cluster
• Deploy different types of Java EE applications to Oracle WebLogic Server
• Describe the architecture of WebLogic Server SIP Container and Coherence
• Configure a highly available database infrastructure using Oracle RAC
• Monitor servers using Diagnostics Framework or WLDF
• Tune a Java VM for performance

This course will assist in preparation for the Oracle Certified Associate - OCA 1Z0-102 and 1Z0-133 Certification exams.

Product code: WLN-WLS11GI-eBook

On successful Completion of the Weblogic Server 12c: Administration I course you will be able to:

• Describe the architecture of Oracle Cloud and Fusion Middleware
• Describe the architecture of WebLogic Server including domains, servers and machines
• Install, configure, and administer Oracle WebLogic Server
• Install and configure Oracle HTTP Server (OHS)
• Deploy applications to WebLogic Server
• Backup and restore a WebLogic Server domain
• Create a WebLogic Server domain
• Configure and monitor WebLogic Server
• Set up and use node manager
• Configure WebLogic Server database resources
• Create and configure a WebLogic Server cluster
• Create and configure a WebLogic Dynamic cluster
• Configure WebLogic Server's authentication provider

This course will assist in preparation for the Oracle Certified Associate - OCA 1Z0-102 and 1Z0-133 Certification exams.

Product code: WLN-WLS12CI-eBook

On successful Completion of the Weblogic Server 12c: Administration II course you will be able to:

• Describe the architecture of WebLogic Cloud
• Describe Cloud Application Foundation concepts
• Install and configure WebLogic Server
• Describe the architecture of WebLogic Server Coherence
• Create and use domain templates
• Create and use Server Templates
• Configure Clusters
• Create and use Dynamic Clusters
• Configure advanced JDBC features
• Describe ActiveCache (WLS and Coherence)
• Configure a highly available database infrastructure using Oracle RAC
• Configure Network Channels
• Configure Virtual Hosts
• Utilise LDAP for authentication
• Configure SSL for WebLogic Server
• Configure and use WebLogic Diagnostic Framework (WLDF)

This course will assist in preparation for the Oracle Certified Professional - OCA 1Z0-102 and 1Z0-134 Certification exams.

Product code: WLN-WLS12CI-eBook

On successful Completion of the Oracle Fusion Middleware 11g: Administration BootCamp course you will be able to:

• Describe Oracle Fusion Middleware (FMW)
• Identify and describe FMW Java components
• Identify and describe FMW system component
• Identify the system administration tools for managing FMW
• Manage log files by using FMW Control
• Access FMW Control
• Start and stop instances of WebLogic Server by using FMW Control
• Deploy applications by using FMW Control
• Monitor a WebLogic Server (WLS) domain with FMW Control
• Monitor applications with FMW Control
• View domain topology through FMW Control
• View diagnostic data with FMW Control
• Centrally manage Java components using the Oracle WebLogic Server Administration Console
• Stop and start FMW Java components
• Use Fusion Middleware Control to diagnose and resolve issues
• Understand Back Up and Recovery of Fusion Middleware Components

This course will assist in preparation for the Oracle Certified Professional - OCA 1Z0-102 and 1Z0-134 Certification exams.

Product code: WLN-FMW-11G-eBook

On successful Completion of the IBM WebSphere Server 8.5.x Administration BootCamp Self-Study eBook course you will be able to:

• Relate WebSphere Application Server to the WebSphere family of products
• Features and standards in WebSphere Application Server 8.5.x
• Architectural concepts related to WebSphere Application Server
• Architectural concepts related to WebSphere Liberty Profile
• Install and configure WebSphere Application Server 8.5.5.x
• Basic concepts of the Java Platform, Enterprise Edition (Java EE 6/7 and Java SE 7)
• Assemble and install server-side Java enterprise applications
• Use WebSphere administrative tools to configure and manage enterprise applications
• Use the wsadmin scripting library
• Configure WebSphere Application Server security
• Deploy applications in clustered environments
• View performance information about server and application components
• Use problem determination tools and log files to troubleshoot problems
• Configure messaging with the service integration bus
• Describe Intelligent Management features
• Describe WebSphere Batch features
• Describe the Liberty profile

IBM WebSphere Server 9.x Administration Fundamentals Self-Study eBook.

Product code: WLN-WAS9-eBook

On successful Completion of the IBM WebSphere Server 9.x Administration BootCamp course you will be able to:

• Relate WebSphere Application Server to the WebSphere family of products
• Features and standards in WebSphere Application Server 9.x
• Architectural concepts related to WebSphere Application Server Traditional
• Architectural concepts related to WebSphere Liberty Profile
• Install and configure WebSphere Application Server 9.x Traditional and Liberty Profile
• Basic concepts of the Java Platform, Enterprise Edition (JJava EE 7, Java EE 7 Web Profile and Java SE 8)
• Assemble and install server-side Java enterprise applications
• Use WebSphere administrative tools to configure and manage enterprise applications
• Use the wsadmin scripting library
• Configure WebSphere Application Server security
• Deploy applications in clustered environments
• View performance information about server and application components
• Use problem determination tools and log files to troubleshoot problems
• Configure messaging with the service integration bus
• Describe Intelligent Management features
• Describe WebSphere Batch features
• Describe the Liberty profile
• Install and configure the Liberty profile

IBM WebSphere Server 9.x Administration Fundamentals Self-Study eBook.

Product code: WLN-WAS9-eBook

On successful Completion of the Oracle BI 11g: Scorecarding and Strategy Management course you will be able to:

• Create a Strategy map within Scorecard
• Create a Strategy tree within Scorecard
• Create a Cause & Effect map within Scorecard
• Create Mission and Vision statements within Scorecard
• Create KPIs
• Create Agents
• Create a stand-alone KPI watchlist
• Create Scorecards and associated objects
• Add Scorecards to a Dashboard
• Create a KPI and KPI watchlist within Scorecard
• Create Objectives within Scorecard
• Create Initiatives within Scorecard
• Create a Perspective within Scorecard
• Create comments for collaboration within Scorecard

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

Product code: WLN-OBI-SSC

On successful Completion of the Hyperion EPM Financial Management 11.1.x Interactive Users Self-Study eBook course, you should be able to:

• Understand Business Intelligence and OLAP Concepts
• Understand Hyperion FM and Essbase Concepts
• Understand the Analysis, Design of Hyperion FM Applications
• Analyze and enter data in Smart View
• Create reports in Financial Reporting
• Navigate Financial Management
• Translate data
• Enter and calculate data
• Create journal entries
• Enter intercompany data
• Consolidate data

Certification: This course will assist in preparation for the Oracle Hyperion FM Certfied Implementation Specialist - 1Z0-532 Certification exam..

Product code: WLN-HFM-IU

On successful Completion of the Hyperion Planning 11.1.2 Certified Implementation Specialist course you will be able to:

• Create Planning applications
• Navigate Workspace in Planning
• Create data forms and folders
• Customize data forms
• Enter data in Planning
• Enter data in Smart View
• Create business rules
• Manage business rules
• Add variables and formulas to business rules
• Manage the approval process
• Create task lists
• Identify the Planning installation requirements
• Describe the architecture of WebLogic Server
• Understand WebLogic Server domains, servers and machines
• Install and configure WebLogic Server
• Install and configure Foundation Services and Essbase
• Design and manage Essbase security
• Install and configure Planning
• Verify the Planning installation
• Perform backup, recovery, application migration, and task automation

Certification: This course will assist in preparation for the Oracle Hyperion Planning 11 Specialist - 1Z0-533 Certification exam.

Product code: WLN-HFM-IS

On successful Completion of the Hyperion FM 11.1.2 Certified Implementation Specialist course you will be able to:

• Use EPM Workspace
• Manage Financial Management Applications
• Create Classic Planning Applications
• Create applications and setting up profiles
• Load data to HFM and the various alternatives available for developers
• Work with formulas, add charts, deploy reports with books and batches
• Build reports using the Smart View client
• Address management issues such as security, backing up Reports
• Understand Performance Management Architecture and Infrastructure
• Install and Configure Hyperion EPM Financial Management System 11.1.2
• Install and Configure Hyperion Financial Management 11.1.2 Server and Clients
• Understand EPM Foundation Modules including Essbase
• Understand EPM System Applications
• Understand EPM Architect Modules
• Understand EPM System Integration with Oracle BIEE
• Understand and use Shared Services
• User Management, including: User provisioning, External authentication definition
• Understand Lifecycle Management and for Migrations

Certification: This course will assist in preparation for the Hyperion Financial Management 11.1.2: Implementation Specialist - 1Z0-532 Certification exam.

Product code: WLN-HFM-IS

On successful Completion of the Hyperion FM 11.1.2: Create & Manage Applications course you will be able to:

• Navigate Workspace
• Navigate Financial Management
• Import and export data and metadata
• Create and deploy an application
• Enter data in data forms and data grids
• Enter data in data grids
• Enter data in data forms 
• Adjust data with journals 
• Process and report on journals 
• Eliminate intercompany balances 
• Manage intercompany transactions 
• Run consolidations 
• Manage the review cycle through Process Management
• Synchronize data 
• Automate Tasks 
• Analyze data with Smart View 
• Enter data by using data forms in Smart View
• Analyze data with Smart View functions

Certification: This course will assist in preparation for the Hyperion Financial Management 11.1.2: Implementation Specialist - 1Z0-532 Certification exam.

Product code: WLN-HFM-IS

On successful Completion of the Hyperion Planning & Essbase 11.1.2: Fundamentals course you will be able to:

• Configure Hyperion EPM Planning and Essbase System 11.1.2
• Understand EPM Foundation Modules including Essbase
• Understand EPM System Web Components
• Understand EPM System Applications
• Understand EPM Architect Modules
• Understand Oracle BI Enterprise Edition Products and Architecture
• Understand the Plus Components of OBIEE
• Understand and use Shared Services
• User Management, including: User provisioning, External authentication definition
• Understand Lifecycle Management and for Migrations
• Understand the Deployment Architecture for EPM 11.1.x Applications
• Use EPM Workspace including building Portal Pages
• Manage and use Planning Applications
• Develop Essbase OLAP Applications
• Develop Essbase OLAP ASO and BSO Cubes

Certification: This course will assist in preparation for the Oracle Hyperion Planning 11 Specialist - 1Z0-533 Certification exam.

Product code: WLN-HPNESS-eBook

On successful Completion of the Hyperion Planning 11.1.2 Create and Manage Applications eBook course you will be able to:

• Create Planning applications
• Navigate Workspace in Planning
• Create data forms and folders
• Customize data forms
• Enter data in Planning
• Enter data in Smart View
• Create business rules
• Manage business rules
• Add variables and formulas to business rules
• Manage the approval process
• Create task lists

Certification: This course will assist in preparation for the Oracle Hyperion Planning 11 Specialist - 1Z0-533 Certification exam.

Product code: WLN-HPLN-CM

On successful Completion of the Oracle Business Intelligence 11g Foundation Suite Essentials Self-Study eBook course you will be able to:

• Understand Oracle BI Suite Enterprise Edition Plus
• Understand Hyperion Performance Management Architecture
• Understand and Explore OBI Administration Tools
• Build queries in Oracle BI Answers
• Create and modify Oracle BI Interactive Dashboards
• Understand Strategy and Scorecard Management Concepts
• Create KPI and KPI Watch lists
• Build Oracle BI Publisher reports
• Use EPM Workspace
• Understand Hyperion Essbase
• Understand and use SmartView
• Understand Essbase Integration with Oracle BIEE

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 Oracle Business Intelligence 11g: Analyses and Dashboards course you will be able to:

• Build queries in Oracle BI Analyses
• Customize the Oracle BI user interface
• Create and modify Oracle BI Interactive Dashboards
• Create and work with KPIs
• Use Oracle BI Content in your Microsoft Office documents
• Use Oracle BI Delivers to configure, schedule, and deliver personalized alerts
• Create and modify Business Intelligence Analysis using Oracle Business Intelligence Analyses
• Work with views to display request information
• Create and modify Interactive Dashboards
• Create guided navigation links within Interactive Dashboards
• Use Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts
• Work with Oracle BI Presentation Services content in Microsoft Office applications
• Build Oracle BI Publisher reports based on Analyses Analysis and BI metadata subject areas
• Integrate Oracle BI Publisher reports in Interactive Dashboards
• 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 Oracle Business Intelligence 11g Administration Self-Study eBook course you will be able to:

• Oracle Business Intelligence Administration
• Rounded v-neckline
• Pom pom trims
• Regular fit – true to size

Oracle Business Intelligence 11g Administration Self-Study eBook.

Product code: WLN-OBIEE-ADM

On successful Completion of the Oracle Business Intelligence & BI Publisher BootCamp course you will be able to:

• Create and modify Business Intelligence analysis using Oracle Business Intelligence Analyses
• Combine analysis criteria using set operations and execute direct database requests
• Work with views to display analysis information
• Create and modify Interactive Dashboards
• Create guided navigation links within Interactive Dashboards
• Use Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts
• Work with Oracle BI Presentation Services content in Microsoft Office applications
• Describe BI Publisher Technology and Architecture
• Create and Modify Data Models
• Create Layouts by Using the Layout Editor
• Create RTF Templates by Using Template Builder
• Define parameters and LOVs for a data model
• Create BI Publisher reports based on data models
• Create report layouts by using the Layout Editor (online)
• Analyze data by using the Excel Analyzer
• Create Reports Integrated With Oracle BIEE
• Administer BI Publisher Server
• Build Oracle BI Publisher reports based on Answers requests and BI metadata subject

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 Oracle Business Intelligence & BI Publisher course you will be able to:

• Understand Oracle BI Foundation Suite
• Understand Enterprise Reporting Architectures
• Understand Reports Development Lifecycle
• Describe BI Publisher Technology and Architecture
• Configuring the Data Sources
• Create and Modify Data Models
• Create Layouts by Using the Layout Editor
• Create RTF Templates by Using Template Builder
• Define parameters and LOVs for a data model
• Create BI Publisher reports based on data models
• Create report layouts by using the Layout Editor (online)
• Analyze data by using the Excel Analyzer
• Create Reports Integrated With Oracle BIEE
• Administer BI Publisher Server

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 SAP BusinessObjects XI WebIntelligence: Data Analysis & Visualisation course you will be able to:

• BusinessObjects Enterprise XI Architecture
• BusinessObjects Enterprise XI 4.x Architecture
• SAP BusinessObjects XI 4.1 Client Tools
• The Query and Analysis Continuum
• Business Intelligence and OLAP Concepts
• Business Objects and Data Warehouse Concepts
• Enterprise Reporting Architectures
• Introduction to Business Intelligence Platforms
• Understand the Report Development Process
• Create Web Intelligence Reports
• Analyse Data in Drill Mode
• Work with InfoView and BI Launchpad
• Analyzing Data using Web Intelligence
• Share Web Intelligence Documents
• Schedule Web Intelligence documents
• Work with SAP Web Intelligence 4.x BI Launchpad
• Work with SAP Web Intelligence 4.x Queries Using Bex
• Work with SAP Web Intelligence 4.x Queries Using Analysis View

Certification: This course will assist in preparation for the SAP BusinessObjects XI WebIntelligence Certification exams.

Product code: WLN-OBIEE-FDN

On successful Completion of the SAP BusinessObjects XI:Data Analysis & Reporting course you will be able to:

• BusinessObjects Enterprise XI Architecture
• BusinessObjects Enterprise XI 4.x Architecture
• SAP BusinessObjects XI 4.1 Client Tools
• The Query and Analysis Continuum
• Business Intelligence and OLAP Concepts
• Business Objects and Data Warehouse Concepts
• Enterprise Reporting Architectures
• Introduction to Business Intelligence Platforms
• Understand the Report Development Process
• Create Web Intelligence Reports
• Analyse Data in Drill Mode
• Work with InfoView and BI Launchpad
• Analyzing Data using Web Intelligence
• Share Web Intelligence Documents
• Schedule Web Intelligence documents
• Creating Desktop Intelligence Documents
• Synchronizing Data from Multiple Data Providers
• Format Desktop Intelligence Documents
• Create Variables and Alerters
• Schedule Desktop Intelligence Documents
• Create Variables and Alerters
• Work with SAP Web Intelligence 4.x BI Launchpad
• Work with SAP Web Intelligence 4.x Queries Using Bex
• Work with SAP Web Intelligence 4.x Queries Using Analysis View

Certification: This course will assist in preparation for the SAP BusinessObjects XI Certification exams.

Product code: WLN-BOBJ-DAR

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 Microsoft SQL Server Reporting Services (SSRS) Fundamentals course you will be able to:

• Understand SQL Server Reporting Services and its components
• Create a Reporting Services report
• Enhance a Reporting Services report
• Create and manipulate data sets
• Use report models to implement reporting for business users
• Configure report publishing and execution settings
• Implement subscriptions for reports
• Administer Reporting Services
• Implement custom Reporting Services applications

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

Product code: WLN-MSFT-BIDW

On successful Completion of the Cognos BI: Report Studio Fundamentals course you will be able to:

• Explore Report Studio, different report types (list, crosstab, chart, map)
• Create and Format reports using grouping, headers, footers, and other formatting options
• Focus reports by filtering data and using prompts
• Add value to your reports using calculations and additional report building techniques
• Enhance reports with advanced formatting and exceptional data highlighting
• Author reports through query models
• Set up drill-through access and Create drill-through reports
• Manage content in Cognos Connection

Certification: This course will assist in preparation for the Cognos 8 and 10 Business Intelligence Certification exams.

Product code: WLN-COG-BI-REPSTD

On successful Completion of the Cognos BI:Data Analysis and Visualisation course you will be able to:

• Understand Key BI and OLAP Concepts
• Understand Cognos BI: Analysis Studio Concepts
• Understand Data Analysis and Visualisation Concepts
• Explore Analysis Studio, different report types (list, crosstab, chart, map)
• Create and Format reports using grouping, headers, footers, and other formatting options
• Focus reports by filtering data and using prompts
• Add value to your reports using calculations and additional report building techniques
• Enhance reports with advanced formatting and exceptional data highlighting
• Author reports through query models
• Set up drill-through access and Create drill-through reports
• Manage content in Cognos Connection

Certification: This course will assist in preparation for the Cognos 8 and 10 Business Intelligence Certification exams.

Product code: WLN-COG-BIDAVIS

On successful Completion of the Cognos BI: Reporting & Analysis BootCamp course you will be able to:

• Understand IBM Cognos BI
• Create Reports in Report Studio
• Enhance Reports in Report Studio
• Customise Reports in Report Studio
• Analysis Studio Fundamentals
• Tools for Investigation in Analysis Studio
• Nest Data in Crosstabs in Analysis Studio
• Build Advanced Crosstabs in Analysis Studio
• Focus with Filters in Analysis Studio
• Extend the Analysis
• Manage Content in Cognos Connection

Certification: This course will assist in preparation for the Cognos 8 and 10 Business Intelligence Certification exams.

Product code: WLN-COG-BIRAS-BC

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

Product code: WLN-INF-ETLFNDM

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

Product code: WLN-INF-ETLBC

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

Product code: WLN-INF-DWFNDM

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

Product code: WLN-INF-DWBC

On successful Completion of the Oracle 11g Data Warehousing Fundamentals Self-Study eBook 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 eBook 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 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 Database Development Essentials course you will be able to accomplish the following:

• Understand Relational Database Concepts
• Understand Types of Databases Models
• Understand Gathering Requirements for Database Design
• Understand the Stages of Database system Development
• Understand Oracle Database Development Tools
• 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 to generate and retrieve customised 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 in the Oracle Database
• Understand Oracle PL/SQL Programming

Product code: WLN-ORADB-DESDEV-1Z0-051-eBook

This course introduces students to the Oracle Database 12c: Managing Multitenant Architecture technology. This course covers all aspects of the multitenant architecture, providing detailed information on the components of a CDB and its regular and application PDBs. You learn why and how to create and manage a CDB and its regular and application PDBs, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged PDBs in CDBs using various methods.
On successful Completion of the course you will be able to accomplish the following:

• Manage PDB snapshots
• Encrypt data in PDBs and isolate PDB keystore
• Monitor performance in CDBs and PDBs
• Audit users in CDB and PDBs
• Protect data with Database Vault policies in CDB and PDBs
• Manage a CDB fleet
• Manage resource allocation between PDBs and within a PDB
• Use Data Pump operations from a non-CDB or CDB into a PDB
• Upgrade 11g to 12c CDBs or PDBs
• Upgrade 12c CDBs or PDBs to 12c R2
• Configure and create a CDB
• Create, clone, unplug, plug, relocate, proxy, switch over and drop PDBs
• Startup and shutdown CDBs and PDBs
• Manage tablespaces in CDB and PDBs
• Manage common and local users, roles, privileges, profiles, objects in CDBs and PDBs
• Manage PDB lockdown profiles
• Backup, duplicate, recover and flashback CDB and PDBs

This course will assist in preparation for the Oracle Database 12c: OCA 1Z0-149 Certification exams.

Product code: WLN-ORA-DB12C-MULTI

This course introduces students to the Oracle Database 18c: Managing Multitenant Architecture technology. This course covers all aspects of the multitenant architecture, providing detailed information on the components of a CDB and its regular and application PDBs. You learn why and how to create and manage a CDB and its regular and application PDBs, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged PDBs in CDBs using various methods.
On successful Completion of the course you will be able to accomplish the following:

• Manage PDB snapshots
• Encrypt data in PDBs and isolate PDB keystore
• Monitor performance in CDBs and PDBs
• Audit users in CDB and PDBs
• Protect data with Database Vault policies in CDB and PDBs
• Manage a CDB fleet
• Manage resource allocation between PDBs and within a PDB
• Use Data Pump operations from a non-CDB or CDB into a PDB
• Upgrade 12c CDBs or PDBs to 18c
• Configure and create a CDB
• Create, clone, unplug, plug, relocate, proxy, switch over and drop PDBs
• Startup and shutdown CDBs and PDBs
• Manage tablespaces in CDB and PDBs
• Manage common and local users, roles, privileges, profiles, objects in CDBs and PDBs
• Manage PDB lockdown profiles
• Backup, duplicate, recover and flashback CDB and PDBs

This course will assist in preparation for the Oracle Database OCA 1Z0-149 Certification exams.

Product code: WLN-ORA-DB18C-MULTI

This course introduces students to the Oracle Database 19c: Managing Multitenant Architecture technology. This course covers all aspects of the multitenant architecture, providing detailed information on the components of a CDB and its regular and application PDBs. You learn why and how to create and manage a CDB and its regular and application PDBs, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged PDBs in CDBs using various methods.
On successful Completion of the course you will be able to accomplish the following:

• Manage PDB snapshots
• Encrypt data in PDBs and isolate PDB keystore
• Monitor performance in CDBs and PDBs
• Audit users in CDB and PDBs
• Protect data with Database Vault policies in CDB and PDBs
• Manage a CDB fleet
• Manage resource allocation between PDBs and within a PDB
• Use Data Pump operations from a non-CDB or CDB into a PDB
• Upgrade 12c CDBs or PDBs to 18c
• Configure and create a CDB
• Create, clone, unplug, plug, relocate, proxy, switch over and drop PDBs
• Startup and shutdown CDBs and PDBs
• Manage tablespaces in CDB and PDBs
• Manage common and local users, roles, privileges, profiles, objects in CDBs and PDBs
• Manage PDB lockdown profiles
• Backup, duplicate, recover and flashback CDB and PDBs

This course will assist in preparation for the Oracle Database OCP 1Z0-149 Certification exams.

Product code: WLN-ORA-DB18C-MULTI

This course introduces students to the Oracle Database 21c: Managing Multitenant Architecture technology. This course covers all aspects of the multitenant architecture, providing detailed information on the components of a CDB and its regular and application PDBs. You learn why and how to create and manage a CDB and its regular and application PDBs, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged PDBs in CDBs using various methods.
On successful Completion of the course you will be able to accomplish the following:

• Manage PDB snapshots
• Encrypt data in PDBs and isolate PDB keystore
• Monitor performance in CDBs and PDBs
• Audit users in CDB and PDBs
• Protect data with Database Vault policies in CDB and PDBs
• Manage a CDB fleet
• Manage resource allocation between PDBs and within a PDB
• Use Data Pump operations from a non-CDB or CDB into a PDB
• Upgrade 12c CDBs or PDBs to 18c
• Configure and create a CDB
• Create, clone, unplug, plug, relocate, proxy, switch over and drop PDBs
• Startup and shutdown CDBs and PDBs
• Manage tablespaces in CDB and PDBs
• Manage common and local users, roles, privileges, profiles, objects in CDBs and PDBs
• Manage PDB lockdown profiles
• Backup, duplicate, recover and flashback CDB and PDBs

This course will assist in preparation for the Oracle Database OCP 1Z0-082 and 083 Certification exams.

Product code: WLN-ORA-DB18C-MULTI

This course introduces students to the Oracle Database 18c: Architecture and technology. This course covers all aspects of the multitenant architecture, providing detailed information on the components of a CDB and its regular and application PDBs. You learn why and how to create and manage a CDB and its regular and application PDBs, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged PDBs in CDBs using various methods.
On successful Completion of the course you will be able to accomplish the following:

• Describe Oracle Database architecture
• Explain Oracle Database Cloud Service (DBCS) architecture and features
• Manage an Oracle Database instance
• Configure the Oracle Network environment
• Create and manage DBCS database deployments
• Create and manage storage structures
• Configure the database to support your applications
• Manage database security and implement auditing
• Create and manage users
• Implement basic backup and recovery procedures
• Manage and move data
• Move data between databases and files
• Employ basic monitoring procedures and manage performance
• Monitor the database and manage performance
• Create and manage Database Cloud Service database deployments

This course will assist in preparation for the Oracle Database OCP 1Z0-083 Certification exams.

Product code: WLN-ORA-DB18C-ADMIN

This course introduces students to the Oracle Database 19c: Architecture and technology. This course covers all aspects of the multitenant architecture, providing detailed information on the components of a CDB and its regular and application PDBs. You learn why and how to create and manage a CDB and its regular and application PDBs, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged PDBs in CDBs using various methods.
On successful Completion of the course you will be able to accomplish the following:

• Describe Oracle Database architecture
• Explain Oracle Database Cloud Service (DBCS) architecture and features
• Manage an Oracle Database instance
• Configure the Oracle Network environment
• Create and manage DBCS database deployments
• Create and manage storage structures
• Configure the database to support your applications
• Manage database security and implement auditing
• Create and manage users
• Implement basic backup and recovery procedures
• Manage and move data
• Move data between databases and files
• Employ basic monitoring procedures and manage performance
• Monitor the database and manage performance
• Create and manage Database Cloud Service database deployments

This course will assist in preparation for the Oracle Database OCP 1Z0-083 Certification exams.

Product code: WLN-ORA-DB19C-ADMIN

This course introduces students to the Oracle Database 21c: Architecture and technology. This course covers all aspects of the multitenant architecture, providing detailed information on the components of a CDB and its regular and application PDBs. You learn why and how to create and manage a CDB and its regular and application PDBs, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged PDBs in CDBs using various methods.
On successful Completion of the course you will be able to accomplish the following:

• Describe Oracle Database architecture
• Describe Oracle Database 21c blockchain architecture
• Explain Oracle Database Cloud Service (DBCS) architecture and features
• Manage an Oracle Database instance
• Configure the Oracle Network environment
• Create and manage DBCS database deployments
• Create and manage storage structures
• Configure the database to support your applications
• Manage database security and implement auditing
• Create and manage users
• Implement basic backup and recovery procedures
• Manage and move data
• Move data between databases and files
• Employ basic monitoring procedures and manage performance
• Monitor the database and manage performance
• Create and manage Database Cloud Service database deployments

This course will assist in preparation for the Oracle Database OCP 1Z0-083 Certification exams.

Product code: WLN-ORA-DB21C-ADMIN

This course introduces students to the Oracle Database 19c: Architecture and technology.
After completing this Oracle certification course, students will be able to backup and recover databases, diagnose and repair data failures with Flashback technology and manage space to optimize database storage.
This course is designed to fully certify an individual in Oracle Datbase 19c. Students will learn about the features in SQL and PL/SQL, the Oracle® features that support SQL99, and all features of the Oracle 19c database.
The students will be provided with course materials, sample tests, and be able to take all tests associated with Oracle 19c certification.
On successful Completion of the course you will be able to accomplish the following:

• 1Z0-071 -- Oracle Database 19c: Certified Associate - SQL Fundamentals
• 1Z0-149 -- Oracle Database 19c: Program with PL/SQL - Certified Associate
• 1Z0-082 -- Oracle Database 19c: Administration Fundamentals I Certified Associate

This course will assist in preparation for the Oracle Database OCP 1Z0-071, 1Z0-149, 1Z0-082 Certification exams.

Product code: WLN-ORA-DB19C-BCAMP

The Oracle Database 21c: Certified Associate - DBA Boot Camp (DBA OCA) - 1Z0-071, 1Z0-149 and 1Z0-082 course provides step-by-step instructions on how to perform a variety of SQL, PL/SQL development and database administration tasks for activities based on real-life work scenarios.
The course takes the database developers and administrators beyond the basic tasks covered in the SQL, PL/SQL and Administration Workshop I. Students will gain a deep understanding of the most important responsibilities a DBA has: performing backup and recovery, diagnose and repair data failures with Flashback technology and manage space to optimize database storage.
This course is designed to fully certify an individual in Oracle 21c. Students will learn about the new features in PL/SQL, the Oracle® features that support SQL99, and all features of the Oracle 21c database including support for blockchain.
The students will be provided with course materials, sample tests, and be able to take all tests associated with Oracle 19c certification.
On successful Completion of the course you will be able to accomplish the following:

• 1Z0-071 -- Oracle Database 21c: Certified Associate - SQL Fundamentals
• 1Z0-149 -- Oracle Database 21c: Program with PL/SQL - Certified Associate
• 1Z0-082 -- Oracle Database 21c: Administration Fundamentals I Certified Associate

This course will assist in preparation for the Oracle Database OCP 1Z0-071, 1Z0-149, 1Z0-082 Certification exams.

Product code: WLN-ORA-DB21C-BCAMP

The course Oracle Database 19c Administration and Development I combines Oracle Database Administration Fundamentals and SQL/PLSQL development courses into a single solution. This course covers all aspects of the multitenant architecture, providing detailed information on the components of a CDB and its regular and application PDBs. You learn why and how to create and manage a CDB and its regular and application PDBs, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged PDBs in CDBs using various methods.
After completing this Oracle certification course, students will be able to backup and recover databases, diagnose and repair data failures with Flashback technology and manage space to optimize database storage.
This course is designed to fully certify an individual in Oracle Datbase 19c. Students will learn about the features in SQL and PL/SQL, the Oracle® features that support SQL99, and all features of the Oracle 19c database.
The students will be provided with course materials, sample tests, and be able to take all tests associated with Oracle 19c certification.
On successful Completion of the course you will be able to accomplish the following:

• 1Z0-071 -- Oracle Database 19c: Certified Associate - SQL Fundamentals
• 1Z0-149 -- Oracle Database 19c: Program with PL/SQL - Certified Associate
• 1Z0-082 -- Oracle Database 19c: Administration Fundamentals I Certified Associate

This course will assist in preparation for the Oracle Database OCP 1Z0-071, 1Z0-149, 1Z0-082 Certification exams.

Product code: WLN-ORA-DB19C-ADMIN

This course introduces students to the Oracle Database 19c: Architecture and technology. This course covers all aspects of the multitenant architecture, providing detailed information on the components of a CDB and its regular and application PDBs. You learn why and how to create and manage a CDB and its regular and application PDBs, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged PDBs in CDBs using various methods.
On successful Completion of the course you will be able to accomplish the following:

• Describe Oracle Database architecture
• Explain Oracle Database Cloud Service (DBCS) architecture and features
• Manage an Oracle Database instance
• Configure the Oracle Network environment
• Create and manage DBCS database deployments
• Create and manage storage structures
• Configure the database to support your applications
• Manage database security and implement auditing
• Create and manage users
• Implement backup and recovery procedures
• Manage and move data
• Move data between databases and files
• Employ monitoring procedures and manage performance
• Monitor the database and manage performance
• Create and manage Database Cloud Service database deployments

This course will assist in preparation for the Oracle Database OCP 1Z0-083 Certification exams.

Product code: WLN-ORA-DB19C-ADMIN

The Oracle Database 12c Essentials - Certified Implementation Specialist - 1Z0-497 course provides step-by-step instructions on how to perform a variety of administrative and development tasks including: Oracle Database 12c Enterprise Edition Options, Database Architecture, Multitenant Architecture and Relational Database Modelling Concepts.
The students will be provided with course materials, sample tests, and be able to take all tests associated with Oracle 19c certification.
On successful Completion of the course you will be able to accomplish the following:

• Oracle Database: Introduction to Database Modelling
• 1Z0-071 -- Oracle Database: Certified Associate - SQL Workshop I
• 1Z0-149 -- Oracle Database: Certified Professional - SQL and PL/SQL Fundamentals
• 1Z0-082 -- Oracle Database: Admin, Install and Upgrade Accelerated
• 1Z0-082 -- Oracle Database: Backup and Recovery Workshop
• 1Z0-082 -- Oracle Database: Managing Multitenant Architecture

This course will assist in preparation for the Oracle Database OCP 1Z0-071, 1Z0-149, 1Z0-082 Certification exams.

Product code: WLN-ORA-DB12C-ESS

This course introduces students to the Oracle Database 19c: SQL Applications Tuning. This course covers all aspects of the SQL Tuning techniques, providing detailed information on Tuning Methods and Diagnostics including the tuning of SQL and CDB and its regular and application PDBs.
On successful Completion of the course you will be able to accomplish the following:

• Introduction to SQL Tuning
• Using Application Tracing Tools
• Optimizer Fundamentals
• Generating and Displaying Execution Plans
• Interpreting Execution Plans and Enhancements
• Optimizer: Join Operators
• Other Optimizer Operators
• Introduction to Optimizer Statistics Concepts
• Using Bind Variables
• SQL Plan Management

This course will assist in preparation for the Oracle Database OCP 1Z0-083 and 1Z0-084 Certification exams.

Product code: WLN-ORA-DB19C-SQL-TUN-BUNDLE

This course introduces students to the Oracle Database 19c: RAC Administration. This course covers all aspects of RAC administration, providing detailed information on RAC database architecture, managing backup and recovery, tuning RAC databases, diagnosing and resolving common performance issues.
On successful Completion of the course you will be able to accomplish the following:

• Understand Oracle RAC database architecture
• Perform administration tasks on Oracle RAC
• Manage backup and recovery in Oracle RAC
• Understand the Global Resource Management
• Monitor and tuning Oracle RAC databases
• Create and manage Dynamic Database Services
• Implement Connection Load Balancing and TAF
• Understand and test Application Continuity
• Create and manage Oracle RAC One Node database
• Create and manage an Oracle RAC CDB database
• Manage database server pools in Clusterware

This course will assist in preparation for the Oracle Database OCP 1Z0-083 Certification exams.

Product code: WLN-ORA-DB19C-RAC-ADM-BUNDLE