Trainocate - Oracle

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

Millions of professionals around the world take online or in-person Oracle training courses through Oracle University. Each course is designed to maximize your understanding of how to get the most out of Oracle technology you use every day.

Oracle training courses also prepare you to earn a well-respected Oracle Certification that increases your chances of getting hired. In fact, over 1.8 million working professionals have taken the time to study for and pass Oracle Certification exams that test and validate their technical knowledge. We offer specific training courses that increase your chances of passing related certification exams.

Oracle training courses will help you become more informed and more efficient so you can use Oracle products to drive measurable results. Get maximum ROI with your technology investment, stand out in a competitive global job market and increase your earning potential.

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

Millions of professionals around the world take online or in-person Oracle training courses through Oracle University. Each course is designed to maximize your understanding of how to get the most out of Oracle technology you use every day.

Oracle training courses also prepare you to earn a well-respected Oracle Certification that increases your chances of getting hired. In fact, over 1.8 million working professionals have taken the time to study for and pass Oracle Certification exams that test and validate their technical knowledge. We offer specific training courses that increase your chances of passing related certification exams.

Oracle training courses will help you become more informed and more efficient so you can use Oracle products to drive measurable results. Get maximum ROI with your technology investment, stand out in a competitive global job market and increase your earning potential.

  • 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).

  • 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.
  • 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

    Price range: RM6,500.00 through RM7,603.00
    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

    Price range: RM6,500.00 through RM7,680.00
    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.
  • OJ-SE8-F: Java SE 8 Fundamentals

    Price range: RM6,500.00 through RM7,562.00
    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.

  • 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).
  • 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

    Price range: RM6,500.00 through RM7,603.00
    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

    Price range: RM6,500.00 through RM7,680.00
    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.

  • 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.
  • 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).

  • 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.
  • 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

    Price range: RM6,500.00 through RM7,603.00
    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-AW: Oracle Database 19c: Administration Workshop 

    Price range: RM6,500.00 through RM7,562.00
    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 

    Price range: RM6,500.00 through RM7,562.00
    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 

    Price range: RM6,500.00 through RM7,562.00
    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
  • 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-SQLW: Oracle Database 19c: SQL Workshop 

    Price range: RM6,500.00 through RM7,562.00
    5 Days ILT, VILT

    The Oracle Database 19c: SQL Workshop course offers students an introduction to Oracle Database 19c database technology. 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.

  • 5 Days ILT, VILT

    This Oracle course introduces the main architectural concepts of Oracle Data Guard. The delegate will learn how to use Oracle Data Guard to protect an Oracle Database against planned and unplanned downtime.

    Through a blend of hands-on labs and interactive lectures you will also learn how to create and manage physical, logical and snapshot standby databases and how to use standby databases for reporting, querying and testing purposes.

  • OD-19c-PW: Oracle Database 19c: PL/SQL Workshop

    Price range: RM6,500.00 through RM7,562.00
    5 Days ILT, VILT

    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 OD-19c-PW: Oracle Database 19c: PL/SQL Workshop course introduces students to PL/SQL, Procedural Language for SQL. Explore the differences between SQL and PL/SQL. Examine the characteristics of PL/SQL and how it is used to extend and automate SQL.

  • 5 Days ILT, VILT

    The Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1 training course will give you a detailed overview of following modules, the Using SQL New Features and Tools, the Understanding DB Architectures, and the Diagnosing Database Problems. During the training, you will be skilled with the knowledge about on-premises Multitenant databases and various other new features in different areas of database administration.

  • OJ-SE11-PC: Java SE 11: Programming Complete 

    Price range: RM6,500.00 through RM7,603.00
    5 Days ILT, VILT

    Learn how to create secure, portable, high-performance applications using the world’s #1 programming language.

    This comprehensive course is suitable for experienced programmers who want to learn the full Java programming language (Java SE), the language constructs, handle collections and concurrency, and utilize core language APIs and modularization. It is designed for people with existing knowledge of computing and programming concepts, and who need to learn all aspects of Java SE in the shortest possible time. Students practice the skills learned in each lesson through hands-on practices. The course is based on the current long-term support version, Java SE 11.

  • 5 Days ILT, VILT

    Oracle Service Bus enables companies to unlock the value of their enterprise applications portfolio. From on-premise, to the cloud to mobile devices and to the future, Oracle Service Bus allows companies to leverage their existing investments in whole new ways.
    Oracle Service Bus extends the performance and scalability leadership of Oracle SOA Suite and Oracle API Management.

    This Oracle Service Bus 12c: System Admin, Design & Integrate Accel Ed 1 training is a hustled course encompassed of Oracle Service Bus 12c: Design and Integrate Services and Oracle Service Bus 12c: Administration (2 days) courses. Explore how Oracle Service Bus can help our enterprise integration without having to write our own integration logic for every application.

  • OWS12c: Oracle WebLogic Server 12c: Administration I

    Price range: RM6,500.00 through RM7,603.00
    5 Days ILT, VILT

    Oracle WebLogic Server 12c: Administration I

    This training will teach students about configuration of WebLogic Server’s authentication provider and create a WebLogic Server domain. After completing this course, students will also learn how to back up a WebLogic Server Domain and restore a WebLogic Server Domain. This course is best suited Technical Administrators, Java EE Developers, and System Administrators.

  • 5 Days ILT, VILT

    This course is designed for experienced WebLogic administrators who have completed the ” Oracle WebLogic Server 12c: Administration I” course. After completing this training, students will be able to understand advanced concepts of WebLogic administration, including WLST, Advanced Deployment and JDBC features. This course is best suited for Java EE Developers, Security Administrators, System Administrators, Technical Administrators, Technical Consultants, and Web Administrators.

  • 5 Days ILT, VILT

    This OL8-SA1: Oracle Linux 8: System Administration I course is first in a series of three Oracle Linux 8 System Administration courses that covers the system administration tasks. The lab environment is validated against the latest Oracle Linux 8 release.

  • 5 Days ILT, VILT

    The Oracle Linux System Administration I course covers a range of skills including installation, using the Unbreakable Enterprise Kernel, configuring Linux services, preparing the system for the Oracle Database, monitoring and troubleshooting.

    This course teaches you how to handle common tasks faced by administrators. You learn to understand the kernel development model and learn about Linux distributions. You hear about Oracle’s comprehensive solution and Oracle’s contributions to the Linux community.

  • 5 Days ILT, VILT

    This is an advanced-level course that offers in-depth hands-on experience to candidates. The training provides exposure to high-level system administration tasks. In other words, it primarily polishes the skills learnt in the Oracle Solaris 11 System Administration course.

  • 5 Days ILT, VILT

    The Oracle Solaris Cluster 4.x Administration Ed 4 course provides students with the essential information and skills needed to install and administer Oracle Solaris Cluster 4.3 hardware and software systems. Students are introduced to Oracle Solaris Cluster 4.3 hardware and software product features, hardware configuration, software installation along with configuration, data service configuration, and system operation. Students will get the opportunity to explore various use cases such as integrating Oracle database 12c as failover application, configuring Oracle Solaris cluster using unified archives.

  • 5 Days ILT, VILT

    This Oracle Solaris 11 Performance Management training course introduces you to performance tuning principles. Oracle Solaris 11 Performance Management training course helps you understand monitor utilities and use tuning tools for the Oracle Solaris 11 Operating System.

  • 5 Days ILT, VILT

    The course on Oracle Linux System Administration covers up a variety of skills such as, installation, troubleshooting and monitoring, employing the Unbreakable Enterprise Kernel, constructing the Linux services, and setting up the system for Oracle Database.

    This course educates trainees on how to handle usual problems encountered by administrators in authenticating, monitoring and security.

  • 2 Days ILT, VILT

    Ansible provides you a solution to the tedious task of administering a server fleet. Ansible provides a platform for configuring and managing compute instances.

    In this course, you will learn the basics of working with Ansible in OCI, including installation and configuration. Also, you will discover the benefits of Infrastructure as Code (IaC) via Ansible, understand and create the building blocks for Ansible to be used in the form of playbooks. Lastly you will be able to create playbooks and configure and manage resources on OCI.

  • 2 Days ILT, VILT

    In this course, you will learn to install the Go and Typescript SDKs for OCI and write codes to deploy various core OCI Services.

  • 2 Days ILT, VILT

    Oracle Cloud Infrastructure provides a number of Software Development Kits (SDKs) and a Command Line Interface (CLI) to facilitate development of custom solutions. In this course, learn to install the Python SDK for OCI along with OCI CLI and write code to deploy various core OCI Services.

Go to Top