Oracle Education - IT Training and Certification

IT Infrastructure Training and Certification

OAM-12c-AE: Oracle Access Management 12c: Administration Essentials

RM6,500.00

5 Days ILT, VILT

This OAM-12c-AE: Oracle Access Management 12c: Administration Essentials training teaches you how to install, configure and implement a real life deployment of Oracle Access Manager 12c PS3 (12.2.1.3). Work with expert Oracle University instructors to install, troubleshoot, diagnose and more.

Learn To:

Install and configure Oracle Access Manager 12c PS3.
Configure servers, data sources and agents.
Set up policy configuration (shared components and application domain).
Manage sign-on, sign-off and sessions. Configure detached credential collector [DCC] Set up auditing, logging and troubleshooting for OAM 12c PS3.
Manage sessions, policy and agents with the REST API.

Cloud Computing Training & Certification

OEM-CC-13c: Using Oracle Enterprise Manager Cloud Control 13c

3 Days ILT, VILT

This Using Oracle Enterprise Manager Cloud Control 13c training teaches you how to use Enterprise Manager Cloud Control to monitor and manage your enterprise-computing environment. You’ll learn how to use the Cloud Control framework, the out-of-box capability to manage Oracle targets, individually or in groups with templates, monitor the compliance of targets, use the job system to automate commonly performed tasks, view and compare configurations and create and use predefined and customized reports.

Learn To:

Navigate and monitor the overall health of your Cloud Control system.
Organize targets and groups.
Setup targets monitoring, alerts and notifications. Use the job system to create and manage jobs to automate commonly performed tasks.
View, search and compare configurations. Explain provisioning and manage targets patching.
Use compliance policies and evaluate policy violations. Use BI Publisher to generate custom reports.

OEMCC-13c-IU: Oracle Enterprise Manager Cloud Control 13c: Install & Upgrade

RM4,500.00

2 Days ILT, VILT

In the Oracle Enterprise Manager Cloud Control 13c: Install & Upgrade course, you’ll learn about the architecture of Oracle Enterprise Manager Cloud Control 13c, implementation options and you’ll perform a standard single-server installation. In this course we will also review the available upgrade paths from previous versions and execute a 1-system upgrade from Enterprise Manager Cloud Control 12c 12.1.0.5

Learn To:

Install Oracle Enterprise Manager Cloud Control 13c.
Plan and execute a 1-system upgrade from Oracle Enterprise Manager Cloud Control 12c.

Analytics and Data Training and Certification

OD-12cR2-IUW: Oracle Database 12c: Install and Upgrade Workshop

RM4,500.00

2 Days ILT, VILT

This Oracle Database 12c: Install and Upgrade Workshop gives you detailed information to help you install Oracle Database 12c software. Expert Oracle instructors will teach you how to create a container database and provision pluggable databases. In this course, you will be introduced to Oracle Database Cloud Service.

Learn To:

Install Oracle Grid Infrastructure for a Standalone Server.
Use Oracle Restart to manage components.
Upgrade an existing Oracle Database to Oracle Database 12c.
Create a container database and provision pluggable databases.
Gain an understanding of the Oracle Database Cloud Service.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Gain Hands-On Experience

Get practical experience installing the Oracle Grid Infrastructure software and Oracle Database software by using Oracle Universal Installer. Expert Oracle instructors will teach you how to stop and start Oracle Restart using SRVCTL to manage components.

OD-12c-GDS: Oracle Database 12c: Global Data Services

RM4,000.00

1 Day ILT, VILT

The Oracle Database 12c: Global Data Services seminar helps you learn about Oracle Database 12c Global Data Services (GDS). Expert Oracle instructors will teach you how to install, configure, administer and use Global Data Services.

Learn To:

Install Global Data Services.
Configure the Global Data Services framework.
Administer Global Data Services Clouds.

Topics Covered:

Global Data Services overview
Global Data Services framework
Global Services theory
Global connection load balancing
Global runtime connection load balancing
Global Services failover

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Explore Global Data Services

