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

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

Product code: WLN-ORADB-MODEL-eLearning

On successful Completion of the Oracle Database Design and Programming with SQL 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
• 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

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

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

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

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

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

Product code: 367DDF5p

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

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

This course will assist in preparation for the Oracle Database 11g Administration OCA Certification - 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:

• Understand Oracle Database Tools
• Learn Data Definition Lanaguage - DDL
• Learn Data Manipulation Language - DML
• Learn Data Control Language - DCL
• Configure Oracle Net Services
• Introduction to PL/SQL Programming
• Creating a DML Trigger
• Using Procedures and Functions
• Creating a Procedure
• Creating a Function
• Handling Exceptions
• Creating Exceptions
• PL/SQL packages
• Describe Oracle Database Architecture
• Manage the Oracle Database Instance
• Manage Database Storage structures
• Create and Administer User Accounts
• Monitor the Database
• Manage Database Performance
• Implement Database Auditing
• Configure the Database Instance
• Schedule Jobs to Run Inside or Outside of the Database
• Configure your Database For Backup and Recovery Operations

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

Product code: 367DDF5p

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

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

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

Product code: WLN-ORA12SQL

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

• Understand Relational Database Modelling
• Identify Oracle Database Development Tools
• Use Enterprise Manager Database Express to manage the database
• Manage database storage structures and schema objects
• Administer users and security
• Backup and recover the Oracle database
• Monitor the database and use the Advisors
• Install Oracle Database 12c
• Create a Database
• 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
• Gain an understanding of the Oracle Database Cloud Service

This course will assist in preparation for the Oracle Database 12c: 1Z0-061 and 1Z0-062 Certification exams.

Product code: 367DDF5p

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

• Understand Relational Database Modelling
• Identify Oracle Database Development Tools
• Use Enterprise Manager Database Express to manage the database
• Manage database storage structures and schema objects
• Administer users and security
• Backup and recover the Oracle database
• Monitor the database and use the Advisors
• Install Oracle Database 19c
• Create a Database
• 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
• Gain an understanding of the Oracle Database Cloud Service

This course will assist in preparation for the Oracle Database 12c: 1Z0-061 and 1Z0-062 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

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 19c: 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

This course introduces students to the fundamentals of PL/SQL using Oracle Database 19c 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 for Oracle Database Developer course you will be able to:

• Introduction to RDBMS
• Introduction to Database Modelling
• Oracle Database: Introduction to SQL - 1Z0-071
• Oracle Database 12c: SQL Tuning Workshop Release 2 - 1Z0-117
• Oracle Database: Program with PL/SQL - 1Z0-144
• Oracle Database 12c: Advanced PL/SQL - 1Z0-146
• Oracle Database: Advanced PL/SQL 1Z0-148

Certification: This course will assist in preparation for the Oracle OCA and OCP Database Developer Certification exams.

Product code: CEN-OCA-OCP-ORADEV

On successful Completion of the for Oracle Database 21c Developer course you will be able to:

• Introduction to RDBMS
• Introduction to Database Modelling
• Oracle Database: Introduction to SQL - 1Z0-071
• Oracle Database 21c: SQL Tuning Workshop
• Oracle Database: Program with PL/SQL - 1Z0-144
• Oracle Database 21c: Advanced PL/SQL - 1Z0-146
• Oracle Database 21c: Blockchain Development

Certification: This course will assist in preparation for the Oracle OCA and OCP Database Developer Certification exams.

Product code: CEN-OCA-OCP-ORADEV-21c

This course introduces students to the fundamentals of PL/SQL Programming using Oracle Database 18c 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 OCA 1Z0-144 Certification exams.

Product code: WLN-ORA-DB12C-PLSQL

This course introduces students to the fundamentals of PL/SQL Programming using Oracle Database 19c 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 OCA 1Z0-144 Certification exams.

Product code: WLN-ORA-DB12C-PLSQL

This course introduces students to the fundamentals of PL/SQL Programming using Oracle Database 21c 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 OCA 1Z0-144 Certification exams.

Product code: WLN-ORA-DB12C-PLSQL-21c

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-144 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-144 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 19c
• 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-144 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 21c
• 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-144 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 OCA 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 OCA 1Z0-144 Certification exams.

Product code: WLN-ORA-DB18C-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
• 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
• Create and manage blockchain schema objects
• 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
• Create and manage blockchain database objects

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

