You searched for: ""

  • 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.
  • 5 Days ILT, VILT

    The Perl Programming course is a comprehensive course that explains the Perl programming language, from basic through advanced syntax. This course is aimed at a wide range of job roles, including Programmers, System Administrators, Web Authors, and Operators. The course provides the fundamentals needed to use the Perl programming language to write quick yet powerful scripts for a range of purposes, as well as provides an overview of Common Gateway Interface Programming, Object-Oriented Perl and Perl Debugging.

    The course is taught on the Oracle Solaris Operating Environment. However, the material is suitable for any operating system, including Linux, UNIX, and Windows.

    Learn To:

    • Describe the Perl Programming Language.
    • Implement Scalars.
    • List Control Structures.
    • Implement Arrays.
    • Describe Hashes.
    • Implement Basic I/O and Regular Expressions.
    • Describe Subroutines and Modules.
    • Manipulate Files and Directories.
    • Implement Perl.

    Benefits To You

    The Perl Programming course provides students with the fundamentals to create functional Perl scripts. The course introduces students to data structures, flow control mechanisms, regular expressions, and subroutines and modules in the form of example scripts and lab scripts. The course concludes with an overview of implementing Perl with regard to Common Gateway Interface (CGI) Programming, Object-Oriented Perl and Perl Debugging. This course however, does not cover the construct of the Perl Programming Language itself or complex Perl functions used for high-level programming. Rather, it focuses mainly on the implementation of the language to create simple and functional Perl scripts.

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

    Price range: RM5,750.00 through RM6,812.00
    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.
  • 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.

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

  • 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.
  • 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.
  • 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.
  • 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.
  • 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
Go to Top