You’ll also learn about the benefits provided by Global Data Services for managing cloud-deployed distributed databases. Furthermore, you’ll review best practices for configuring Global Data Services to use Oracle Active Data Guard configuration and Oracle GoldenGate replication.

OD-NDD: Oracle NoSQL Database for Developers

RM4,500.00

2 Days ILT, VILT

In the Oracle NoSQL Database for Developers Ed 1 course, you will learn how to use the Oracle NoSQL Database developer APIs for Java. You will also discover how to access the KVStore from a Java application to store and manipulate data in a KVStore.

Learn To:

Understand the key concepts of the NoSQL technology and when to use the Oracle NoSQL Database versus an RDBMS.
Learn to design the schema for a Java application using a table based approach as well as a key value pair approach.
Learn to create the code for storing, manipulating and deleting data stored in a KVStore.
Handle exceptions and implement security, consistency, and durability policies for the KVStore and an application.

You will identify the features and benefits of the Oracle NoSQL Database and will discover why and how Oracle NoSQL Database is used to store data, generally Big Data.

OD-NDA: Oracle NoSQL Database for Administrators

RM4,500.00

2 Days ILT, VILT

This Oracle NoSQL Database for Administrators training teaches you how to deploy a KVStore and troubleshoot installation and hardware failures. Expert Oracle University instructors will also teach you how to monitor and manage a KVStore.

Learn To:

Plan installation of Oracle NoSQL Database.
Install and configure Oracle NoSQL Database.
Deploy Oracle NoSQL Database KVStore.
Secure the configuration.
Extend a KVStore by increasing the replication factor or capacity of the KVStore.
Troubleshoot installation and hardware failures.
Monitor and optimize Oracle NoSQL Database performance.
Perform backup, recovery, and upgrades.

When you walk away from this course, you’ll be able to identify the features and benefits of the Oracle NoSQL Database. You’ll have a deeper understanding of how to optimize the KVStore’s performance.

Programming and Software Development Training and Certification

OJ-JEE-AEA: Architect Enterprise Applications with Java EE

RM6,500.00

5 Days ILT, VILT

This Architect Enterprise Applications with Java EE training teaches you to develop architectures for enterprise Java applications using the Java Platform, Enterprise Edition (Java EE) technology. Understand Java EE and relevant technologies.

This Architect Enterprise Applications with Java EE training teaches you how to develop robust architectures for enterprise Java applications. Learn how to use Java Platform, Enterprise Edition (Java EE) technology.

Learn How To:

Define the Enterprise Architect’s roles, responsibilities and deliverables.
Identify non-functional requirements (NFRs) and describe common problems and solutions.
Translate business requirements into an architecture.
Weigh choices in architecting the client, web, business, integration and data tiers.
Apply various evaluation criteria to choosing architectural elements and patterns, tools, servers and frameworks.

Benefits to You

By enrolling in this course, you’ll understand how Enterprise Java applications developed using the architecture as a guideline can accommodate rapid change and growth. Expert Oracle University instructors will help you explore the technical context of the Java EE and relevant technologies.

Strategies to Create Application Blueprints

You’ll also learn the strategies needed to create application blueprints that work well when implementing Java EE technologies. These strategies include effective decision-making through the use of non-functional qualities (such as scalability and flexibility), Java EE technology blueprints and design patterns.

OJ-JDP: Java Design Patterns

RM5,500.00

4 Days ILT, VILT

This Java Design Patterns training reviews common patterns specific to Java SDK & EE development. Lab exercises teach you to identify, apply and re-factor these patterns into code, using a NetBeans or Eclipse IDE and the GlassFish Application Server v3.

This Java Patterns course reviews common and emerging patterns specific to Java SDK and EE development. You’ll learn the depth and evolution of pattern-based techniques in Java, with particular emphasis on Java EE 6 conventions.

Learn To:

Dinstinguish between Java EE 5 and Java EE 6 pattern-based features.
Implement relevant patterns in each tier of the Java EE environment.
Re-factor code to improve inter-tier communications.
Relate pattern-based development to an implementation architecture.
Apply object-oriented pronciples and design guidelines.
Implement well-known patterns to Java-specific code problems.

Lab Exercises

The lab exercises show you how to identify, apply and re-factor selected patterns into code, using a NetBeans or Eclipse IDE and the GlassFish Application Server v3. You’ll also learn a subset of UML notation to expedite communicating through design instead of code.

Java Design Patterns

In design patterns, the responsibility of each component is identified by role. The conventions of design pattern documentation make it easier for development teams to communicate their programming intentions and provide a reference point for the entire Java development community.

Java-Based Frameworks

The Java language and popular Java-based frameworks incorporate more proven development practices into their programming interfaces with each major release. These practices, referred to as design patterns, document well-known names, code implementation and re-factoring techniques, and the risks and trade-offs associated with using them.

OJ-JEE7-BSAD: Java EE 7: Back-End Server Application Development

RM6,500.00

5 Days ILT, VILT

The Java EE 7: Back-End Server Application Development training teaches you how to build and deploy enterprise applications that comply with Java Platform, Enterprise Edition 7 Full Profile. Learn to develop applications with the following technologies: Enterprise JavaBeans (EJB), Java Persistence API (JPA), JDBC, Java Transaction API (JTA), Contexts and Dependency Injection (CDI), Java Message Service (JMS), Bean Validation, Batch API, Timer services, Java EE Concurrency and more.

Learn To:

Use Java EE 7 technologies to create, read, update and delete database records using both JDBC and JPA technologies.
Create a flexible component model using EJB and CDI technology.
Create SOAP-based and XML web services.
Develop the business and integration tiers of an enterprise application.
Understand how those components responsible for: interacting with other systems through web services and message queues.
Become proficient with database access and manipulation using transactions.
Provide timer, concurrency and batch services.
Develop expertise using Java Enterprise Edition 7, the latest version of the Java platform for development of enterprise applications.

Benefits to You

When you walk away from this course, you will have developed the knowledge and skills to read and write messages to systems that may or may not be developed using Java with Java Message Service create batch services to process thousands of jobs in parallel. This interactive, hands-on training is an excellent follow-up course to the Java EE 7: Front-end Application Development training.

OJ-JEE7-FWAD: Java EE 7: Front-end Web Application Development

RM6,500.00

5 Days ILT, VILT

The Java EE 7: Front-end Web Application Development training teaches you how to build and deploy enterprise applications that comply with Java Platform, Enterprise Edition 7 Web Profile. The technologies presented in this course include annotations, Session Enterprise JavaBeans (EJB-Lite), Java Persistence API (JPA), servlets, JavaServer Pages(JSPs), Contexts and Dependency Injection (CDI), JAX-RS RESTful web services, the Java API for WebSocket and more.

This Java EE 7: Front-end Web Application Development training helps you explore building and deploying enterprise applications that comply with the Java Platform, Enterprise Edition 7 Web Profile. Expert Oracle University instructors will help you explore annotations, Session Enterprise JavaBeans (EJB-Lite), Java Persistence API (JPA), servlets, JavaServer Pages(JSPs), Contexts and Dependency Injection (CDI), JAX-RS RESTful web services, the Java API for WebSocket and the Java API for JSON processing.

Learn To:

Develop web-based interfaces for both desktop and mobile devices.
Assemble an application.
Build Java applications.
Deploy an application into an application server (Java EE platform runtime environment).

Benefits to You

By taking this course, you’ll gain hands-on experience building Java EE web applications. You will get the chance to create web-based user interfaces using HTML5 and JavaScript along with JSPs and servlets. Web-based user interfaces will use AJAX to communicate with RESTful web services you create; data will persist using JPA and optimistic locking.

Participate in Hands-On Labs

