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

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

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

Product code: 367DDF5p

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 Oracle 11g Data Warehousing Fundamentals Self-Study CBT course you will be able to:

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

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

Product code: WLN-ORA-DWFNDM

On successful Completion of the 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-CBT

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

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

Informatica Data Integration & ETL Bootcamp Self-Study CBT:

Product code: WLN-INF-ETLBC