Product code: WLN-ORA-DB21C-ADMIN

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

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

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

Product code: WLN-ORA11G-DWFNDM

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

• Define the terminology and explain the basic concepts of data warehousing
• Understand the Oracle Data Warehouse Technology Stack
• Understand the Oracle 12c Multitenant Architecture for Data Warehousing
• 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 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-ORA12c-DWFNDM

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

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

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

Product code: WLN-ORA-DW19cFNDM

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

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

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

Product code: WLN-ORA-DW18cFNDM

On successful Completion of the Oracle 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 12c 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 12c Certified Implementation Essentials exam.

Product code: WLN-ORA-ODIFNDM

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

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

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

Product code: WLN-ORA-ODIBC

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

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

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

Product code: WLN-ORA-ODIBC

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 MCSA: SQL Server 2017/2019 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 2017/2019 Certification Certification exams.

Product code: WLN-MCSA-BIDW

On successful Completion of the 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 for MCSE SQL Server 2017/2019 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 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/2016 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 for MCSE SQL Server 2017/2019 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/2016 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 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 2017 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 2019 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 2016/2017 & 2019 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 Microsoft SQL Server 2017 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 Microsoft SQL Server 2019 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 Oracle and Microsoft Database Administration course you will be able to:

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

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

Product code: WLN-MSFT-BIDW

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

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

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

Product code: WLN-MSFT-BIDW

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

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

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

Product code: WLN-MSFT-BIDW

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

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

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

Product code: WLN-MSFT-BIDW

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

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

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

Product code: WLN-MSFT-BIDW

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

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

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

Product code: WLN-MSFT-BIDW

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

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

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

Product code: WLN-MSFT-BIDW

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

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

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

Product code: WLN-MSFT-BIDW

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

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

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

Product code: WLN-MSFT-BIDW

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

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

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

Product code: WLN-MSFT-BIDW

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

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

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

Product code: WLN-MSFT-BIDW

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

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

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

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

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

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 SQL Server 2019 Platform course you will be able to:

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

Certification: This course will assist in preparation for the Fundamentals of SQL Server 2019 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 IBM DB2 Database Administration for SQL Server DBA's course you will be able to:

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

Certification: This course will assist in preparation for the IBM DB2 Certification exams.

Product code: WLN-MSSQL-DEV

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

• Introduction to the SQL Server Platform
• SQL Server Architecture
• Database and Instances
• Instance Architecture
• Installing and Configuring SQL Server
• Database Objects
• Security
• Data Access and Transaction Control
• Backup and Recovery
• Performance Tuning and Optimization
• High Availability and Disaster Recovery
• Scheduling, Automation and Alerting
• Data Movement
• Upgrading and Migrating to SQL Server

Certification: This course will assist in preparation for the IBM DB2 Certification exams.

Product code: WLN-MSSQL-DEV

On successful Completion of the IBM DB2 Database Query using SQL Fundamentals course you will be able to:

• Describe the basic architecture and concepts of DB2
• Understand the similarities and differences between SQL and other computer languages
• Understand DB2 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
• Implement pivoting and grouping sets
• Execute stored procedures
• Program with SQL PL or PL/SQL
• Implementing Error Handling
• Implement transactions

Certification: This course will assist in preparation for the IBM DB2 Certification exams.

Product code: WLN-DB2SQL-SQL

On successful Completion of the IBM DB2 Database Administration and Development course you will be able to:

• Understand DB2 Terminology
• Describe the Basic Architecture and Concepts of IBM DB2
• Understand DB2 Data Tools
• Describe and work with DB2 Database Management Tools
• Install DB2 Data Studio 4.x
• Learn Data Definition Lanaguage - DDL
• Learn Data Manipulation Language - DML
• Learn Data Control Language - DCL
• Describe IBM Database Architecture
• Create a DB2 Instance
• Manage the IBM Database Instance
• Manage IBM Database Storage structures
• Understand DB2 Indexing Techniques
• Understand DB2 Constraint methods
• Create and Administer User Accounts
• Monitor the Database
• Manage Database Performance
• Implement Database Auditing
• Configure IBM Database Instance
• Configure Database For Backup and Recovery Operations
• Schedule Jobs to Run Inside or Outside of the Database
• Explore DB2 Performance Tuning methods