By learning through hands-on exercises via structured labs, you’ll get a chance to explore EJB-Lite session bean components, which can be used with container-managed transactions. You’ll perform lab exercises using the NetBeans IDE and WebLogic Server.

OJ-JPT: Java Performance Tuning

RM5,000.00

3 Days ILT, VILT

This Java Performance Tuning training teaches performance tuning concepts applicable to the Java programming language. Learn the conceptual background for Java garbage collection, how it applies to Java garbage collectors on the Hotspot JVM, and more.

This Java Performance Tuning training teaches performance tuning concepts applicable to the Java programming language. Expert Oracle University instructors will teach you how it applies to Java garbage collectors on the Hotspot JVM, including the G1 garbage collector.

Learn To:

Monitor, profile and tune your Java applications.
Use command line and visual tools to perform these tasks.
Get hands on practice with Visual VM, Java Mission Control, Flight Recorder and the NetBeans IDE.
Use these tools and techniques to analyze Java 7 and earlier JVMs.
Effectively apply tools like Java Mission Control and Flight Recorder to your daily work.

Benefits to You:

Learn how Java garbage collection works and how it affects your applications. Learn how to select the appropriate garbage collector and performance goal for your applications. Finally, use the Mission Control and Java Flight Recorder tools to monitor and analyze your applications.

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.

OJ-SE-EMONF: Java SE: Exploiting Modularity and Other New Features

2 Days ILT, VILT

The Java SE: Exploiting Modularity and Other New Features introduces the Java module system and other new features, including JShell, convenience methods, new techniques for working with streams, and managing deprecated APIs. These features were introduced in versions after Java 8, and therefore new to developers migrating to Java 11.

Learn To:

Design applications to take advantage of the module system and its more reliable configuration, improved security and performance, and more easily scalable applications. Migrate existing applications to a modular applications in a step-by-step manner, choosing which parts of the application to migrate first. Deal with common problems encountered in migrating an application, including, cyclic dependencies and split packages. Use services to make modularized applications more robust and easily extensible. Create multi-release JAR files that can be run on different Java releases. Use convenience methods to reduce code that seems verbose, inefficient or boilerplate, and increase readability. Use JShell to quickly run small code experiments and test new APIs.

Benefits To You:

By enrolling in this course, you’ll learn how to use the module system to design applications with explicit dependencies and encapsulation at the JAR level, ensuring more reliable configuration, improved security and enhanced performance. You’ll also get a chance to experiment with new features that ease development. These include convenience methods that make your code more readable and succinct, and JShell, an easy way to test code snippets and APIs.

OJ-JSH5-DWA: JavaScript and HTML5: Develop Web Applications

RM5,500.00

4 Days ILT, VILT

This JavaScript and HTML5 course features the JavaScript language, from language fundamentals to dynamic interactions with browsers, DOM, HTML5, CSS3, JSON, REST, AJAX, WebSocket, and jQuery. This course includes several demos for the student to hack in each lesson.

This JavaScript and HTML5 course teaches you how to code application logic in web applications using JavaScript and how to create HTML5 pages to parse and send data using HTML5 forms. Create and modify the Document Object Model(DOM), create responsive layouts with CSS3, store local data with JSON, and draw on HTML5 canvas. Students will add interactive behaviors to web pages creating better user experiences and add dynamic data using AJAX, REST and WebSocket with JavaScript.

Learn To:

Code application logic using JavaScript to control user interactions and display data.
Create applications with HTML5 forms to send data to services.
Debug and inspect web applications and styles using browser’s tools.
Create design templates and standards using CSS and JavaScript that adapt to different devices including mobile with Media Queries and Responsive Design.
Read and validate data from HTML5 forms using JavaScript.
Parse, modify, and validate data using Javascript API.
Add interactivity in HTML5 forms using events and DOM modification.
Store and send JavaScript Object data to services, local storage or across different pages and HTML5 elements using JavaScript Object Notation.
Draw on HTML5 canvas using JavaScript.
Store user data in web applications using HTML5 Local Storage
Create JavaScript code to retrieve and display dynamic data from REST services using AJAX.
Create JavaScript code to interact with WebSocket for real-time communication.
Create jQuery code to animate elements, handle DOM, events, or AJAX responses.

