Oracle Education - Page 2 of 5 - IT Training and Certification

Analytics and Data Training and Certification

OD-12cR2-HANF: Oracle Database 12c R2: High Availability New Features

RM5,500.00

4 Days ILT, VILT

The Oracle Database 12c R2: High Availability New Features course covers High Availability new features introduced in the Oracle Database 12c Release 2. Focus areas include Clusterware, ASM, ACFS, RAC, and Data Guard.

Learn To:

Configure and administer the Oracle Database 12c R2 high availability new features contained in Oracle Clusterware Infrastructure (including Automatic Storage
Management [ASM] and Cloud FS.
Configure and administer RAC new features.
Describe the new features contained in Oracle Data Guard.
Describe Oracle Data Guard Enhancements.
Gain an understanding of the Oracle Database Exadata Cloud Service.
Gain an understanding of Clusterware Manageability Enhancements.
Gain an understanding of ASM New Features.
Gain an understanding of ACFS Manageability New Features & Performance Enhancements.
Gain an understanding of Real Application Cluster New Features.
Gain an understanding of Data Guard and Broker New Features.

Programming and Software Development Training and Certification

OJ-OOAD-UML: Object-Oriented Analysis and Design Using UML

5 Days ILT, VILT

This Object-Oriented Analysis and Design Using UML training teaches you how to effectively use object-oriented technologies and software modeling as applied to a software development process. Expert Oracle University instructors present one practical, complete, object-oriented analysis and design (OOAD) road map from requirements gathering to system design.

Learn To:

Use object-oriented technologies.
Use Unified Modeling Language 2.2.
Perform object-oriented analysis and design.
Follow a software development process using an OO software project.
Create a system design (the Solution model) supporting the functional requirements (FRs).

OWB-DIETL: Data Integration and ETL with Oracle Warehouse Builder

5 Days ILT, VILT

Participants learn to load data by executing the mappings or the process flows, use Oracle Warehouse Builder 11g, Release 2 features to manage metadata changes, debug mappings, backup metadata, manage security, and tune the ETL mappings for better performance. Integration of Warehouse Builder with OBI EE, along with the Warehouse Builder architecture and configuration are discussed.

Participants learn to retrieve data from different types of sources such as flat files or relational schemas and also to use the different transformation operators to design an ETL task. The usage of Warehouse Builder to define both relational dimensional models and multidimensional models, to deploy a single logical model to multiple physical targets and how to handle slowly changing dimensions are also covered.

In addition, extraction of data from non-Oracle sources using code templates, usage of the Warehouse Builder ETL and data integration features of the Enterprise ETL Option of the Oracle database are discussed.

This functionality requires the Oracle Warehouse Builder Enterprise ETL/ODI EE option.

This course is a combination of Data Integration and ETL with Oracle Warehouse Builder: Part 1 and Data Integration and ETL with Oracle Warehouse Builder: Part 2 courses.
Learn To:

Retrieve data from different types of sources such as flat files or relational schemas
Use the different transformation operators to design an ETL task
Load data by executing the mappings or the process flows
Use OWB features to manage metadata changes, debug mappings, backup metadata, manage security, and tune the ETL mappings for better performance
Integrate Warehouse Builder with OBI EEWarehouse
Explain the Warehouse Builder architecture and configuration

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

OAV-PR: Oracle Audit Vault and Database Firewall: Policies & Reports

RM4,500.00

2 Days ILT, VILT

No hands-on lab environment for the Training On-Demand course format

In the Oracle Audit Vault and Database Firewall: Policies & Reports course, students will learn how to create audit and Database Firewall policies, use built-in reports, create custom reports, and define alerts.

Learn To:

Create and provision audit policies for Oracle Databases.
Create and publish Database Firewall policies.
Configure and respond to alerts.
Use and customize built-in reports.
Manage entitlements.

OAV-IC: Oracle Audit Vault and Database Firewall: Install & Configure

RM4,500.00

2 Days ILT, VILT

In the Oracle Audit Vault and Database Firewall: Install & Configure course, students will learn how to deploy Oracle Audit Vault and Database Firewall.

Learn To:

Install, configure, and manage the Audit Vault Server.
Deploy the Audit Vault Agent.
Describe Database Firewall Networking.
Install, deploy, and manage a Database Firewall.
Install and enable Host Monitoring.

OJ-JEE7-DAWS12c: Developing Applications with Java EE 6 on WebLogic Server 12c

RM6,500.00

5 Days ILT, VILT

The Developing Applications with Java EE 6 on WebLogic Server 12c course teaches you the skills you need to successfully build and deploy enterprise applications. You’ll explore applications that comply with the Java Platform, Enterprise Edition 6 Web Profile.

Learn To:

Create mobile web applications.
Create JSF facelet pages.
Develop web profile applications.
Assemble a web application and deploy it into an application server (Java EE platform runtime environment).
Use CDI.
Update a database with JPA.
Perform bean validation.

OJ-JEE7-DA: Developing Applications for the Java EE 7 Platform

5 Days ILT, VILT

The Developing Applications for the Java EE 7 Platform training teaches you how to build and deploy enterprise applications that comply with Java Platform, Enterprise Edition 7.

The technologies presented in this course include annotations, Enterprise JavaBeans (EJB), Java Persistence API (JPA), Java Transaction API (JTA), Servlets, JavaServer Pages(JSPs), JavaServer Faces (JSF), Contexts and Dependency Injection (CDI), JAX-RS RESTful and SOAP Web Services, the Java API for WebSocket, Java Message Service API (JMS), Bean Validation, Batch API, Timer services, and Java EE Concurrency.

OD-12cR2-AW: Oracle Database 12c R2: Administration Workshop

5 Days ILT, VILT

The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.

ODS-PC: Oracle Database Security: Preventive Controls

RM6,500.00

5 Days ILT, VILT

In the Oracle Database Security: Preventive Controls course, students learn how they can use Oracle Database Security products and technologies to meet the security, privacy and compliance requirements of their organization.

The current regulatory environment of the Sarbanes-Oxley Act, HIPAA, the UK Data Protection Act, and others, requires better security at the database level. Students learn how to secure the access to their databases and how to use the Oracle Database Security products and technologies that enhance data access and confidentiality. The course provides suggested Oracle solutions for common problems.

Learn To:

Choose Oracle Database Security products and technologies to meet security requirements.
Secure the database access by database or enterprise users with basic or strong authentication such as SSL, Kerberos and Radius.
Protect against database bypass by using Transparent Database Encryption.
Use Oracle Wallets and Oracle Key Vault to manage encryption keys.
Discover sensitive columns such as Credit Card Numbers by using Application Data Modeling.
Minimize sensitive data proliferation to test/dev environments by using Data Masking.
Minimize storage costs in test/dev environments by using Data Subsetting.
Reduce sensitive data exposure in applications by using Data Redaction.
Understand and use Oracle Database Vault.

OD-ASQL-DW: Oracle Database 12c: Analytic SQL for Data Warehousing

RM5,000.00

3 Days ILT, VILT

This Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data and exclude branches from the tree structure. You’ll also learn to use regular expressions and sub-expressions to search for, match, and replace strings. In this course, you will be introduced to Oracle Business Intelligence Cloud Service.

Learn To:

Use SQL with aggregation operators, SQL for Analysis and Reporting functions.
Group and aggregate data using the ROLLUP and CUBE operators, the GROUPING function, Composite Columns and the concatenated Groupings.
Analyze and report data using Ranking functions, the LAG/LEAD Functions and the PIVOT and UNPIVOT clauses.
Perform advanced pattern matching.
Use regular expressions to search for, match and replace strings.
Gain an understanding of the Oracle Business Intelligence Cloud Service.

OD-12cR2-NFAP2: Oracle Database 12c R2: New Features for Administrators Part 2

RM6,500.00

5 Days ILT, VILT

Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 2 course constituted by five modules; the Securing Data module, the Making Data Available module, the Partitioning Data module, the Managing Information Lifecycle module and the Monitoring DB Operations and Managing Performance module, students receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration like Unified Auditing, Transparent Data Encryption (TDE) and other areas of security, Recovery Manager, online operations, Oracle Data Pump, SQL*Loader, new partitioning methods, Automatic Data Optimization, In-Memory Column Store, Full Database In-Memory Caching, and Automatic Big Table Caching.

Learn To:

Gain an understanding of the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as security, availability, partitioning, performance, and Information Lifecycle Management (ILM).

OD-12c-IP: Oracle Database 12c: Implement Partitioning

RM4,500.00

2 Days ILT, VILT

This Oracle Database 12c: Implement Partitioning training teaches you how to manage partitioning using Oracle Database 12c. Expert Oracle University instructors will demonstrate the benefits of partitioning for different types of workloads and learn the syntax for partitioning maintenance operations. In this course, you will be introduced to Oracle Database Cloud Service.

Learn To:

Apply partitioning strategies to enhance application performance.
Use partitioning techniques to reduce impact of table and index maintenance.
Use partitioning to decrease the time to refresh materialized views.
Partition lob segments, nested tables and object tables.
Understand the Oracle Partitioning methods for tables, index and materialized views available in Oracle Database 12c Release 1.
Gain an understanding of the Oracle Database Cloud Service.

OD-12cR2-RACA: Oracle Database 12c: RAC Administration

RM5,500.00

4 Days ILT, VILT

This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

Learn To:

Install Oracle RAC software.
Create cluster databases.
Administer both administrator and policy-managed Oracle RAC databases.
Monitor and address performance issues.
Learn about services in a RAC environment as well as highly available connection features including Application Continuity and Transaction Guard.
Create and administer a RAC One Node Database.
Create and manage multitennant RAC databases.
Gain an understanding of the Oracle Database Exadata Cloud Service.

OAE-W1: Oracle Application Express Workshop I

5 Days ILT, VILT

This OAE-W1: Oracle Application Express Workshop I training teaches you how to quickly and efficiently develop database-centric web applications using Oracle Application Express. Explore implementing security in your applications, managing application navigation, basic validation and debugging techniques used while developing an application in Oracle Application Express.

Learn To:

Create database applications for both desktop and mobile interfaces.
Add various components like new pages, reports regions, items and other components required to enhance an application.
Create processes, validations, computations and dynamic actions within an application.
Change the look and feel of your web applications using built-in themes and templates.
Create and use shared components for an application.
Understand managing and using session state variables.
Implement security in an application.
Manage application navigation using shared components.
Improvise your application by creating calendars, charts and trees.
Extend your application by adding advanced features like printing, BLOB object, data loading, site and more.
Enable feedback mechanisms from the application and tracking the feedback from Oracle APEX.

OD-12c-PMT: Oracle Database 12c: Performance Management and Tuning

RM6,500.00

5 Days ILT, VILT

In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service.

Learn To:

Use the Oracle tuning methodology.
Use Oracle-supplied tools for monitoring and diagnosing SQL and instance performance issues.
Use database advisors to proactively correct performance problems.
Identify and tune problem SQL statements.
Monitor instance performance by using Enterprise Manager.
Tune instance components.
Gain an understanding of the Oracle Database Cloud Service.

OD-12cR2-CA: Oracle Database 12c: Clusterware Administration

RM5,500.00

4 Days ILT, VILT

This Oracle Database 12c: Clusterware Administration training will explore general cluster concepts and Oracle Clusterware architecture. Work with expert Oracle University instructors through interactive instruction and hands-on exercises to reinforce your learning. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

Learn To:

Perform Grid Infrastructure pre-installation tasks.
Install both Standard and Flex clusters.
Add and remove nodes from a cluster in addition to upgrading and patching existing Grid Homes.
Manage and administer both Standard Clusters and Policy-Managed Clusters.
Use Oracle Clusterware to make applications highly available.
Gain an understanding of the Oracle Database Exadata Cloud Service.

OD-12cR2-PP: Oracle Database 12c R2: Program with PL/SQL

RM6,500.00

5 Days ILT, VILT

This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you’ll learn to develop stored procedures, functions, packages and more.

Learn To:

Conditionally control code flow (loops, control structures).
Create stored procedures and functions.
Use PL/SQL packages to group and contain related constructs.
Create triggers to solve business challenges.
Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
Create custom packages for applications.
Write Dynamic SQL code for applications.

OM-D: MySQL for Developers

5 Days ILT, VILT

Keep your mission-critical applications and essential services up and running with comprehensive MySQL training.

To grow your skillset and be more productive in your job, access a rich library of digital courses at your own convenience, then test your new skills through interactive, hands-on labs. Deepen your understanding of MySQL administration, development, security, and high availability in a risk-free environment through role- and topic-based courses. Learn what you need to know to deliver high-performance and scalable applications, then create new opportunities by getting MySQL certified.

The OM-D: MySQL for Developers training course teaches developers you how to develop console and web applications using MySQL with your choice of the PHP, Java, or Python programming languages. Expert Oracle University instructors will guide you through realistic hands-on activities in which you will learn how to use Connectors to access MySQL databases, query the database effectively, present data in different formats, and how to use MySQL’s support for JSON and spatial data.

Learn to:

Program with Connectors
Write console and web applications
Optimize query performance
Write stored routines and triggers
Store, access, and analyze geospatial data
Use X DevAPI to access JSON data in document store

OD-19c-STW: SQL Tuning Workshop

RM5,000.00

3 Days ILT, VILT

Oracle SOL Tuning for Developers Workshop course helps you learn how plans are tuned execution of Oracle SOL statements. You will learn how to write well-tuned SOL statements out of the box that are perfectly suited to Oracle DBMS.

OD-19c-DWT: Oracle Database 19c: Data Warehousing Techniques

RM5,000.00

3 Days ILT, VILT

The Oracle Database 19c: Data Warehousing Techniques course teaches you the various Data Warehousing concepts and techniques related to data extraction, transformation, and loading phases. You will learn about the different changed data capture methods for data refresh, and how to define summary management and implement materialized views. You will also learn about the role of warehouse metadata along with the various data warehouse implementation considerations.

OD-19c-DMT: Oracle Database 19c: Data Mining Techniques

RM4,500.00

2 Days ILT, VILT

The OD-19c-DMT: Oracle Database 19c: Data Mining Techniques course covers the basic concepts and primary terminologies associated with data mining. The course explains the steps associated with the data mining process, the use of Oracle Data Miner to perform data mining, and the options for deploying data mining predictive results.

OD-19c-DWC: Oracle Database 19c: Data Warehousing Concepts

RM4,500.00

2 Days ILT, VILT

This OD-19c-DWC: Oracle Database 19c: Data Warehousing Concepts course covers the following topics:

Evolution of information management systems and data warehousing
Need for machine learning, artificial intelligence, and big data in future data analytics
Data warehouse concepts and terminology
Multidimensional model concepts and create analytic views
Explain the business, logical, dimensional, and physical data warehousing models
Importance of extraction, transformation, and loading in data warehousing systems

OD-19c-DC: Oracle Database 19c: Data Confidentiality

1 Day ILT, VILT

The threat to data has never been greater. Oracle Database helps reduce the risk of a data breach and simplifies regulatory compliance with security solutions for encryption and key management, granular access controls, flexible data masking, comprehensive activity monitoring, and sophisticated auditing capabilities.

The OD-19c-DC: Oracle Database 19c: Data Confidentiality course covers the following topics:

Application Contexts
Virtual Private Database
Oracle Label Security
Data Masking
Data Redaction
Real Application Security

OD-19c-MMSE: Oracle Database 19c: Monitoring and Maintaining a Secure Environment

1 Day ILT, VILT

Gain skills and knowledge needed to design and implement security policies to protect data from accidental, unauthorized, or inappropriate actions.

After completing this course, you will have the skills and knowledge necessary to design and implement security policies to protect data from accidental, unauthorized, or inappropriate actions. You will also be able to create and enforce practices of auditing and accountability for such actions. In addition, you will be able to develop applications that provide desired services securely in a variety of computational models, making use of database and directory services to maximize both efficiency and ease of use. This course is therefore essential for anyone who wants to work in the field of computer security.

OD-19c-AW: Oracle Database 19c: Administration Workshop

5 Days ILT, VILT

Learn how to effectively manage and administer your Oracle Database.

This OD-19c-AW: Oracle Database 19c: Administration Workshop course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database.

In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

OD-19c-BR: Oracle Database 19c: Backup and Recovery

5 Days ILT, VILT

The student begins by gaining a deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architecture that support backup and recovery, along with implementation in various ways and situations are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication.

OD-19c-PMT: Oracle Database 19c: Performance Management and Tuning

5 Days ILT, VILT

Tune your databases with targeted queries and tuning methodology so you can identify problems before they arise.

Learn how to use advisors inside of an oracle database, as well as various tools provided by Oracle, in order configure the right settings for optimal performance. Gain skills in this Oracle database course to:

use targeted query tuning and methodology to identify tuning problems in an Oracle database to take corrective action
how to identify and tune a common database
troubleshoot performance issues
use advisors inside the database in order to understand in advance what settings need to be made and how to use the various tools provided by Oracle to configure the database

OD-19c-CAW: Oracle Database 19c: Clusterware Administration Workshop

RM5,500.00

4 Days ILT, VILT

A High Availability Cluster and the Foundation for Oracle RAC.

Oracle Clusterware is a portable cluster software that allows clustering of independent servers so that they cooperate as a single system. Oracle Clusterware was first released with Oracle Database 10g Release 1 as the required cluster technology for the Oracle multi-instance database, Oracle Real Application Clusters (RAC).

This OD-19c-CAW: Oracle Database 19c: Clusterware Administration Workshop course teaches you general cluster concepts and Oracle Clusterware architecture. In this course you will learn in-depth understanding of installing, configuring, patching and maintaining Oracle Clusterware 19c.

OD-19c-MA: Oracle Database 19c: Multitenant Architecture

4 Days ILT, VILT

The best database architecture for the hybrid cloud.

The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. Through a blend of hands-on labs and interactive lectures, you will explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs).