Certification: This course will assist in preparation for the IBM DB2 Certification exams.

Product code: WLN-MSSQL-ADMIN

On successful Completion of the IBM DB2 Database Administration course you will be able to:

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

Product code: WLN-MSSQL-ADMIN

On successful Completion of the IBM DB2 Database Development course you will be able to:

• Understand Relational Database Concepts
• Understand DB2 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 IBM DB2 Certification Examinations.

Product code: WLN-DB2SQL-DEV

On successful Completion of the IBM DB2 Database Modelling and Development course you will be able to:

• Understand Relational Database Concepts
• Designing and implementing normalized database schemas
• Understand DB2 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 IBM DB2 Certification Examinations.

Product code: WLN-MSSQL-ADMIN

On successful Completion of the IBM DB2 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 IBM DB2 Certification Examinations.

Product code: WLN-MSSQL-ADMIN

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

• Understand DB2 Terminology
• Describe the Basic Architecture and Concepts of IBM DB2
• Describe and work with DB2 Database Management Tools
• Install DB2 Data Studio 4.x
• Understand Data Modeling and Database Design
• State the purpose of a business model
• Identify an Entity-Relational Diagram (ERD) model
• Understand the Stages of Database system Development
• List several DB2 column data types
• Identify non-standard column and table names
• Identify the characteristics of a primary key and a foreign key
• State the purpose of referential integrity
• State the purpose of triggers
• Write SELECT queries
• Query multiple tables
• Sort and filter data
• Describe the use of data types in DB2
• Modify data using 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
• Understand Oracle PL/SQL Programming in DB2
• Develop PL/SQL Stored Procedures in DB2

Certification: This course will assist in preparation for the IBM DB2 Certification Examinations.

Product code: WLN-MSSQL-ADMIN

On successful Completion of the IBM DB2 Database Fundamentals course you will be able to:

• Overview of DB2 on Linux, UNIX and Windows
• DB2 products and DB2 Editions
• Databases and the Relational Model
• Key DBMS Concepts
• DB2 Database Development Tools
• Installing Data Studio
• Database and Instances
• Instance Architecture
• Database Architecture
• Creating Databases and Database Objects
• Create DML Statements
• Create DDL Statements
• Create DCL Statements
• Perform Fundamental DB2 Administration Tasks

This course will assist in preparation for the DB2 Database 11.x: Certification exams.

Product code: WLN-DB2CSQL-eLearning

This course introduces students to the fundamentals of database programming and the Architecture of DB2 Database 11.5 technology. In this course students learn the concepts of relational databases and the powerful PL/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 DB2 Database Development Tools
• Install your DB2 Software
• Understand the DB2 Database 11.x Edition Options
• Understand the DB2 Database Architecture
• Identify the major structural components of the DB2 Database 11.5
• 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

This course will assist in preparation for the DB2 Database 11.x: Certification exams.

Product code: 367DDF5p

The DB2 11g training course will teach students how to install and maintain a DB2 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:

• Understand DB2 Terminology
• Describe the Basic Architecture and Concepts of IBM DB2
• Installing DB2 Software
• Managing an DB2® Instance
• Describe DB2 Database Instances
• DB2 Managed Files
• Describe and work with DB2 Database Management Tools
• Install DB2 Data Studio 4.x
• Install DB2 Software and Instance
• Create a DB2 Instance
• Understand DB2 Indexing Techniques
• Understand DB2 Constraint methods
• Perform DB2 Backup and Recovery tasks
• Explore DB2 Performance Tuning methods

This course will assist in preparation for the DB2 Database 11.5 Administration Certification exams.

Product code: WLN-DB211ADM-eLearning

On successful Completion of the DB2 11.5 Quickstart for Experienced Relational DBAs course you will be able to:

• Understand DB2 Terminology
• Describe the Basic Architecture and Concepts of IBM DB2
• Describe and work with DB2 Database Management Tools
• Install DB2 Data Studio 4.x
• Install DB2 Software and Instance
• Create a DB2 Instance
• Understand DB2 Indexing Techniques
• Understand DB2 Constraint methods
• Perform DB2 Backup and Recovery tasks
• Explore DB2 Performance Tuning methods

This course will assist in preparation for the DB2 Database 11.5 Administration Certification exams.

Product code: 367DDF5p

On successful Completion of the DB2 Query and Manage XML Data course you will be able to:

• Use XQuery to retrieve documents from an XML column
• Use SQL/XML retrieval, publishing, and shredding functions
• Use DB2 Data Studio to understand how to build XML queries and queries that contain SQL/XML
• Establish the environment to store native XML data in DB2
• Create XML indexes for efficient retrieval of XML data
• Analyze query executions and what you can do to improve the query performance
• Validate and register XML schemas using commands
• Annotate XML schemas and decompose XML documents using commands
• Use DB2 Data Studio to annotate XML schemas for decomposition
• Use DB2 Data Studio to register XML schemas for validation, decomposition, or both

This course will assist in preparation for the DB2 Database Certification exams.

Product code: 367DDF5p

On successful Completion of the DB2 SQL Workshop course you will be able to:

• Understand how tables are defined
• describe the data types available when defining DB2 columns
• describe the importance of an Index for certain queries
• use DB2 Data Studio
• Code SQL statements to retrieve data from a DB2 table
• Retrieving Data from Multiple Tables using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses
• Code inner joins and non-correlated subqueries
• Use SQL arithmetic operations
• Use scalar and column functions
• Use UNION and UNION ALL
• INSERT, UPDATE and DELETE rows
• Code simple CREATE TABLE and CREATE VIEW statements
• Use DB2 functions and the CASE statement

This course will assist in preparation for the DB2 Database Certification exams.

Product code: WLN-DB2SWS-eLearning

On successful Completion of the DB2 SQL Workshop for Experienced Users course you will be able to:

• Discuss basic relational database concepts
• Use some of the OLAP features of DB2, such as GROUPing and RANKing functions
• Create tables, views and indexes
• Use referential integrity, check constraints and triggers
• Use outer joins, and join tables to themselves
• Use CASE expressions, and the CAST function
• Identify the impact of Summary Tables, Materialized Query Tables, and temporary tables
• Use complex subqueries
• Use a greater number of scalar SQL functions
• Use advanced SQL constructs, such as recursive SQL and table expressions
• Define User-Defined Distinct Types and User-Defined Functions
• Avoid several of the most common causes for poorly-performing SQL

This course will assist in preparation for the DB2 Database Certification exams.

Product code: WLN-DB2SWE-eLearning

On successful Completion of the DB2 Stored Procedures Programming course you will be able to:

• Describe stored procedures
• List Intel platform requirements for supporting DB2 stored procedures
• Discuss and demonstrate capabilities of the IBM Data Studio
• Use Data Studio to implement SQL stored procedures
• Describe basic SQL procedure structure
• Demonstrate the use of SQL Procedure Language Elements
• Use cursor processing to return result sets to the invoker
• Handle Exceptions
• Nest Stored Procedures
• Use IBM Data Studio debugging capability to debug an SQL stored procedure
• Use sqlpltrc API to trace SQL stored procedures
• Employ security techniques for SQL procedures
• Analyze and improve SQL access plans

This course will assist in preparation for the DB2 Database Certification exams.

Product code: WLN-DB2SPP-eLearning

On successful Completion of the DB2 Database Design course you will be able to:

• Use design techniques such as Normalisation
• understand the performance issues involved in constructing a system
• Implement an efficient tablespace, table and index design
• choose the correct locking strategy
• Implement referential and table check constraints
• use Identity Columns & Sequences
• Design and create Materialized Query Tables
• Design and create triggers
• Understand the performance issues involving the use of large objects

This course will assist in preparation for the DB2 Database Certification exams.

Product code: WLN-DB2DD-eLearning

On successful Completion of the DB2 11.5 Database Administration Workshop course you will be able to:

• Overview of DB2 10 to 11.5 on Linux, UNIX and Windows
• DB2 products and DB2 Editions
• Databases and the Relational Model
• Key DBMS Concepts
• DB2 Database Development Tools
• DB2 Command Line Processor (CLP) and GUI tools
• Installing Data Studio
• The DB2 database manager instance
• Database and Instances
• Instance Architecture
• Database Architecture
• Creating Databases and Data Placement
• Create Databases and Database Objects
• Creating Database Objects using DDL
• Create DML Statements
• Create DCL Statements
• Perform Fundamental DB2 Administration Tasksv
• Moving Data
• Backup and Recovery
• Locking and concurrency
• Database Maintenance, Monitoring and Problem Determination
• Security