Benefits to You

This course will prepare any web developer with enough JavaScript, HTML5 and CSS3 knowledge to build complex and modern sites and for those looking to develop Java EE front-end web applications.

OD-MMA: Oracle Database: Managing Multitenant Architecture

4 Days ILT, VILT

This OD-MMA: Oracle Database: Managing Multitenant Architecture course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases.

You learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged pluggable databases in multitenant container databases using various methods.

In addition, you learn how to create common and local users and administer database security to meet your business requirements by using encryption, Database Vault and auditing and you will learn how to create a database deployment in the Cloud.

Versions Supported: 19c, 18c, 12c

OD-ULE: UNIX and Linux Essentials

RM5,000.00

3 Days ILT, VILT

This UNIX and Linux Essentials course is designed for users and administrators who are new to the Oracle Linux and Oracle Solaris operating systems. It will help you develop the basic UNIX skills needed to interact comfortably and confidently with the operating system.

Learn To:

Manage files and directories from the command line and learn to use the vim editing tool.
Perform remote connections and file transfers.
Customize the user environment and use advanced shell features in shell scripts.
Archive and compress files and directories.
Understand and manage process control.
View and modify file and directory permissions.

Benefits to You

Learn to work effectively with UNIX and Oracle Linux environments and master the fundamental administrative tasks for these operating systems. These are the first steps to ensuring fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto Oracle Cloud or private clouds.

OWS-12c-TW: Oracle WebLogic Server 12c: Troubleshooting Workshop

RM4,500.00

2 Days ILT, VILT

This Oracle WebLogic Server 12c: Troubleshooting Workshop training teaches administrators how to diagnose and troubleshoot Oracle WebLogic Server 12c problems and issues. Emphasizing hands-on practices rather than lectures, the course requires prior WebLogic Server 12c administration experience.

Learn How To:

Diagnose WebLogic Server problems.
Enable debugging for a WebLogic Server feature.
Troubleshoot common WebLogic Server problems.

Knowing how to diagnose and troubleshoot Oracle WebLogic Server issues increases the performance and scalability of your organization’s applications and services. Use Troubleshooting Tool. You learn how to use tools to assist in troubleshooting, including the WebLogic Server Administration Console, the Monitoring Dashboard, and the WebLogic Diagnostic Framework. In hands-on practices, you solidify your understanding of new topics by learning how to apply this knowledge to your daily job. Practice Troubleshooting Problems Enrolling in this course gives you a chance to practice troubleshooting problems. You’ll use Oracle WebLogic server itself, along with the Java Virtual Machine, deployment of Java Enterprise Edition applications, Java Database Connectivity, Node Manager, WebLogic Server clusters, and WebLogic Server security.

OD-DPUW: Oracle Database: Deploy, Patch and Upgrade Workshop

RM4,500.00

2 Days ILT, VILT

This Oracle Database: Deploy, Patch and Upgrade Workshop gives you detailed information to help you install Oracle Database software. Expert Oracle instructors will teach you how to create a container database and provision pluggable databases. In this course, you will be introduced to Oracle Database Cloud Service.

Learn To:

Install Oracle Grid Infrastructure for a Standalone Server.
Use Oracle Restart to manage components.
Upgrade an existing Oracle Database.
Create a container database and provision pluggable databases.
Gain an understanding of the Oracle Database Cloud Service.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Gain Hands-On Experience

Get practical experience installing the Oracle Grid Infrastructure software and Oracle Database software by using Oracle Universal Installer. Expert Oracle instructors will teach you how to stop and start Oracle Restart using SRVCTL to manage components.