OD-19c-RACAW: Oracle Database 19c: RAC Administration Workshop

RM6,500.00

5 Days ILT, VILT

Get up to speed on Oracle RAC Administration.

This Oracle Database 19c: RAC Administration Workshop course will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion.

Learn To:

Install and configure RAC
Manage RAC Database
Upgrade and patch RAC Database
Manage backup and recovery for RAC
Monitor and tune RAC Database
Manage high availability of services
Implement High Availability for connections and applications
Configure RAC One Node Database
Implement In-Memory Column Store in RAC
Configure Multitenant Architecture in RAC
Manage Quality of Service in RAC

OD-19c-SQLTQ: Oracle Database 19c: SQL Tuning Workshop

RM5,000.00

3 Days ILT, VILT

Learn to write well-tuned SQL statements for the Oracle database.

This Oracle Database course teaches you how to write well-tuned SQL statements appropriate for the Oracle database. This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning.

MySQL Cloud Service provides numerous benefits over an on-premise database. It is easy to create a cloud instance, with flexible options for computing power, memory, and storage. GUI tools are available for backup and restore as well as patching and rolling back. After completing this course, you can take advantage of those benefits to use MySQL Cloud Service to its best advantage.

OD-19c-ASMAW: Oracle Database 19c: ASM Administration Workshop