This course will assist in preparation for the DB2 Database Certification exams.

Product code: WLN-DBADMW-eLearning

On successful Completion of the Developing DB2 Stored Procedures using SQL-PL & PL/SQL course you will be able to:

• Define and code Stored Procedures using Oracle PL/SQL or SQL-PL
• Execute Stored Procedures
• Code Stored Procedures using SQL-PL (optional)
• Return Dynamic Result Sets from Stored Procedures
• Understand Schemas and Schema Paths
• Use the ARRAY datatype within procedures
• Use Global Temporary tables within Stored Procedures
• Use Declared Temporary tables within Stored Procedures
• Use IBM Data Studio to develop PL/SQL Stored Procedures
• Call Stored Procedures from Triggers

This course will assist in preparation for the DB2 Database Certification exams.

Product code: WLN-DB2SPF-eLearning

On successful Completion of the DB2 Development for Applications Programmers course you will be able to:

• set up a DB2 test environment
• correctly define tables, views, indexes, synonyms and aliases
• use both permanent and temporary tables
• use the DB2 CLI toolset, including DB2 Data Studio
• code SQL statements to read and manipulate DB2 data
• develop, prepare and execute DB2 programs
• bind packages and plans
• use non-scrollable and scrollable cursors
• use multi-row INSERT and FETCH processing
• describe the locking process used by DB2
• define and use Referential Integrity
• use Identity Columns and Sequences
• produce EXPLAIN output using a PLAN_TABLE
• use the LOAD utility to populate tables

This course will assist in preparation for the DB2 Database Certification exams.

Product code: WLN-DB2DBPRG-eLearning

On successful Completion of the DB2 Advanced Programming course you will be able to:

• define large objects
• Access and manipulate large objects from a program
• Code Common Table Expressions
• Code Recursive SQL statements
• Use scrollable cursors
• use rowset processing
• Understand and use the GET DIAGNOSTICS statement
• Use MERGE statements
• Use SELECT FROM INSERT / UPDATE / DELETE / MERGE statements
• Code INSERSECT and EXCEPT statements
• Use Identity Columns and Sequences
• Understand how and when to use Materialized Query Tables

This course will assist in preparation for the DB2 Database Certification exams.

Product code: WLN-DB2DBPRG-eLearning

On successful Completion of the DB2 SQL Performance and Tuning course you will be able to:

• understand the performance issues involved in constructing a system
• Implement an efficient tablespace, table and index design
• Understand the importance of RUNSTATS, REORGCHK and REORG
• Understand the process of optimisation
• Describe the various access path techniques that DB2 is able to use
• Write efficient SQL statements
• Run and understand the Visual Explain Facility
• Run and understand the command line Explain Facilities

This course will assist in preparation for the DB2 Database Certification exams.

Product code: WLN-DBADW-eLearning

On successful Completion of the DB2 Performance Tuning and Monitoring course you will be able to:

• Define the impact of database design (tables, indexes, and data placement) on database performance
• Describe database application programming considerations and how they affect performance
• Identify and describe the parameters (database and non-database) that affect performance
• Tune parameters to achieve optimum performance
• Identify and use the tools that assist in monitoring and tuning of a database

This course will assist in preparation for the DB2 Database Certification exams.

Product code: WLN-DBADW-eLearning

On successful Completion of the DB2 SQL & SQL/PL Database Programming course you will be able to:

• Incorporate static SQL statements in an application program
• Prepare the program for execution
• Validate execution results are correct
• Produce code to support multiple rows being returned from the database manager using cursors
• Identify considerations regarding units of work, concurrency, and restart of programs
• Identify differences between static and dynamic SQL
• Provide test data for applications
• Discuss program and DB2 options relative to performance of static SQL

This course will assist in preparation for the DB2 Database Certification exams.

Product code: WLN-DBADW-eLearning

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 Informatica Data Integration & ETL Fundamentals course you will be able to:

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

Informatica Data Integration & ETL Fundamentals Self-Study eLearning:

Product code: WLN-INF-ETLFNDM

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

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

Informatica Data Integration & ETL Bootcamp Self-Study eLearning:

Product code: WLN-INF-ETLBC

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

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

Informatica Data Integration & ETL Fundamentals Self-Study eLearning:

Product code: WLN-INF-DWFNDM

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

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

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

Product code: WLN-INF-DWBC

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