OD-18c-HANF: Oracle Database 18c: High Availability New Features Ed 1

RM4,000.00

1 Day ILT, VILT

In the Oracle Database 18c: High Availability New Features course, students will learn about new software features and improvements found in Oracle Clusterware, Oracle ASM, Real Application Clusters, and Oracle Data Guard.

Configure and implement Oracle Clusterware enhancments.
Use and manage ASM using the new features in this release.
Use additional enhancements for Oracle ACFS and ADVM.
Leverage Oracle RAC new featuers found in this release.
Configure and use Oracle Data Guard new features.
Use new Data Guard Broker commands.

OD-12c-SQLW2: Oracle Database: SQL Workshop II

RM4,500.00

2 Days ILT, VILT

The Oracle Database: SQL Workshop II Ed 2 course will help students enhance their skills as Application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries. Students also learn to write more efficient queries using the functions supporting the timezone and regular expressions.

Learn To:

Grant and revoke privileges and roles.
Manage schema objects and data dictionary views.
Write efficient and complex subqueries.
Use the in-built functions supporting the usage of regular expressions and time zone.

OD-12cR2-ASMA: Oracle Database 12c: ASM Administration

RM4,500.00

2 Days ILT, VILT

This Oracle Database 12c: ASM Administration training teaches you about Oracle ASM architecture. Expert Oracle University instructors will help you develop a deeper understanding of both standard ASM and Flex ASM applications. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

Learn To:

Administer ASM files, directories, templates, and disk groups.
Manage and administer Oracle Cloud File System and its components.
Configure and manage advanced CloudFS features like ACFS Auditing and Encryption, ACFS Replication and High Availability NFS.
Gain an understanding of the Oracle Database Exadata Cloud Service.

OAE-W2: Oracle Application Express Workshop II

3 Days ILT, VILT

This Oracle Application Express Workshop II Ed 2 training will build on the knowledge learned in the 5-day Oracle Application Express Workshop I course. You’ll examine topics that including learning how to use collections, add dynamic actions, create and customize plug-ins, and create and consume a RESTful Web Service.

Learn To:

Extend Your applications using collections, dynamic application and plug-ins.
Create and use RESTful Web Services.
Make your application accessible.
Customize themes and templates.
Establish a master application and corporate theme that many applications can use.
Migrate an existing application to a new theme.
Incorporate a jQueryUI ThemeRoller theme into your mobile application.
Secure, deploy and maintain your applications.
Optimize your application performance.

OJ-SE-P1: Java SE: Programming I

RM6,500.00

5 Days ILT, VILT

This entry-level course is aimed at programmers who are new to Java and who need to learn its concepts, language constructs, and data types. Included in the agenda are topics on exception handling, lambda expressions, and modular programming.

The course is designed for programmers who will apply these language skills to develop programs using the latest major versions of the JDK, currently Java 11. Students practice the skills learned in each lesson through hands-on labs.

OJ-SE-P2: Java SE: Programming II

RM6,500.00

5 Days ILT, VILT

This is a second-level course for people learning the Java language. It provides the additional key skills needed by Java programmers. This course uses today’s main Java version for its practices (currently Java 11).

Learn To:

This is a second-level course for programmers learning the Java language. It rounds-out the topics that were taught in the previous course, Java SE: Programming I, and provides additional key skills for Java programmers, such as secure coding, modular programming, and database access. This course uses today’s main Java version for its practices (currently Java 11).

OD-18c-NFA: Oracle Database 18c: New Features for Administrators

RM5,000.00

3 Days ILT, VILT

This course provides an overview of the Oracle Database 18c new features and enhancements related to Multitenant architecture, security, RMAN, general database areas, performance, data warehousing and Sharding.

Learn To:

Use new features like Application PDB Fleet and PDB snapshots carousel of the Multitenant architecture.
Understand new features like PDB keystores and encryption of sensitive data in Database Replay files of the Security.
Benefit from new features like reuse of preplugin backups and duplication of active PDBs into an existing CDB of RMAN.
Use new features like private temporary tables and online modification of partitioning and subpartitioning strategy of General Database.
Configure and use new features like Automatic In-Memory Management in Performance.
Manipulate new features like inline external tables and polymorphic table functions of the Data Warehousing.
Understand enhancements like user-defined sharding method and support for PDBs as shards in Sharding.

OD-12c-SQLW1: Oracle Database 12c R2: SQL Workshop I

RM5,000.00

3 Days ILT, VILT

The Oracle Database: SQL Workshop I Ed 3 course offers students an introduction to Oracle Database 12c database technology. The students are also introduced to Oracle Database Exadata Express Cloud Service. In this class 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.

Learn To:

Identify what a SQL statement is.
Understand the Oracle Relational Database.
Use SQL Developer.
Write reports using SQL Statements.
Manipulate data in relational tables and save the data.

OBD-F: Oracle Big Data Fundamentals

5 Days ILT, VILT

In the Oracle Big Data Fundamentals course, learn to use Oracle’s Integrated Big Data Solution to acquire, process, integrate and analyze big data. In this course, you will be introduced to Oracle Big Data Cloud Service.

Learn To:

Define Big Data.
Describe Oracle’s Integrated Big Data Solution and its components.
Define the Hadoop Ecosystem and Cloudera’s Distribution Including Apache Hadoop (CDH).
Use the Hadoop Distributed File System (HDFS)to store, distribute, and replicate data across the nodes in the Hadoop cluster.
Acquire big data using the HDFS Command Line Interface, Flume, and Oracle NoSQL Database.
Use MapReduce and YARN for distributed processing of the data stored in the Hadoop cluster.
Process big data using MapReduce, YARN, Hive, Pig, Oracle XQuery for Hadoop, Solr, and Spark.
Integrate big data and warehouse data using Scoop, Oracle Big Data Connectors, Copy to BDA, Oracle Big Data SQL, Oracle Data Integrator, and Oracle GoldenGate.
Analyze big data using Oracle Big Data SQL, Oracle Advanced Analytics technologies, and Oracle Big Data Discovery.
Use and manage Oracle Big Data Appliance. Secure your data.
Understand Oracle Big Data Cloud Service: Key Features & Benefits.

OD-12cR2-SPF: Oracle Database 12c: SQL and PL/SQL Fundamentals

RM6,500.00

5 Days ILT, VILT

This Oracle Database: SQL and PL/SQL Fundamentals training delivers the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You’ll explore the concepts of relational databases.

Learn To:

Write queries against single and multiple tables, manipulate data in tables and create database objects.
Use single row functions to customize output. Invoke conversion functions and conditional expressions.
Use group functions to report aggregated data. Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
Develop anonymous PL/SQL blocks, stored procedures and functions. Declare identifiers and trap exceptions.
Use DML statements to manage data.
Use DDL statements to manage database objects.
Declare PL/SQL Variables.
Conditionally control code flow (loops, control structures).
Describe stored procedures and functions.
Retrieve row and column data from tables.

OD-12cR2-SQLTD: Oracle Database12c R2: SQL Tuning for Developers

RM5,000.00

3 Days ILT, VILT

In the Oracle Database: SQL Tuning for Developers course, you learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.

Learn To:

Use Oracle tools to identify inefficient SQL statements.
Use Automatic SQL Tuning.
Use Real Time SQL monitoring.
Write more efficient SQL statements.
Monitor and trace high load SQL statements.
Manage optimizer statistics on database objects.
Understand the optimizer process steps and operators.
Interpret execution plans.
Perform application tracing.
Gain an understanding of the Oracle Database Exadata Express Cloud Service

OD-12cR2-AP: Oracle Database 12c R2: Advanced PL/SQL

RM5,000.00

3 Days ILT, VILT

In the Oracle Database 12c R2: Advanced PL/SQL course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and integrate with the other applications in the most efficient manner. They learn to write powerful PL/SQL programs using external C/Java routines, fine-grained access packages, cursors, extended interfaces and collections.

