You searched for: ""

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

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

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

  • 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

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