RM4,500.00

2 Days ILT, VILT

Expand your database knowledge and gain an edge in a competitive IT marketplace.

Explore the most advanced features and methods for achieving maximum performance, availability, and reliability using core database technologies and features. Learn how to leverage enhancements in multitenant architecture, manage security, use RMAN, understand general Database Administration functionality, implement big data, and more.

This Oracle Database course teaches you about Oracle ASM architecture and its components. During the training, you will get a deep understanding of both standard ASM and Flex ASM applications.

OD-19c-AP: Oracle Database 19c: Advanced PL/SQL

3 Days ILT, VILT

Oracle Database 19c is the latest release of Oracle’s flagship relational database management system.

This Oracle Database course teaches you how to use the advanced features of PL / SQL to design and tune PL / SQL to interface with the database and other applications.

In Oracle Database 19c: Advanced PL/SQL training you will learn advanced features of program design, packages, cursors, extended interface methods and collections. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.

OD-19c-DE: Oracle Database 19c: Data Encryption

1 Day ILT, VILT

This is a newly curated course of one day duration that covers the Data Encryption aspect related to the latest of release of Oracle Database (19c).

The course covers the following topics:

Managing Endpoints and Oracle Wallets
Encryption
Key Vault and Transparent Data Encryption
Performing Oracle Key Vault Administrative Tasks

