Oracle Training and Certification

Tackle performance, availability, security, and compliance with Oracle Database products.

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.

Earning Oracle Database certification helps you achieve more, faster, with fewer resources, empowers you with the skills and gives you an edge over the competition.

From basics to advanced curriculum, learn everything you need to know about management, development, security, and enabling high availability and data warehousing in Oracle Database versions 19c, 18c, 12c, 12c R2, and 11g.

Tackle performance, availability, security, and compliance with Oracle Database products.

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.

Earning Oracle Database certification helps you achieve more, faster, with fewer resources, empowers you with the skills and gives you an edge over the competition.

From basics to advanced curriculum, learn everything you need to know about management, development, security, and enabling high availability and data warehousing in Oracle Database versions 19c, 18c, 12c, 12c R2, and 11g.

  • 4 Days ILT, VILT

    The best database architecture for the hybrid cloud.

    The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. Through a blend of hands-on labs and interactive lectures, you will explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs).

  • 1 Day ILT, VILT

    Gain skills and knowledge needed to design and implement security policies to protect data from accidental, unauthorized, or inappropriate actions. 

    After completing this course, you will have the skills and knowledge necessary to design and implement security policies to protect data from accidental, unauthorized, or inappropriate actions. You will also be able to create and enforce practices of auditing and accountability for such actions. In addition, you will be able to develop applications that provide desired services securely in a variety of computational models, making use of database and directory services to maximize both efficiency and ease of use. This course is therefore essential for anyone who wants to work in the field of computer security.

  • 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

    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

    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
  • 1 Day ILT, VILT

    This OD-19c-SF: Oracle Database 19c: Security Fundamentals course teaches you Security aspect related to the latest release of Oracle Database (19c).

     

  • 3 Days ILT, VILT

    Learn to write well-tuned SQL statements for the Oracle database.

    This Oracle Database course teaches you how to write well-tuned SQL statements appropriate for the Oracle database. This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning.

    MySQL Cloud Service provides numerous benefits over an on-premise database. It is easy to create a cloud instance, with flexible options for computing power, memory, and storage. GUI tools are available for backup and restore as well as patching and rolling back. After completing this course, you can take advantage of those benefits to use MySQL Cloud Service to its best advantage.

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

  • 3 Days ILT, VILT

    Oracle SOL Tuning for Developers Workshop course helps you learn how plans are tuned execution of Oracle SOL statements. You will learn how to write well-tuned SOL statements out of the box that are perfectly suited to Oracle DBMS.

     

  • 5 Days ILT, VILT

    This course is targeted at Database Administrators and begins with explaining the architecture of an Oracle Database instance and the tools used to access it. The course includes creating and managing a database, configuring and managing Oracle Net Services along with creating and administering pluggable databases (PDBs). You learn how to create and manage database storage, users, backup, and implement database security.

    Additionally, the course covers protection of database against failures, loading, and transporting data.

  • 5 Days ILT, VILT

    This course is targeted at Developers and Database Administrators and begins with the concepts of a relational database and the SQL programming language. It includes writing queries against single and multiple tables, manipulate data in tables, and create database objects.

    You’ll also learn how to create sequences, synonyms, indexes, and views, manage schema objects, and manage data using subqueries. Additionally, the course covers controlling User Access and managing data in different time zones.

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