Learn To:

Apply PL/SQL designing best practices.
Create PL/SQL applications that use collections.
Work with JSON data in the database.
Implement a virtual private database with fine-grained access control.
Write code to interface with external C and Java applications.
Write code to interface with large objects and use SecureFile LOBs.
Write and tune PL/SQL code effectively to maximize performance.

ODS-DC: Oracle Database Security: Detective Controls

RM6,500.00

5 Days ILT, VILT

In the Oracle Database Security: Detective Controls course, students learn how they can use Oracle Database administration auditing features to meet the compliance requirements of their organization. The current regulatory environment requires better security at the database level. Students learn how to audit the access to their databases and how to use the auditing and compliance features to monitor data access and confidentiality. The course provides suggested Oracle solutions for common problems.

Learn To:

Enumerate Oracle auditing solutions to monitor database security requirements.
Implement Oracle Audit Vault and Oracle Database Firewall.
Configure Oracle Audit Vault and Oracle Database Firewall.
Explain Oracle Compliance Framework.
Configure basic Compliance Framework rules.

OJ-SE8-P: Java SE 8 Programming

5 Days ILT, VILT

This covers the core language features and Application Programming Interfaces (API) you will use to design object-oriented applications with Java Standard Edition 8 (Java SE 8) Platform.

OD-12cR2-BRW: Oracle Database 12c R2: Backup and Recovery Workshop

5 Days ILT, VILT

In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations.

Learn To:

Develop appropriate backup and recovery procedures to address your business needs.
Implement backup and recovery settings and perform backup operations to disk and tape.
Employ Oracle Database recovery procedures to recover from media and other failures.
Diagnose and repair data failures.
Use Flashback Technologies and data duplication to complement backup and recovery procedures.
Secure the availability of your database by appropriate backup and recovery strategies.

OD-XMLF: Oracle Database: XML Fundamentals

RM4,500.00

2 Days ILT, VILT

This XML Fundamentals training introduces you to the basics of XML. In this 2 day hands on course, you will learn the central XML technologies, including writing well formed and valid XML, creating Document Type Definitions (DTDs) and XML schema documents and using XPath and XQuery.

Learn To:

Create well-formed and valid XML documents.
Use XML Namespaces in an XML document to resolve name ambiguities in XML documents.
Create Document Type Definition and XML schema documents to validate XML documents.
Use XPath expressions and functions to find and select nodes in XML documents.
Transform XML documents by using stylesheets and XPath expressions.
Use Oracle JDeveloper to view, create, edit, and test XML and other XML-related documents.
Use XQuery to query, generate, and transform XML content.
Identify the features and benefits of Oracle XML DB

OM-F: MySQL Fundamentals

RM5,500.00

4 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 MySQL Fundamentals training is the first step in mastering MySQL, the world’s most popular open source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools.In this course, you will be introduced to the MySQL Cloud Service.

Learn To:

Explain the relational database model.
Describe the features and benefits of MySQL.
Install and configure the MySQL server and clients.
Design efficient databases.
Use Structured Query Language (SQL) to build your database and query data.
Employ appropriate MySQL tools.
Gain an understanding on the MySQL Cloud Service.

OJ-SE8-F: Java SE 8 Fundamentals

5 Days ILT, VILT

This Java SE 8 Fundamentals training introduces you to object-oriented programming using the Java language. Through hands-on exercises, you’ll begin to build a baseline of knowledge to propel your career in development. Learn To: Use Java programming language constructs to create a Java technology application. Use decision and looping constructs and methods to dictate program flow.

Understand basic object oriented concepts such as inheritance, encapsulation, and abstraction. Use and manipulate object references, and to write simple error handling code.Use the new SE 8 java.time and java.time.format packages to format and print the local date and time.Specify a data modification by passing a predicate lambda expression to the Collections class.

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