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.

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

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

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

    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.

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

    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,000.00 through RM6,062.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.
  • 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.

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

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

Go to Top