OD-19c-SF: Oracle Database 19c: Security Fundamentals

1 Day ILT, VILT

This OD-19c-SF: Oracle Database 19c: Security Fundamentals course teaches you Security aspect related to the latest release of Oracle Database (19c).

OD-19c-FDS: Oracle Database 19c: Fundamentals for Devs and SysAdmins

RM4,500.00

2 Days ILT, VILT

This OD-19c-FDS: Oracle Database 19c: Fundamentals for Devs and SysAdmins course teaches you how to perform common, day-to-day administrative tasks that are required of an Oracle database administrator (DBA).

The Oracle database course covers the following topics:

Install the Oracle Database Software and Create a Database
Use Enterprise Manager Database Express
Use SQL*Plus and SQL Developer
Use the Listener Control Utility
Use SQL Developer to Shut Down and Restart a Database
View Initialization Parameters
Manage the Database Storage Structures
Administer Users and Security
Create Application Tables and Load Database
Perform Backup and Recovery
Monitor Database Performance

Get trained and certified to become an expert on the world’s most widely-used Oracle products.

Get trained and certified to become an expert on the world’s most widely-used Oracle products.

Frequently Asked Questions

Stay connected. Be the first to know.

Company

Customer Service

Principals

Stay connected. Be the first to know.

Trainocate: A Global Leader in Technology, Business, and People Development